Description:
Domain

Banking / Financial Services

Job Summary

We are looking for an experienced Data Migration Tester with 12+ years of hands-on experience in data migration testing, preferably within the banking and financial services domain. The candidate will be responsible for validating data migration processes, ensuring data completeness, accuracy, integrity, and reconciliation between source and target systems.

The role requires strong expertise in ETL/data migration testing, SQL, data reconciliation, database validation, defect management, and banking data, along with the ability to work closely with business, technology, data engineering, and migration teams.experiance in Query surge and Informatica DVO tool

Key Responsibilities

- Lead and execute end-to-end data migration testing across source, staging, and target systems.
- Analyze source-to-target mapping documents, transformation rules, business rules, and migration specifications.
- Develop comprehensive data migration test strategies, test plans, scenarios, and test cases.
- Validate data completeness, accuracy, consistency, integrity, and referential integrity after migration.
- Perform extensive SQL-based data validation and reconciliation between source and target databases.
- Validate data transformation, cleansing, derivation, aggregation, and enrichment rules.
- Perform record-count, field-level, aggregate-level, and financial reconciliation.
- Identify data anomalies, duplicates, missing records, truncation, format issues, and incorrect transformations.
- Test migration of customer, account, transaction, loan, deposit, payment, card, and other banking-related data.
- Validate historical and transactional data migration while ensuring business continuity and regulatory requirements.




- Perform ETL testing and validate data pipelines/jobs where applicable.
- Support mock migrations, dress rehearsals, migration cutover, production validation, and post-migration verification.
- Work with business analysts, data engineers, developers, DBAs, and business users to resolve data-related issues.
- Log, track, prioritize, and manage defects through tools such as Jira, ALM, or similar platforms.
- Perform root-cause analysis for data discrepancies and coordinate corrective actions.
- Prepare daily/weekly migration testing status reports, defect metrics, reconciliation reports, and test completion reports.
- Support UAT, SIT, regression testing, and production validation activities.
- Participate in migration risk assessment, go/no-go discussions, and cutover planning.
- Mentor junior QA/data migration testers and provide technical guidance.

Required Technical Skills
- 12+ years of experience in software testing, with significant experience in data migration testing.
- Strong hands-on experience in data migration / ETL testing.
- Advanced SQL skills for complex queries, joins, subqueries, CTEs, aggregations, and data reconciliation.
- Robust understanding of relational databases such as Oracle, SQL Server, PostgreSQL, DB2, or similar.
- Experience validating source-to-target data mappings and transformation logic.




- Good understanding of ETL/data integration concepts and tools such as Informatica, IBM DataStage, Talend, SSIS, or equivalent.
- Experience with large-volume data validation and reconciliation.
- Knowledge of test management and defect management tools such as Jira, ALM, Azure DevOps, or equivalent.
- Exposure to automation/frameworks for data validation is an advantage.
- Good understanding of XML, JSON, CSV, flat files, APIs, and other data formats.
- Experience working with batch jobs, interfaces, data feeds, and scheduled migration processes.

Data Migration Testing Expertise

The candidate should be able to independently perform:

1. Source Data Validation
2. Source-to-Target Mapping Validation
3. ETL Transformation Testing
4. Data Completeness Validation
5. Data Accuracy Validation
6. Data Reconciliation
7. Duplicate and Missing Record Validation
8. Referential Integrity Testing
9. Business Rule Validation
10. Historical Data Validation
11. Financial/Transaction Reconciliation
12. Mock Migration Validation
13. Cutover and Production Migration Validation
14. Post-Migration Data Verification

Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
- Banking/financial services project experience is strongly preferred.
- Experience in large-scale core banking or banking platform migration projects.
- Experience working in Agile and/or Waterfall delivery environments.
- Knowledge of data governance, data quality, and data lineage concepts.
- Exposure to cloud databases/platforms such as AWS, Azure, or GCP is an advantage.
- ISTQB or equivalent testing certification is desirable.

Enable Skills-Based Hiring No

📌 DWH Tester/ ETL Tester/Test Engineer / Automation Tester (Karnataka)
🏢 LanceSoft Europe
📍 Karnataka