Data Migration Specialist

Avensys Consulting; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

Avensys Consulting is seeking a Data Migration Specialist in Singapore to drive end-to-end data migration programs across source-to-target systems. You will lead data analysis, mapping, ETL design, and validation with stakeholders, ensuring data integrity and timely delivery.

You will work with Oracle/SQL databases, cloud platforms (Azure/AWS/GCP), and scripting (Python/PowerShell). Strong communication and problem-solving are essential for success in this role.

Qualifications

• Minimum 5 years of experience in data migration, data engineering, or related roles.
• Strong SQL skills and hands-on experience with ETL tools.
• Experience working with structured and unstructured data, including data validation and reconciliation.
• Familiarity with databases such as Oracle, SQL Server, PostgreSQL, MySQL, or DB2.
• Exposure to cloud platforms (Azure, AWS, or GCP) and scripting languages such as 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 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 and define field-level mappings.
• Develop and execute ETL processes and load data into target apps.
• Monitor migration performance and resolve failures.
• Perform data profiling, cleansing, and quality assessment.
• Support SIT, UAT, and production rehearsals with validation.
• Coordinate with infrastructure and application teams for cutover and hypercare.

Skills

SQL

ETL tools

Data validation

Oracle

SQL Server

PostgreSQL

MySQL

DB2

Azure

AWS

GCP

Python

PowerShell

Shell scripting

Agile/Waterfall

Data quality

Communication

Problem-solving

Job description

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation, and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail, and supply chain.

We are currently looking to hire a Data Migration Specialist. This is an exciting opportunity to expand your skill set, achieve job satisfaction, and enjoy a healthy work-life balance. More details are below.

ROLES AND RESPONSIBILITIES

Migration Planning

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

Data Analysis & Mapping

• Analyse source and target data models.
• Define field-level data mappings and transformation rules.
• Identify data cleansing requirements.
• Validate business rules with functional stakeholders.

Data Extraction, Transformation & Loading (ETL)

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

Data Quality

• Perform data profiling and quality assessment.
• Execute cleansing and enrichment activities.
• Ensure compliance with data governance standards.

Testing & Validation

• Support SIT, UAT, and production rehearsals.
• Perform reconciliation between source and target systems.
• Validate migrated data with business users.

Cutover & Deployment

• Support mock migrations and dress rehearsals.
• Coordinate with infrastructure and application teams.
• Support hypercare after go-live.

Documentation

• Prepare migration runbooks.

REQUIREMENTS

• Minimum 5 years of experience in data migration, data engineering, or related roles.
• Strong SQL skills and hands‑on experience with ETL tools.
• Experience working with structured and unstructured data, including data validation and reconciliation.
• Familiarity with databases such as Oracle, SQL Server, PostgreSQL, MySQL, or DB2.
• Exposure to cloud platforms (Azure, AWS, or GCP) and scripting languages such as Python, PowerShell, or Shell.
• Experience working in Agile and/or Waterfall delivery environments.
• Strong analytical, problem-solving, and communication skills.

WHAT'S ON OFFER

You will be remunerated with an excellent salary and be entitled to attractive company benefits. Additionally, you will have the opportunity to work in a fun and collaborative environment with excellent career growth prospects.

CONSULTANT DETAILS

Consultant Name: Theerthana

EA License: 12C5759

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.