ETL Tester

Ascendion; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Ascendion is seeking an experienced ETL Test Engineer for the Banking domain. You will validate data extraction, transformation, and loading processes, ensuring accuracy across enterprise data platforms and banking applications.

Responsibilities include designing ETL test scenarios, executing test scripts, validating source-to-target mappings with SQL, and monitoring scheduled jobs using Control-M while collaborating with analytics and development teams.

Qualifications

• 5+ years of ETL/Data Testing experience in Banking/Financial Services.
• Strong SQL skills with complex joins, subqueries and data reconciliation.
• Hands-on experience with Informatica PowerCenter or equivalent ETL tools.
• Experience using Control-M for batch scheduling and monitoring.
• Knowledge of data quality, validation, and data warehouse concepts.

Responsibilities

• Design and execute ETL test scenarios, test cases, and scripts for complex data integrations.
• Perform end-to-end ETL testing to validate data completeness and accuracy.
• Validate source-to-target mappings using SQL and verify transformation logic.
• Test Informatica workflows, sessions, and mappings; monitor scheduled jobs with Control-M.
• Collaborate with Analysts, Developers and QA to ensure quality delivery.

Skills

ETL Testing

SQL

Informatica PowerCenter

Control-M

Banking Domain Knowledge

Tools

Informatica PowerCenter

Control-M

Job description

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

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

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