Job Summary

Role Summary: Seeking a highly experienced and dedicated ETL Tester with a deep understanding of data quality, data integrity, and extensive hands-on experience with Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) for testing complex data integration solutions. This senior role requires a strong analytical mindset, meticulous attention to detail, and the proven ability to lead and execute comprehensive testing efforts for critical data pipelines within a healthcare domain.

Essential Responsibilities
- Develop and implement comprehensive ETL test strategies, test plans, and test cases for data warehouse, data lake, and other data integration projects.
- Collaborate with business analysts, data architects, developers, and project managers to understand data requirements, source-to-target mappings, and data transformation rules.
- Perform extensive data quality checks to ensure accuracy, completeness, consistency, and conformity of data moved through ETL processes.
- Validate data loaded into target systems (data warehouses, data marts,



operational data stores) against source systems and transformation logic.
- Utilize advanced SQL queries to analyze data, identify discrepancies, and validate data integrity.
- Identify, document, and track defects and issues related to ETL processes, data quality, and data integrity using JIRA
- Collaborate with ETL developers to troubleshoot and resolve data-related issues.
- Provide regular status reports on testing progress, defect metrics, and overall data quality to stakeholders.
- Extensive experience in testing ETL jobs developed usingInformatica PowerCenter(Workflows, Sessions, Mappings, Transformations).
- Responsible for managing the test data corresponding to the testing approach applied.
- Fully document any unexpected anomalies or defects identified in testing, including transparent instructions on how to recreate each issue.
- Ensure that defects and requirement variances are being approp

📌 Consultant_Test Engineer (Hyderabad)
🏢 enGen Global
📍 Hyderabad