ETL Informatica Test Engineer Job at Neshent Technologies, Irvine, CA

  • Neshent Technologies
  • Irvine, CA

Job Description

We are seeking an experienced ETL Informatica Test Engineer with strong expertise in ETL testing, data validation, data warehousing, and Informatica PowerCenter. The ideal candidate will be responsible for validating end-to-end data integration processes and ensuring data accuracy, completeness, consistency, and integrity across source and target systems.

The candidate should have strong SQL skills, hands-on experience in ETL and data warehouse testing, and a solid understanding of data transformation rules, source-to-target mappings, and data reconciliation techniques.

Roles and Responsibilities
  • Analyze business requirements, ETL specifications, source-to-target mappings, and data models to develop effective test strategies.
  • Design, develop, and execute test cases, test scenarios, and test scripts for ETL and data warehouse projects.
  • Validate data extraction, transformation, and loading processes developed using Informatica PowerCenter.
  • Perform source-to-target data validation, data reconciliation, and record count verification.
  • Execute functional, integration, system, regression, and user acceptance testing (UAT) activities.
  • Develop and execute complex SQL queries to validate backend data, transformation logic, aggregations, and business rules.
  • Validate data quality, data integrity, data completeness, and consistency across source and target databases.
  • Test large-volume data migrations and complex data transformation processes.
  • Identify, document, track, and report defects using defect management tools, and collaborate with development teams to resolve issues.
  • Work closely with ETL developers, business analysts, data architects, and other stakeholders to clarify requirements and resolve data-related issues.
  • Support production deployments and perform post-release data validation and reconciliation.
  • Participate in test planning, effort estimation, test execution tracking, status reporting, and Agile Scrum ceremonies.
  • Contribute to continuous improvement of ETL testing processes, test automation, and quality assurance practices.
Required Technical Skills and Qualifications
  • Strong experience in ETL testing, data warehouse testing, and backend data validation.
  • Hands-on experience with Informatica PowerCenter and its associated tools, including Workflow Monitor, Repository Manager, Designer, and Workflow Manager.
  • Strong SQL querying skills, including complex joins, subqueries, aggregations, and data comparison techniques.
  • Experience with relational databases such as Oracle, Microsoft SQL Server, Teradata, PostgreSQL, or Snowflake.
  • Solid understanding of data warehousing concepts, including fact and dimension tables, star and snowflake schemas, data marts, and enterprise data warehouse architecture.
  • Experience validating data extraction, transformation, loading, and business transformation rules.
  • Knowledge of data quality testing, data integrity, data profiling, and reconciliation techniques.
  • Experience with defect tracking and test management tools such as JIRA, HP ALM/Quality Center, or Azure DevOps.
  • Experience testing large datasets, data migrations, and complex data integration workflows.
  • Understanding of functional, integration, regression, system, and UAT testing methodologies.
Preferred Qualifications
  • Exposure to cloud data platforms such as AWS, Microsoft Azure, or Google Cloud Platform (GCP).
  • Familiarity with big data technologies such as Databricks, Hadoop, and Apache Spark.
  • Knowledge of test automation using Python or Selenium.
  • Understanding of CI/CD pipelines and DevOps practices.
  • Experience working in Agile/Scrum development environments.
  • Relevant certifications in Informatica, ETL testing, data engineering, or related technologies.
Education
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • Relevant professional certifications are an added advantage.

Job Tags

Contract work

Similar Jobs

Chevron

Firefighter Trainee Job at Chevron

 ...business unit is accepting online applications for the position of Firefighter Trainee located in Richmond, CA through November 18th, 2026,...  ...Qualifications: Any firefighting experience within a Municipal, Wildland, Industrial, Private, or Military fire department.... 

Elevance Health

RN Clinical Review Nurse I Job at Elevance Health

 ...Anticipated End Date: 2026-11-10 Position Title: RN Clinical Review Nurse I Job Description: Clinical Review Nurse I Wellpoint...  ...Skills, Capabilities, and Experiences: Home Health or Hospice is very strongly preferred. Knowledge of Medicare guidelines... 

Archer Daniels Midland Company

Pilot Apprentice - St Louis, MO Job at Archer Daniels Midland Company

 ...Pilot Apprentice St Louis, MOThis is a full-time, non-exempt level position.Position Summary...  ...to safely and efficiently operate towing vessels on the Inland Waterways.Job...  ...laddersAbility to work near or on large bodies of water, at various heights and in confined spacesExcited... 

Center Street Family Dentistry

Endodontist - Camp Hill, Pennsylvania Job at Center Street Family Dentistry

 ...and carrying up to 45 pounds when necessary, ensuring your physical stamina aligns with the demands of the role. \n \n \n ~ Virtual and In-Person Training: Availability to attend periodic virtual training sessions (or in-person when required) throughout the year... 

PACS Group

MDS LVN Nurse: Full-Time, Care Planning & Compliance Job at PACS Group

 ...City View Post Acute in San Francisco, CA is seeking a meticulous MDS Nurse (LVN) for a full-time role. You will complete MDS 3.0 assessments, CAAs, and ensure compliant documentation to support care planning and reimbursement. Collaborate with an interdisciplinary...