Software Engineer (Data Migration)

Astek Singapore Innovation Technology; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A technology consulting firm in Singapore is seeking a Software Engineer to lead the transition of data from legacy systems to modern platforms. The ideal candidate should have 3-8 years’ experience in large-scale systems, a strong programming background in languages like Java and Python, and expertise in ETL processes and database management. Join us to ensure accuracy and integrity in data migration while minimizing disruption to business operations.

Qualifications

• 3–8 years of experience working on large‑scale systems and applications.
• Proficient in relational databases such as Oracle, MySQL, SQL Server, and PostgreSQL.
• Hands‑on experience with ETL processes, data migration, validation, and quality assurance.

Responsibilities

• Review existing data sources, structures, and dependencies to identify potential challenges.
• Design and implement scripts to extract, transform, and load data into target systems.
• Conduct trial runs and verify data accuracy and completeness post‑migration.

Skills

ETL processes

SQL

Java

Python

JavaScript

.NET

C#

Education

Bachelor’s Degree or Diploma in Computer Science or related field

Tools

Git

Jenkins

JIRA

Job description

Summary

We are looking for a Software Engineer to lead and execute the transition of data from legacy systems to modern platforms, ensuring accuracy, integrity, and minimal disruption to business operations. The ideal candidate will have hands‑on expertise in ETL processes, database management, data validation, and troubleshooting complex migration issues.

Key Responsibilities

Planning & Analysis

• Review existing data sources, structures, and dependencies to identify potential challenges.
• Gather business requirements and define the scope of migration.
• Work closely with business and IT teams to establish migration plans, including cutover and rollback strategies.

Data Extraction, Transformation & Loading (ETL)

• Design and implement scripts to extract, transform, and load data into target systems.
• Cleanse, map, and standardize data to meet system requirements.
• Execute both incremental and full migrations while minimizing downtime.
• Safeguard data consistency, integrity, and accuracy during transfers.

Testing & Validation

• Conduct trial runs and verify data accuracy and completeness post‑migration.
• Diagnose and resolve migration errors.
• Implement reconciliation processes, error‑handling protocols, and rollback procedures.

Performance & Optimization

• Enhance migration processes for handling large datasets efficiently.
• Monitor system performance and resolve bottlenecks during data transfers.
• Ensure compliance with organizational security standards and data protection policies

Requirements

• Bachelor’s Degree or Diploma in Computer Science, Information Technology, or a related field.
• 3–8 years of experience working on large‑scale systems and applications.
• Strong programming background with Java, Python, JavaScript, .NET, or C#, including solid understanding of object‑oriented principles, concurrency, and design patterns.
• Proficient in SQL and relational databases such as Oracle, MySQL, SQL Server, and PostgreSQL.
• Hands‑on experience with ETL processes, data migration, validation, reconciliation, and quality assurance.
• Proficiency in developing and consuming web services and APIs (JavaScript, .NET Core, XML, HTML).
• Skilled in application integration, monitoring, and automated testing.
• Experience using software development tools (Git, Jenkins, JIRA).
• Familiarity with RESTful APIs and connecting frontend applications to backend services.
• Strong knowledge of SDLC methodologies and full project life cycle.
• Ability to analyze requirements, prepare technical specifications, and develop test scenarios.