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.