Data Migration Specialist

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.
• Identify duplicate, incomplete, or inconsistent data.
• 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.
• Resolve migration defects.

Cutover & Deployment

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

Documentation

• Prepare migration runbooks.
• Maintain mapping documents.
• Document migration procedures.
• Produce reconciliation reports.
• Maintain audit evidence.

REQUIREMENTS

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

To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [Confidential Information]. Your interest will be treated with strict confidentiality.

CONSULTANT DETAILS

Consultant Name: Theerthana

Avensys Consulting Pte Ltd

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.