Description
You will own end-to-end ETL testing for complex data integration pipelines, ensuring data accuracy, completeness, and transformation logic integrity.
This role is on-site.
Responsibilities
- Design and execute ETL test scenarios, test cases, and scripts for data integration processes.
- Perform source-to-target validation and reconciliation using complex SQL queries.
- Test Informatica workflows, mappings, and sessions to verify transformation logic.
- Monitor and validate scheduled ETL jobs using Control-M and investigate failures.
- Collaborate with developers and business analysts to resolve defects and validate business rules.
Required Skills
- 5+ years of hands-on experience in ETL testing.
- Excellent proficiency in SQL, including complex joins, subqueries, and aggregations.
- Experience with Informatica PowerCenter or equivalent ETL tools.
- Experience working with Control-M for batch scheduling and job monitoring.
- Strong understanding of ETL architecture and data warehouse concepts.
- Experience with Jira, ALM, and Unix/Linux environments.
Preferred Skills
- Experience with data quality testing and data integrity validation.