Data Migration Specialists/ Consultants (Ref 26537)
Job Description
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 :
- SQL
- ETL development
- Data profiling
- Data cleansing
- Data reconciliation
- Data modelling
- Database administration basics
- Performance tuning
- Migration automation
- Databases : Oracle , SQL Server, PostgreSQL, MySQL, DB2
- ETL / Integration Tools : Informatica, Talend, SSIS, Azure Data Factory, AWS Glue, IBM DataStage
- Ideally with Cloud experience : Microsoft Azure, AWS, Google Cloud Platform
- Scripting : Python, PowerShell, Shell scripting
Licence no: 12C6060