Software Engineer (Data Migration)

ASTEK SINGAPORE INNOVATION TECHNOLOGY PTE. LTD.; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

A technology innovation company in Singapore seeks a Software Engineer to lead data migration efforts. The ideal candidate will have experience in ETL processes, strong programming skills in languages such as Java and Python, and expertise in database management. You will be responsible for ensuring data integrity and optimizing migration processes for large datasets.

Qualifications

• 3–8 years of experience working on large-scale systems and applications.
• Strong programming background including object-oriented principles.
• Hands-on experience with software development tools.

Responsibilities

• Review existing data sources and structures to identify challenges.
• Design and implement scripts to extract, transform, and load data.
• Conduct trial runs and verify data accuracy post-migration.

Skills

ETL processes

Database management

Data validation

Troubleshooting migration issues

Java

Python

JavaScript

.NET

C#

SQL

Application integration

Education

Bachelor’s Degree or Diploma in Computer Science

Tools

Oracle

MySQL

SQL Server

PostgreSQL

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.