Etl Qa Tester

Galina Semenova

U.S. Status: Citizen Location: Palatine, IL

(847-***-**-** **********@*****.***

Professional 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;

●Skilled in testability check of BRD, FRD and Data Mapping documents;

●Hands-on experience in using Beyond Compare tool to validate data between files;

●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.

Professional experience:

ETL Tester

Old National Bank 2019 - Present

Project: Enterprise Data Warehouse

QA Testing Scope was to validate multiple sources such as database tables, flat files, excel files to Data Warehouse, that was later used for reporting and data analysis purposes. Validated that data was extracted, transformed and loaded correctly according to the Data Mapping Document. Automated ETL comparison of csv flat files to databases using Python and Panda libraries.

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

Alliant Credit Union Financial 2017-2019

Projects: Actimize anti-money laundering application

Compliance group uses Actimize anti-money laundering (AML), suspicious transaction monitoring (SAM) solution, to meet the requirements of OCC/FinCEN regulators.

The Scope of QA included GUI functional testing of Risk Case Manager (RCM), testing of roles and permissions-based security test cases.

ETL back-end testing included validation of source bank databases migrated correctly into Actimize target databases.

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

New York Life Insurance 2015 – 2017

Projects: Worked on converting Web based applications into internal Desktop applications, performed API testing using Postman. Performed manual functional GUI testing, Database Backend testing. Performed functional system testing and security testing of various external and internal applications for Reporting, Compliance, Operations and Human Resources business groups. Wrote test cases in Postman and executed them.

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.

Core Technical:

Jira, Zephyr

Python, Pandas

Linux, Vi Editor

Azure DevOps

API, Postman

PuTTY

SQL Server

Beyond Compare

HTML, SSIS

IBM Data Stage

MS Word, Excel, Power Point

Education:

●Bachelor’s Degree in Law

Russian State Social University

●Certified QA Engineer

Skillrill IT Bootcamp, NY

Contact this candidate