> Markdown version of [/jobs/ext/4446580-etl-informatica-testing-engineer](https://www.wearedevelopers.com/jobs/ext/4446580-etl-informatica-testing-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Informatica Testing Engineer

- **Company:** SOMERSET STAFFING LLC
- **Location:** Irvine, CA, United States
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, JIRA, Microsoft Azure, Big Data, Databases, Continuous Integration, Data Validation, Information Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Warehousing, Database Testing, DevOps, HP Quality Centers, Python (Programming Language), PostgreSQL, Microsoft SQL Server, Oracle (Applications), Scrum Methodology, Cloud Services, Selenium, SQL Databases, Systems Integration, Teradata SQL, Test Data, Data Processing, Freeform SQL, Informatica Powercenter, Snowflake, Apache Spark, Test Scripts, Hp Alm, Backend, Information Technology, Star Schema, Databricks
- **Published:** October 11, 2026
- **Apply:** https://www.careerbuilder.com/job-details/etl-informatica-testing-engineer-irvine-ca--4489149e-4829-4deb-91b3-547f2f28bc78

## About the Role

Informatica, Database Extract Transform and Load (ETL), Testing, Test Data, Informatica, Testing, Data Quality, Database Extract Transform and Load (ETL), Validation Testing, Data Processing, * Strong experience in ETL Testing and Data Warehouse Testing.

 * Hands-on experience validating large volume data migrations and transformations.
 * Knowledge of data quality and data reconciliation techniques.
 * Hands-on experience with Informatica PowerCenter, Informatica Workflow Monitor, Informatica Repository Manager, Informatica Designer Workflow Manager.
 * Database SQL, Strong SQL querying skills.
 * Experience with databases such as Oracle, SQL Server, Teradata, PostgreSQL, Snowflake preferred.
 * Experience with JIRA, HP ALM Quality Centre, Azure DevOps.
 * Data Warehouse Concepts, Fact and Dimension tables, Star Snowflake schemas.
 * Data Mart and Enterprise Data Warehouse architecture.
 * Experience with cloud data platforms such as AWS Azure or GCP.
 * Exposure to Big Data technologies Databricks Hadoop Spark.
 * Knowledge of automation testing using Python or Selenium.
 * Experience working in Agile Scrum environments.
 * Understanding of CICD and DevOps practices.
 * Bachelor's degree in computer science information technology engineering or related field.
 * Relevant certifications in Informatica ETL Testing or Data Engineering are preferred.

Skills

Mandatory Skills : Data Testing, ETL Concepts

## Description

We are seeking an experienced ETL Informatica Testing Engineer with strong expertise in data validation ETL testing data warehousing concepts and Informatica PowerCenter.

The ideal candidate will be responsible for validating end-to-end data integration processes ensuring data accuracy completeness and consistency across source and target systems.

 * Analyse business requirements ETL specifications source to target mappings and data models.
 * Design and execute test cases test scenarios and test scripts for ETL Data Warehouse projects.
 * Validate data extraction transformation and loading processes developed using Informatica PowerCenter.
 * Perform source to target data validation and reconciliation.
 * Execute functional integration regression system and UAT support testing.
 * Develop and execute complex SQL queries for backend data validation.
 * Identify track and report defects using defect management tools.
 * Validate data quality data integrity and business transformation rules.
 * Work closely with ETL developers' business analysts' data architects and stakeholders.
 * Support production deployments and perform post release validations.
 * Participate in test planning estimation and status reporting.