Responsibilities
- Define end-to-end data migration strategy and execution approach.
- Perform source system analysis and data discovery.
- Develop migration plans, timelines, and cutover activities.
- Assess migration risks and mitigation strategies.
- Analyse source and target data models.
- Define field-level data mappings and transformation rules.
- Identify data cleansing requirements.
- Validate business rules with functional stakeholders.
- Develop and execute ETL processes.
- Extract data from multiple source systems.
- Transform data according to business requirements.
- Load data into target applications.
- Monitor migration performance and resolve failures.
- Perform data profiling and quality assessment.
- Identify duplicate, incomplete, or inconsistent data.
- Execute cleansing and enrichment activities.
- Ensure compliance with data governance standards.
- Support SIT, UAT, and production rehearsals.
- Perform reconciliation between source and target systems.
- Validate migrated data with business users.
- Resolve migration defects.
- Execute production migration activities.
- Support mock migrations and dress rehearsals.
- Coordinate with infrastructure and application teams.
- Support hypercare after go-live.
- Prepare migration runbooks.
- Maintain mapping documents.
- Document migration procedures.
- Produce reconciliation reports.
- Maintain audit evidence.
Requirements
- Bachelor in Computer Science / Technology with at least 5 years of experience in data migration or data engineering.
- Experience delivering large-scale transformation or migration programmes.
- Hands-on experience with ETL tools.
- Experience migrating structured and unstructured data.
- Strong SQL skills.
- Experience with data validation and reconciliation.
- Experience working in Agile and Waterfall delivery environments.
- Technical Skills required :
1. SQL
2. ETL development
3. Data profiling
4. Data cleansing
5. Data reconciliation
6. Data modelling
7. Database administration basics
8. Performance tuning
9. Migration automation
10. Databases : Oracle , SQL Server, PostgreSQL, MySQL, DB2
11. ETL / Integration Tools : Informatica, Talend, SSIS, Azure Data Factory, AWS Glue, IBM DataStage
12. Ideally with Cloud experience : Microsoft Azure, AWS, Google Cloud Platform
13. Scripting : Python, PowerShell, Shell scripting
Licence no: 12C6060
Pay: Up to $11,000.00 per month
Work Location: In person