Data Migration Tester for Banking Project

Expleo; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Expleo in Chennai invites an experienced Data Migration Tester to validate data migrated from legacy systems. The role requires strong SQL skills and expertise with Oracle/SQL Server and ETL tools.

You will design test cases, execute validations, and coordinate with ETL teams to ensure data integrity and reconciliation. 2–3 years of experience preferred; ISTQB certification is a plus; on-site role in Tamil Nadu.

Qualifications

• Bachelor's degree in computer science or information technology.
• ISTQB certification is a plus.

Responsibilities

• Understand migration requirements and source-to-target mapping.
• Design and execute data migration test cases and scripts.
• Validate data completeness, accuracy, and integrity after migration.
• Perform source-to-target data reconciliation and verification.
• Verify data transformation, cleansing, and enrichment rules.
• Coordinate with ETL developers and QA teams to resolve defects.

Skills

Data Migration Testing

SQL

Relational Databases

ETL Tools

Data Mapping

Test Management Tools

Agile/Scrum

Data Profiling

Education

Bachelor's degree in Computer Science or IT

ISTQB certification (advantage)

Tools

Oracle

SQL Server

PostgreSQL

MySQL

Informatica

Talend

SSIS

Azure Data Factory

Job description

Overview

Data Migration Tester for Banking Project

Seeking an experienced Data Migration Tester to validate and ensure the accuracy, completeness, and integrity of data migrated from legacy systems to target applications. The ideal candidate will have strong SQL queries skills, database, and data validation skills, with experience in end-to-end data migration projects.

Responsibilities

Data Migration Testing

• Understand business and migration requirements, source-to-target mapping documents, and data transformation rules.
• Design and execute data migration test cases, test scenarios, and test scripts.
• Validate data completeness, accuracy, consistency, and integrity after migration.
• Perform source-to-target data reconciliation and verification.
• Verify data transformation, cleansing, and enrichment rules.

Test Execution & Defect Management

• Execute migration validation, system integration, and user acceptance testing support activities.
• Identify, log, track, and retest defects through closure.
• Analyze data discrepancies and collaborate with development and ETL teams for resolution.
• Conduct regression testing following migration fixes.

Database Validation

• Create and execute complex SQL queries to validate migrated data.
• Perform data profiling and data quality assessments.
• Compare source and target database records, ensuring field-level accuracy.
• Validate referential integrity and business rule compliance.

Reporting & Documentation

• Prepare test cases and execution reports.
• Provide migration testing status updates to stakeholders.
• Document defects, test evidence, and migration outcomes.
• Support go-live readiness reviews and post-migration validation.

Qualifications

• Bachelor’s degree in computer science engineering or information technology
• ISTQB certification is an advantage.

Essential skills

• Strong experience in Data Migration Testing.
• Proficiency in SQL for data validation and reconciliation.
• Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
• Knowledge of ETL tools such as Informatica, Talend, SSIS, DataStage, or Azure Data Factory.
• Understanding of data mapping, transformation, and cleansing processes.
• Familiarity with test management tools such as JIRA, Azure DevOps, ALM, or TestRail.

Desired skills

• Experience in Cards Migration Testing
• Experience with cloud migration projects (Azure/AWS/ or GCP).
• Exposure to data warehousing and business intelligence environments.
• Knowledge of automation tools for data validation.
• Experience working in Agile/Scrum methodologies.
• Understanding of Master Data Management (MDM) and Test Data Management

Experience

2 to 3 years of experience in Data Migration Testing