Data Analyst & ETL Test Engineer Resume WI - Hire IT People

SUMMARY

Over 8 Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Data warehouse Testing and Data Analysis.
Proven working experience as a business data analyst.
Strong analytical and problem solving skills with attention to detail and accuracy.
Proficient in DW/BI (ETL) Testing, Database Testing, Report Testing and Data Migration Testing.
Experience in designing, documenting, and executing test plans, test scenarios/scripts, test completion reports & test cases for manual, automated & bug tracking tools.
Experience developing automation scripts using Python for testing new features, and continual expansion on regression test cases.
Working Knowledge of Defect management process, Software Development life cycle and Software test life cycle.
Strong background in both Agile (Scrum)/Waterfall Methodologies.
A very proactive team player with excellent communication (Verbal and Written), presentation and reporting skills.

TECHNICAL SKILLS

Data Warehouse & ETL Tools: Ab initio v3.1.5, SSIS, Talend

RDBMS: Teradata, Oracle, Microsoft SQL Server 2012, Microsoft SQL Server 2016, MySQL

Programming Language: Python 3.8, Java

Defect Tracking: JIRA, HP Quality Center 11.0

Tools: / Utilities: Putty, Winscp, Toad, Attunity, Tandem, PyCharm

Operating Systems: Unix, Windows

Domain Knowledge: Banking, Cards, Investment Banking, Retail

PROFESSIONAL EXPERIENCE

Data Analyst & ETL Test Engineer

Confidential, WI

Responsibilities:

Actively participate in walk - through, inspection, review and user group meetings for Quality Assurance.
Develop and maintain knowledge of data available from upstream sources and data within various platforms.
Performed data quality analysis using advanced SQL skills.
Provide data analysis and requirements to teams and prepare ad-hoc reports.
Migration testing of the DB by writing SQL queries to test the integrity of the application.
Write and execute various MYSQL database queries from Python using Python-MySQL connector and MySQL DB package.
Used Python scripts to update content in the database and manipulate files.
Investigating issues occurred while System testing, Regression testing and UAT.
Reconciliation report validation and report testing.
Create daily/Weekly status reports for stakeholder and identify risks & issues and provide mitigation plans
Create, compile and provide Data Reconciliation, Test completion Reports and Metrics.

Senior ETL Test Analyst

Confidential

Responsibilities:

Participate in the walkthrough of Requirements, Design Documents, Data Models and Data Mapping.
Perform Data Migration, Database Testing by writing advanced SQL queries.
Create and maintain the Test Plan, Test Scenario, Test Cases and Test Scripts to validate source and Target data.
Verify that data is transformed correctly according to various business requirements and data mapping.
Isolate, replicate, and report defects and verify defect fixes.
Perform Report Testing and validate results for the possible defect.

ETL Test Engineer

Confidential

Responsibilities:

Prepared Test Cases and Test Plans for the mappings developed through the ETL tool.
Involved with ETL test data creation for all the ETL mapping rules based on mapping document.
Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
Used Quality Center to track and report system defects.
Involved in defect triage meetings.