In this role you will deal with:

• Preparing comprehensive test scenarios and detailed test cases for migrated data and transformations
• Validating Bronze-layer data against source systems to ensure accuracy and completeness
• Performing source-to-target data reconciliation across Bronze, Silver, and Gold layers
• Validating record counts, field values, transformations, duplicates, and overall data completeness
• Investigating data discrepancies between source and target systems
• Defining and implementing validation rules and acceptance criteria for data migration
• Maintain thorough test evidence and clearly document all test results and findings
• Preparing and updating technical and testing documentation throughout the project lifecycle
• Collaborating with Data Engineers and the Lead Data Engineer to clarify requirements and resolve technical issues
• Participating in defect analysis, retesting, and regression testing activities as needed.

We'd love to hear from you if you have:

• Hands-on experience with data quality assurance, data QA, or ETL/data testing (3+ years)
• Solid knowledge of SQL, with practical ability to write and optimize queries for data validation and reconciliation
• Applied experience in data migration testing or ETL/ELT testing
• Solid experience validating data between source and target systems
• Exposure to data quality dimensions such as completeness, accuracy, consistency, uniqueness, and validity
• On-the-job experience in creating and executing test cases and test scenarios
• Solid experience in data reconciliation, including comparison of record counts and field-level data
• Ability to investigate and diagnose data discrepancies, distinguishing issues arising from source data, transformation logic, or target systems
• Strong attention to detail and proven ability to work effectively with large and complex datasets
• Practical application in preparing and maintaining clear technical and testing documentation
• Ability to work independently and communicate findings and issues effectively to developers and technical leads
• Good English communication skills for documentation and stakeholder interaction.

Nice to have:

• Exposure to Azure Synapse Analytics and Azure Data Factory
• Basic understanding of testing PySpark, data lake, and lakehouse solutions
• Familiarity with SQL Server and Azure SQL
• Awareness of Medallion data architectures.