- Company Name
- Michael Page Technology
- Job Title
- Test SME - Data Migration
- Job Description
-
**Job Title**
Test SME – Data Migration
**Role Summary**
Lead the testing of data migration initiatives in a banking environment, ensuring data integrity, consistency, and compliance with governance standards through strategy development, test execution, quality assurance, and stakeholder communication.
**Expectations**
- Deliver end‑to‑end data migration test coverage for multiple concurrent projects.
- Maintain high quality standards, timely defect resolution, and thorough documentation.
- Act as a bridge between technical teams and business stakeholders, translating requirements into test scenarios.
- Continuously improve testing processes and tools to drive efficiency and effectiveness.
**Key Responsibilities**
- Develop comprehensive test strategies, plans, and schedules for data migration activities.
- Design and execute functional, system, and acceptance tests; track and manage defects.
- Perform data profiling, cleansing, transformation validation, and quality checks using profiling tools.
- Map source‑to‑target data fields, validate transformation logic, and manage data lineage.
- Generate detailed testing reports, risk logs (RAID), and post‑migration review documentation.
- Collaborate with project managers, data migration teams, and stakeholders to align objectives.
- Configure and validate data rules, semantic recognition, and tool‑specific settings.
- Approve reference/static data setups for testing and go‑live operations.
- Recommend and implement process and tool improvements based on industry best practices.
**Required Skills**
- Extensive experience in data migration execution and testing.
- Proficiency with ETL tools (Talend, Informatica, SSIS) and migration services (AWS DMS, Azure Data Migration Service).
- Strong SQL skills and familiarity with Oracle, SQL Server, and MySQL.
- Knowledge of data testing principles, data governance, data quality, and remediation.
- Experience with data migration test tools (e.g., Data Gaps ETL Validator, Testing Xperts, Tx tools, Dextrus, Azure Document DB, Beyond Compare).
- Ability to write and test data rules, handle large and small data sets, and perform advanced data analytics.
- Excellent documentation, requirements gathering, and risk management (RAID log) capabilities.
- Problem‑solving mindset, change champion, and capacity to manage multiple projects simultaneously.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Information Systems, Finance, or related field.
- Certified in data migration, ETL, or data governance (e.g., Informatica Certified Professional, Talend Certified Developer, or similar) is preferred.