Data Migration Specialist: ETL Expert with Cloud & SQL

AVENSYS CONSULTING PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

AVENSYS CONSULTING PTE. LTD. is hiring a Data Migration Specialist to lead end-to-end data migration efforts across multiple client environments in Singapore. The role emphasizes data analysis, mapping, and ETL execution to ensure accurate and timely migrations.

You will collaborate with stakeholders, define transformation rules, and drive quality data through validation and testing activities, with a focus on impact assessment and risk mitigation.

Qualifications

• Minimum 5 years of experience in data migration, data engineering, or related roles.
• Experience delivering large-scale data migration or transformation projects.
• Strong SQL skills and hands-on experience with ETL tools.
• Experience with structured and unstructured data, including data validation.
• Cloud exposure (Azure, AWS, or GCP) and scripting languages (Python, PowerShell, or Shell).
• Experience working in Agile and/or Waterfall delivery environments.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Define end-to-end data migration strategy and execution plan.
• 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 and map fields.
• Define transformation rules and data cleansing requirements.
• Develop and execute ETL processes and load data to targets.
• Monitor migration performance and resolve failures.
• Validate migrated data with business users and stakeholders.
• Prepare runbooks and reconciliation reports.
• Coordinate with infrastructure and application teams for cutover.
• Support hypercare after go-live.

Skills

Data migration

Data engineering

SQL

Analytical thinking

Communication

Agile/Waterfall

Tools

ETL tools

Python

PowerShell

Shell

Azure/AWS/GCP

Job description

AVENSYS CONSULTING PTE. LTD. is hiring a Data Migration Specialist to lead end-to-end data migration efforts across multiple client environments in Singapore. The role emphasizes data analysis, mapping, and ETL execution to ensure accurate and timely migrations.

You will collaborate with stakeholders, define transformation rules, and drive quality data through validation and testing activities, with a focus on impact assessment and risk mitigation.