ETL Informatica Test Engineer Job at Neshent Technologies, Warren, PA

  • Neshent Technologies
  • Warren, PA

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

Similar Jobs

Gamma Team Security Inc

OFF DUTY Police Officer Job at Gamma Team Security Inc

 ...Gamma Team Security Inc. provides professional security services across multiple states. We are currently hiring active and retired police officers from all departments (Part Time). Gamma Team Security uses a self-scheduling system, in which officers can schedule... 

Aspen Dental

Dental Assistant Job at Aspen Dental

 ...Join Our Team as a Dental Assistant at Aspen Dental! Are you looking for an exciting opportunity to work in the dental industry? Dr Williams is seeking a dedicated Dental Assistant to join our team in York, PA. As a Dental Assistant at Aspen Dental, you will have the opportunity... 

Atlas Group Llc

Excavator Operator Job at Atlas Group Llc

 ...Dental insurance Health insurance Opportunity for advancement Paid time off Vision insurance Are you a high-skilled operator with a commitment to excellence and integrity? Join our team! We're looking for someone eager to grow their skills in a dynamic,... 

WuXi XDC

US Event Marketing Manager Job at WuXi XDC

 ...for an Event Marketing Manager to plan and execute US events and support lead-generation campaigns. This role partners with the local BD team and gathers market insights to support relevant, engaging marketing activities. Key Responsibilities: Event Planning &... 

Crossing Hurdles

Landscaping Supervisor - Remote Team Management | $50/hr Remote Job at Crossing Hurdles

 ...Position: First-Line Supervisor Landscaping, Lawn Service, and Groundskeeping Type: Hourly contract Compensation: $20$50/hour Location: Remote Commitment: 1040 hours/week Responsibilities Supervise and coordinate landscaping and groundskeeping...