Data Migration Specialist

SID Global Solutions; Manila; On-site; PHP 1,800,000 - 2,600,000; Full time

Job summary

SID Global Solutions is seeking an experienced Data Migration Lead to drive enterprise data migration initiatives, ensuring data quality and minimal business disruption. The role requires leadership, planning, and strong stakeholder management across ETL teams and business units.

The ideal candidate will design migration strategies, map source-to-target data, and oversee validation, testing, and cutover activities while maintaining compliance with data governance standards.

Qualifications

• Extensive experience leading end-to-end data migration programs.
• Strong SQL skills and experience with Oracle, MSSQL, MySQL.
• Proven ability to manage cross-functional teams and stakeholders.
• Experience with data governance, security, and quality standards.

Responsibilities

• Lead end-to-end data migration projects from planning through post-migration support.
• Define migration strategy, timelines, and execution plans.
• Collaborate with stakeholders to gather and validate requirements.
• Develop and maintain STTM documents and data mappings.
• Perform profiling, cleansing, transformation, validation, and reconciliation.
• Coordinate rehearsals, cutovers, and production deployments.
• Develop rollback and contingency plans to minimize risk.
• Monitor progress and provide regular status updates to stakeholders.
• Lead ETL/DBA/BA/QA teams and ensure governance and security compliance.

Skills

Data Migration

End-to-end Migration

Legacy System Migration

Data Mapping

Data Transformation

Data Cleansing

Data Profiling

Data Validation

Migration Cutover

Rollback Planning

Agile/Scrum

Resource Planning

Stakeholder Management

Project Planning

Status Reporting

Communication Skills

Leadership

Mentoring

Cloud AWS

Python

Shell Scripting

PowerShell

Git

Jenkins

Kafka

Snowflake

Databricks

API Integration

Education

Bachelor's degree in CS/IT/Engineering

Tools

Talend

Microsoft SSIS

IBM DataStage

AWS Glue

SnapLogic

Dell Boomi

Job description

We are seeking an experienced Data Migration Lead to drive end-to-end data migration initiatives for enterprise applications. The ideal candidate will have extensive experience in planning, designing, and executing complex data migration projects while ensuring data quality, integrity, and minimal business disruption. This role requires strong technical expertise, leadership capabilities, and excellent stakeholder management skills.

Key Responsibilities

• Lead end-to-end data migration projects from planning through post-migration support.
• Define migration strategy, approach, timelines, and execution plans.
• Collaborate with business stakeholders to gather and validate migration requirements.
• Develop and maintain source-to-target mapping (STTM) documents.
• Perform data profiling, analysis, cleansing, and transformation activities.
• Design and execute data validation and reconciliation processes.
• Coordinate migration rehearsals, mock runs, cutover activities, and production deployments.
• Develop rollback strategies and contingency plans to minimize operational risks.
• Identify migration risks, dependencies, and mitigation strategies.
• Monitor project progress and provide regular status updates to stakeholders.
• Lead cross-functional teams, including ETL developers, database administrators, business analysts, QA teams, and business users.
• Ensure adherence to data governance, compliance, security, and quality standards.
• Support User Acceptance Testing (UAT), System Integration Testing (SIT), and production validation activities.
• Prepare migration documentation, runbooks, technical specifications, and operational handover documents.

Required Skills

Data Migration

• End-to-end Data Migration Lifecycle
• Legacy System Migration
• Data Mapping
• Data Transformation
• Data Cleansing
• Data Profiling
• Data Validation
• Migration Cutover Planning
• Rollback Planning

Database Technologies

• Advanced SQL
• Oracle
• Microsoft SQL Server
• MySQL
• DB2 (Preferred)

ETL & Integration Tools

Experience with one or more of the following:

• Talend
• Microsoft SSIS
• IBM DataStage
• AWS Glue
• SnapLogic
• Dell Boomi

Experience with at least one cloud platform:

• Amazon Web Services (AWS)

Data Quality & Governance

• Data Governance
• Master Data Management (MDM)
• Metadata Management
• Data Quality Frameworks
• Regulatory Compliance

Project & Delivery

• Agile/Scrum
• Resource Planning
• Stakeholder Management
• Project Planning
• Status Reporting

Documentation

• Source-to-Target Mapping (STTM)
• Functional Specifications
• Technical Specifications
• Migration Runbooks
• Cutover Plans
• Rollback Plans

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Certifications in Cloud (AWS/Azure/GCP), Informatica, or Project Management (PMP, Scrum Master) are an advantage.
• Experience working in Banking, Financial Services, Insurance (BFSI), Healthcare, Retail, or Enterprise Digital Transformation projects is preferred.

Soft Skills

• Excellent communication and presentation skills.
• Strong analytical and problem-solving abilities.
• Proven leadership and mentoring experience.
• Ability to manage multiple stakeholders across business and technical teams.

Nice-to-Have Skills

• Python
• Shell Scripting
• PowerShell
• Git
• Jenkins
• Kafka
• Snowflake
• Databricks
• API Integration

Success Criteria

• Successful delivery of large-scale enterprise data migration programs.
• High data accuracy and reconciliation rates.
• Effective stakeholder communication and project governance.
• Compliance with organizational data quality and security standards.