ETL Lead tester-Informatica

ETL Lead Tester - Informatica 
Location: Irvine, CA 

Job Description:
We are looking for an experienced ETL Tester with strong hands-on experience in Informatica ETL testing, data validation, and SQL. The candidate should have experience validating data pipelines, testing ETL workflows, and ensuring data accuracy and quality.

Responsibilities:
Perform ETL testing using Informatica PowerCenter or IICS.
Validate data extraction, transformation, and loading processes.
Write and execute SQL queries to verify source-to-target data.
Perform data reconciliation, data integrity, and transformation testing.
Identify, report, and track defects using defect management tools.
Validate data completeness, accuracy, and consistency.
Work with ETL developers, business analysts, and QA teams to resolve issues.
Perform regression testing and support production data validation.

Required Skills:
Strong experience in ETL testing and Informatica.
Hands-on experience with Informatica PowerCenter or IICS.
Strong SQL skills, including joins, subqueries, and aggregations.
Experience with data warehouse and database testing.
Knowledge of source-to-target mapping and ETL workflows.
Experience with defect tracking tools such as Jira.
Good analytical, communication, and problem-solving skills.