Job Description: ETL Test Engineer – Banking Domain

Position Overview

We are looking for an experienced ETL Test Engineer with strong expertise in ETL Testing, SQL, Informatica, and Control-M, along with hands-on experience in the Banking/Financial Services domain.

The ideal candidate will be responsible for validating data extraction, transformation, and loading processes, ensuring data accuracy and integrity across enterprise data platforms and banking applications.

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

Robust 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 Infor

📌 ETL Tester (Bengaluru)
🏢 Ascendion
📍 Bengaluru