: ETL Test Engineer – Banking Domain

Position Overview

We are looking for an experienced ETL Test Engineer with robust 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

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.

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

Banking / Financial Services Domain Experience Is Mandatory.

Strong analytical and problem-solving skills.

Banking Domain Experience

Candidates should have experience working on banking applications or data environments involving areas such as:

Retail / Commercial Banking

Loans and Lending

Payments

Accounts and Transactions

Customer / Account Data

Cards

Regulatory or Financial Reporting

Core Banking Systems

Preferred Qualifications

Experience with large-scale enterprise Data Warehousing and ETL environments.

Experience with batch processing and production support.

Knowledge of Unix/Linux commands and scripting is a plus.

Experience working in Agile/Scrum environments.

Familiarity with defect management tools such as Jira or ALM.

Strong communication and stakeholder management skills.

Experience

5+ years of experience in ETL/Data Testing or Data Quality Testing, with strong hands-on experience in:

ETL Testing | SQL | Informatica | Control-M | Banking Domain

Must-Have Skills

ETL Testing + SQL + Informatica + Control-M + Banking Domain

📌 ETL Tester (Bengaluru)
🏢 Ascendion
📍 Bengaluru