ETL QA ANALYST
**** ******* ***. *** ** Brooklyn, NY 11214
Versatile, highly qualified, and results-driven Quality Assurance Professional seeking a Technical ETL QA Analyst/QA Analyst role, bringing 10 + years of working experience with ETL, backend and BI front reporting applications.
Solutions-oriented with notable success directing a broad range of ETL testing, data warehousing, and quality assurance initiatives while participating in planning and implementation of systems solutions in direct support of targeted business objectives.
Development Methodologies: Agile, Scrum, Waterfall, Iterative.
Operating System: Windows, Mac OS, Sun Solaris, HP-UX, IBM AIX.
ETL Tools IBM Datastage, Pentaho,MS SSIS, Informatica PowerCenter, DVO, Centerprise Data Integrator.
BI Tools: Tableau, MS SSRS, Cognos, Crystal Reports.
Office Tools: MS Office Suite, MS Project, Microsoft Share Point, Adobe Products.
Testing Tools: DBever, SQL Workbench / J MySQL Workbench, SQLDBX, Compare It, Redgate SQL Data, SQL Server Management Studio, FuseIT, SFDC Explorer, FlySpeed SQL, Diffpdf, dbForge.
Defect and Management Tool: JIRA HP Quality Center.
Scheduling Tools MS Management agent, Autosys.
Languages: SQL, HTML, UML, Korn Shell, XML, VB script.
RDBMS: MS SQL Server, AWS Redshift, MySQL, Oracle, DB2, Sybase, MS Access.
SUMMARY OF QUALIFICATIONS
Working and leading onsite and offshore team members.
Develop and document test scripts, test cases, defect tracking and reports.
Familiar Anti Money Laundering (AML)
Analyze the results of software tests.
Manage test environment for integration testing activities.
Proficient in writing SQL queries to perform data-driven tests and involved in the front - end, and back-end
Experience in testing/validating the Source, Stage and Target (End-to-End).
Automation tools: DVO Informatica, Red Gate, Embarcadero, Beyond Compare, dbForge SQL
Northwell Health, New Hyde Park, NY May 2019- September 2019
Senior QA ETL Engineer
Perform extensive Data Validation, Data Verification against the data warehouse.
Prepare data analytical testing for the BI systems.
Vast experience with format ETL and Data Testing
Work closely with the software developer’s project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle.
Develop and execute detailed ETL related functional, performance, integration, and regression test cases, and documentation.
Analyze and understand the ETL workflows developed.
Remedy Partners Inc., New York, NY August 2018 - April 2019
ETL QA Engineer
Worked in support of the development of company products, tools, platforms, and services.
Validated ETL data developed by AWS ETL Pentaho.
Tested several AWS Redshift Mappings to validate the business conditions.
Provided status metrics on testing.
Executed ETL flows by Pentaho scheduler
Developed and Designed ETL test cases, scenarios, and scripts to ensure quality data warehouse.
Wrote SQL queries to validate ETL logic.
Analyzed source and target databases for conformance to specifications.
Identified duplicate records in the staging area before data gets processed.
Created written test scripts for back-end validations.
Cox Automotive, Inc./ Dealertrack Technologies, New Hyde Park, NY December 2014- August 2018
Senior ETL QA Analyst
Performed data analytical testing for the BI systems.
Validated data transformations and perform End-to-End data validation for ETL & BI systems
Prepared ETL data validation developed using SSIS ETL and Datastage environments.
Exposure to DB tools : SQLdbx,PL SQL developer/,MS Management studio.
Used the DataStage Designer to test processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
Worked with Metadata Definitions, Import, and Export of Datastage jobs using Data stage Manager.
Scheduled Datastage job using the Autosys scheduling tool.
Used T-SQL preparation in MS SQL, Oracle and/DB2 RDBMS
Accelerated knowledge in ETL and BI processes.
OppenheimerFunds, New York, NY August 1999- October 2014
Senior Quality Assurance Analyst
Performed negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
Worked on Informatica Datacenter, runs workflows, monitored the status and logs in Workflow Monitor.
Validated the data moving from multiple sources to target using the Informatica data validation option.
Ran workflow used Informatica Workflow Manager.
Extensively used Informatica for extraction, transformation and loading process.
Executed ETL jobs scheduled in Autosys.
Wrote SQL queries to validate the ETL logic of the application.
EDUCATION & CERTIFICATIONS
Bachelor’s Degree in Engineering – Polytechnic University Nizhniy Novgorod Russia BS
Invention Methodology Certificate- Institute of Invention Nizhniy Novgorod Russia
Computer Science Studies – SYRIT College Brooklyn NY
Writing SQL Queries By Learning Tree International New York, NY
Advanced-Data Warehouse Testing is using SQL RTTS New York, NY
Data Warehouse and ETL Testing Fundamentals RTTS New York NY
Data Warehouse Testing using SQL certificate RTTS New York, NY