Data Migration Tester for Banking Project

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