Resume

Sign in

ETL TESTER

Location:
New York City, NY
Salary:
850000
Posted:
January 06, 2020

Contact this candidate

Resume:

ALBERT YAKHNIN

ETL QA ANALYST

Email: adamlg@r.postjobfree.com

Phone: 917-***-****

Skype; albert.yakhnin

**** ******* ***. *** ** Brooklyn, NY 11214

https://www.linkedin.com/in/albertyakhnin

https://onlinevizitka.com/gic/

PROFESSIONAL SUMMARY

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.

TECHNICAL SKILLS

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.

Web Technologies: JSON, XML, HTML, JavaScript, VBScript.

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

PROFESSIONAL EXPERIENCE

Northwell Health, New Hyde Park, NY May 2019- September 2019

Senior QA ETL Engineer

Perform extensive Data Validation, Data Verification against the data warehouse.

Data warehousing/analysis

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



Contact this candidate