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