Data Migration Tester for Banking Project

Expleo Group; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Expleo Group in Chennai District seeks an experienced Data Migration Tester to validate migrated data for accuracy, completeness, and integrity. The role emphasizes strong SQL skills, database expertise, and end-to-end migration project experience.

The candidate will design and execute migration test cases, perform data reconciliation, and verify transformation rules across Oracle, SQL Server, PostgreSQL, MySQL, and ETL tools like Informatica or Azure Data Factory. ISTQB is an advantage.

Qualifications

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

Responsibilities

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

Skills

Data migration testing

SQL queries

Data validation

ETL validation

Database knowledge

Education

B.E./B.Tech in CS/IT

ISTQB certification (advantage)

Tools

Oracle

SQL Server

PostgreSQL

MySQL

Informatica

SSIS

Azure Data Factory

JIRA

Job description

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