ETL QA Analyst

Professional Summary

Detail-oriented ETL Tester with 8 years of experience in data warehousing projects, specializing in validating data accuracy, completeness, and consistency between multiple source systems and target data warehouses. Proficient in designing and executing detailed ETL test plans and complex SQL-based validations. Experienced with Informatica, Oracle, and SQL Server environments. Proven track record of identifying and resolving data quality issues and collaborating effectively with cross-functional teams to ensure robust data solutions.

Technical Skills

• ETL Tools: Informatica PowerCenter, SSIS
• Databases: Oracle 11g/12c, SQL Server 2016/2019
• Languages: SQL (advanced), PL/SQL
• Testing Tools: HP ALM, Jira
• Platforms: Windows, UNIX
• Other: Data profiling, Data mapping, Defect tracking

Professional Experience

Senior ETL Test Engineer

ABC Solutions, Princeton, NJ

July 2018 Present

• Developed and executed comprehensive ETL test plans, test cases, and SQL scripts based on functional and technical design documents.
• Verified data accuracy, completeness, and consistency between multiple source systems and Oracle-based data warehouses.
• Wrote complex SQL queries for backend data validation, reconciliation, and negative testing scenarios.
• Collaborated closely with ETL developers to identify, log, and resolve data quality issues and defects.
• Automated regression testing for recurring ETL loads using SQL scripts and Informatica workflows.
• Worked with Informatica PowerCenter for data extraction, transformation, and loading processes.

ETL QA Analyst

XYZ Tech, Edison, NJ

May 2016 June 2018

• Validated data migration and transformation logic for financial data warehouse solutions.
• Used SQL Server and Oracle for backend data validations and data profiling.
• Prepared and maintained detailed test documentation including test matrices, defect logs, and summary reports.
• Participated in daily scrum meetings and worked closely with business analysts and developers for requirement clarifications.

Education

Bachelor of Science in Computer Science

Rutgers University, New Brunswick, NJ

2016

Certifications

• Informatica PowerCenter Data Integration 10.x Certified
• Oracle Database SQL Certified Associate

Availability

Immediate (Local to Princeton, NJ)

References available upon request.

We specialize in Digital, ERP, and larger IT Services. We offer flexible, efficient and collaborative solutions to any organization that requires IT, experts. Our agile, agnostic, and flexible solutions will help you source the IT Expertise you need. If you are looking for new opportunities, send your profile at Careers.usa@zoneitsolutions.com.

Also follow our LinkedIn page for new job opportunities and more.

Zone IT Solutions is an equal opportunity employer and our recruitment process focuses on essential skills and abilities. We encourage applications from a diverse array of backgrounds, including individuals of various ethnicities, cultures, and linguistic backgrounds, as well as those with disabilities.