Description

Key Responsibilities

Design and execute ETL test scenarios, test cases, and test scripts for complex data integration processes.

Perform end-to-end ETL testing to validate data completeness, accuracy, transformation logic, and reconciliation.

Validate data across source, staging, and target systems using complex SQL queries.

Test Informatica ETL workflows, mappings, sessions, and transformations.

Perform source-to-target data validation and identify data discrepancies.

Develop SQL queries for data validation, reconciliation, and backend testing.

Monitor and validate scheduled ETL jobs using Control-M.

Analyze job failures, investigate data issues, and work with development teams to resolve defects.

Perform data quality, data integrity, and regression testing across ETL pipelines.

Validate business rules and transformation logic based on functional and technical requirements.

Support defect management, root-cause analysis, and production issue resolution.

Collaborate with Business Analysts, Developers, Data Engineers, and QA teams to ensure quality delivery.

Prepare and maintain test documentation, execution reports, defect reports, and traceability matrices.

Participate in Agile ceremonies and contribute to continuous improvement of testing processes.

Required Skills

Strong hands-on experience in ETL Testing.

Excellent proficiency in SQL, including complex joins, subqueries, aggregations, and data reconciliation.

Hands-on experience with Informatica PowerCenter or equivalent Informatica ETL tools.

Experience working with Control-M for batch scheduling and job monitoring.

Strong understanding of ETL architecture and data warehouse concepts.

Experience validating source-to-target mappings and transformation rules.

Strong understanding of data validation, reconciliation, and data quality processes

Key Skills

Education

Bachelor's degree