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

Aileron Management LLC

Hotel Night Auditor Job at Aileron Management LLC

 ...goes through the early morning. You will be performing routine balancing duties, daily paperwork, and shift reports related to the hotel's business transactions. Job Duties Include: Perform nightly balancing duties Process daily paperwork Complete shift reports... 

Careermine

Environmental Technician Job at Careermine

 ...EPA guidance documents. Communication, training, and interaction with other departments to assist with environmental compliance is an essential part of the Technicians responsibilities.Job ResponsibilitiesInspect waste storage areas, maintenance areas, water basins... 

Gerber moving and storage

Customer Service Representative Job at Gerber moving and storage

 ...seeking a Customer Service Representative in Columbus OH. Full-time remote position. Pay: $23$27 per hour. U.S. applicants only. Entry-...  ...) Previous support experience. Familiarity with online tools. Benefits Competitive hourly wages. Work from... 

Trillium Staffing

Ironworker - Per Diem Offered Job at Trillium Staffing

 ...Ironworker - Per Diem Offered Trillium Construction is hiring industrial ironworkers to work at a paper mill in Hodge, LA. Candidates will install new fabricated steel on an existing structure. Candidates will also be hanging steel. Candidates must be able to bolt... 

CHRISTUS Health

Ultrasound Technician Job at CHRISTUS Health

 ...Job Description Job Description Ultrasound Technologist Full-Time Job Summary The Ultrasound Technologist performs a broad range of routine and advanced sonographic examinations, supports fellow imaging staff as needed, and helps maintain smooth patient flow...