QA ETL Informatica Test Lead

Tasks

• Design and execute ETL test cases, test scenarios, and test scripts.
• Perform source-to-target data validation, reconciliation, and data quality testing.
• Validate data extraction, transformation, and loading processes using Informatica PowerCenter.
• Write complex SQL queries for backend data validation.
• Execute functional, integration, regression, system, and UAT support testing.
• Identify, track, and report defects while collaborating with cross-functional teams.
• Support production deployments and post-release validation.

Requirements

• Strong experience in ETL Testing and Data Warehouse Testing.
• Hands-on experience with Informatica PowerCenter, Workflow Monitor, Repository Manager, Designer, and Workflow Manager.
• Strong SQL skills and experience with databases such as Oracle, SQL Server, Teradata, PostgreSQL, or Snowflake.
• Knowledge of data warehousing concepts, fact and dimension tables, star and snowflake schemas.
• Experience with defect management tools such as JIRA, HP ALM/Quality Center, or Azure DevOps.
• Understanding of data migration, data reconciliation, and data quality validation.
• Familiarity with cloud platforms, Agile/Scrum, and CI/CD practices is a plus.

Schedule

• Hybrid – 3 days per week onsite

How to apply

• Share your updated resume by email.

Location

• Irvine, CA