Data Migration QA

About the Role

Lexitas is seeking a detail-oriented and technically strong Data Migration QA / Validation Engineer to ensure the quality, accuracy, and integrity of data migration initiatives. This role will be responsible for validating migrated data, designing reconciliation and testing frameworks, and ensuring data readiness throughout the migration lifecycle. This position plays a critical role in delivering high-quality, reliable, and compliant data migration solutions while ensuring smooth deployment processes and maintaining data integrity across business systems.

This is a Full-Time Job located in Chennai, India.

Key Responsibilities

• Responsible for quality in data migration, including accuracy, completeness, integrity, and security of transferred data.
• Design validation strategies, build reconciliation scripts, and sign off on data migration readiness.
• Strong testing experience for pre and post migration validations.
• Write complex SQL queries, automated scripts (Python), or use data quality frameworks to verify data integrity.
• Test ETL workflows, data cleansing rules, and enrichment processes.
• Build and maintain validation frameworks to ensure data quality and integrity.
• Configure and troubleshoot CI/CD pipelines (Bitbucket Pipelines).
• Investigate and resolve data discrepancies and pipeline failures.
• Identify, log, triage, and retest migration discrepancies, collaborating closely with data engineers and ETL developers.
• Collaborate with BAs to understand data requirements and business rules.

Requirements & Tech Stack

• Advanced SQL for data profiling, queries, and reconciliation.
• Strong experience in MySQL database and Python as a programming language.
• Comfortable in Linux.
• Experience in AWS deployment and S3 EC2.
• Experience in Bitbucket, branching models.
• CI/CD experience with Bitbucket/GIT pipeline.
• Working experience with Jira.

Qualifications

• Expertise in SQL, Python, MySQL, ETL testing, and data quality validations.
• Hands-on experience in verifying data accuracy, completeness, security, and consistency across source and target systems.
• Developing automated validation scripts.
• Performing pre- and post-migration testing.
• Investigating data discrepancies.
• Collaborating closely with Business Analysts, Data Engineers, and ETL developers.

Good to have:

• PHP Laravel
• Legal domain experience