Data Migration Specialists/ Consultants (Ref 26537)

JOBLINE RESOURCES PTE. LTD.; Singapore; On-site; SGD 90,000 - 140,000; Full time

Job summary

JOBLINE RESOURCES PTE. LTD. in Singapore seeks an experienced Data Migration Lead to architect end-to-end migration programs, manage source analysis, data discovery, mapping, and transformation rules.

You will guide ETL development and oversee data validation across complex source-to-target migrations. Responsibilities include developing migration plans, coordinating with stakeholders, and ensuring data quality and governance across Oracle, SQL Server, PostgreSQL, MySQL, and cloud platforms.

Qualifications

• 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.

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.

Skills

SQL

ETL tools

Data validation

Data reconciliation

Agile

Education

Bachelor in Computer Science / Technology

Tools

Informatica

Talend

SSIS

Azure Data Factory

AWS Glue

IBM DataStage

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 :

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