ETL Tester Resume

SUMMARY

7+ years of professional experience in Functional Manual GUI and Database back - end ETL testing
Well-versed with all stages of Software Development Life Cycle (SDLC) and STLC
Strong understanding of Waterfall and Agile Scrum software development methodologies
Experienced in testing Actimize RCM Transaction Monitoring AML application
Professional in ETL testing and Enterprise Data Warehouse Testing in Banking and Financial domain
Experienced in writing complex SQL queries to validate data migration
Proficient in Test Environment Preparation including Database Backup and Restore
Skilled in testability check of BRD, FRD and Data Mapping documents
Hands-on experience in using Beyond Compare tool to validate data between files
Worked on creating mocked up synthetic data during ETL testing
Expert in Test Case Management and Bug tracking tools such as Azure DevOps and Jira/Zephyr
Experienced in API testing using Postman
Participated in automating ETL data validation between csv flat files and databases using Python and Panda libraries
Worked on creating Test Scenarios, Test Cases using a variety of requirements coverage techniques
Thorough understanding of Linux system, Vi editor, PuTTY tool
Strong analytical, problem solving, attention to details, test to break skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

ETL Tester

Confidential

Responsibilities:

Validated the project documents such as Data Mapping Document and Technical Design Document;
Executed back-end testing, wrote complex SQL queries to validate the data migration across ETL;
Participated in validating csv flat files to databases using Python and Panda libraries;
Created Test Cases, Test Scenarios and Requirement Traceability Matrix;
Performed Deployment as well as database backup and restore;
Compared excel files to database using Beyond Compare tool;
Performed meta-data testing, direct and derived data transformation validation and CDC testing;
Created defects in Azure DevOps Tool and communicated issues to Developer;
Created test data such as Test Plan, Test Evidence and Test Summary;
Reported defects to the developer, performed smoke testing, retesting and regression testing;

Environment: SQL Server, Azure DevOps, Jira, IBM DataStage, Linux, Python, Pandas, Beyond Compare

ETL QA Specialist

Confidential

Responsibilities:

Verified requirements documents such as BRD, FRD, TDD, Data Mapping and Security Matrix;
Analyzed the Actimize User Guide to have better understanding of the Detection Logic for each rule;
Created Test Cases in Jira also converted Epics, User Stories into Test Scenarios and Test Cases;
Created Requirements Traceability Matrix (RTM) linking User Stories and Test Cases;
Wrote complex SQL queries to validate the data migration across ETL based on Data Mapping Document;
Designed defect reports, confirmed the severity of defects, retested and regression tested;
Worked on generation of daily and weekly status reports on test case execution and defects;

Environment: SQL Server,, IBM DataStage, Firefox, Azure DevOps, Jira/Zephyr, Linux, Agile

QA Analyst

Confidential

Responsibilities:

Analyzed test artifacts such as BRD, FRD, TDD, Epics and User Stories;
Assisted in gathering the business requirements and designing the specification documents;
Created test scenarios and designed test cases in MS Excel based on the product requirement documents;
Participated in API testing, using Postman;
Executed test cases to verify the GUI and functional features of the applications;
Verified the correctness of values saved in database tables using SQL queries;
Performed Smoke testing, Sanity testing, Functional testing, Regression testing across various builds;
Produced reproducible bug reports to development team;
Retested the fixed bugs and conducted regression tests on affected modules;
Prepared weekly progress reports to the head of quality assurance department on test cases coverage;

Environment: Jira, Windows, Firefox, Linux, Microsoft Excel, SQL Server.