Lead ETL Tester

Tasks

• Analyze business requirements, ETL specifications, source-to-target mappings, and data models.
• Design and execute test cases, scenarios, and scripts for ETL and Data Warehouse projects.
• Validate ETL processes using Informatica PowerCenter.
• Perform source-to-target data validation and reconciliation.
• Execute functional, integration, regression, system, and UAT testing.
• Develop complex SQL queries for backend data validation.
• Validate data quality, integrity, completeness, and transformation rules.
• Identify, track, and report defects.
• Collaborate with ETL developers, business analysts, data architects, and stakeholders.
• Support production deployments and post-release validation.

Requirements

• ETL Testing
• Data Testing & Validation
• ETL Concepts
• Strong SQL
• Strong experience in ETL Testing and Data Warehouse Testing.
• Hands-on experience with Informatica PowerCenter.
• Knowledge of Informatica Workflow Monitor, Repository Manager, Designer, and Workflow Manager.
• Strong SQL skills with Oracle, SQL Server, Teradata, PostgreSQL, or Snowflake.
• Experience with JIRA, HP ALM Quality Center, or Azure DevOps.
• Understanding of Fact & Dimension tables, Star and Snowflake schemas, Data Marts, and Enterprise Data Warehouses.
• Exposure to AWS, Azure, GCP, Databricks, Hadoop, or Spark is a plus.
• Knowledge of Python/Selenium automation, Agile Scrum, CI/CD, and DevOps practices.
• Bachelor's degree in Computer Science, IT, Engineering, or a related field.

Schedule

• Hybrid – 3 days onsite
• Full-Time

How to apply

• Share your updated resume by email.
• Use the subject: Application – Lead ETL Tester – Irvine, CA

Location

• Irvine, CA