Data Migration Lead

Aarorn Technologies Inc; Kuala Lumpur; On-site; MYR 180,000 - 240,000; Full time

Job summary

Aarorn Technologies Inc is seeking an experienced Data Migration Lead to own end-to-end migration activities across enterprise IT projects. You will develop migration strategies, analyze data, define mappings, and ensure data quality and security throughout the cutover.

The role requires 10–12 years of relevant IT experience, strong SQL and database skills, and the ability to collaborate with project managers, developers, QA, and business users to deliver on schedule.

Qualifications

• Bachelor’s degree in Computer Science, IT, Data Management, or Software Engineering.
• 10–12 years of IT experience with data migration and transformation projects.
• Proven leadership of large-scale enterprise data migration projects.
• Strong knowledge of ETL/ELT, data mapping, cleansing, validation, and reconciliation.
• Proficient SQL and database skills.
• Experience with Oracle, SQL Server, MySQL, PostgreSQL.
• Experience with data migration tools such as Informatica, Talend, SSIS, Azure Data Factory, Pentaho.
• Excellent communication and stakeholder management skills.

Responsibilities

• Lead end-to-end data migration lifecycle from planning to post-migration support.
• Develop and maintain the Data Migration Strategy, Migration Plan, and Migration Roadmap.
• Analyse source systems, databases, applications, data structures, and target systems.
• Define and maintain Source-to-Target Data Mapping (STTM) specifications.
• Establish data transformation, cleansing, validation, and enrichment rules.
• Lead data profiling, cleansing, standardization, deduplication, and quality improvement.
• Coordinate extraction, transformation, loading, and validation across multiple systems.
• Ensure data migration processes maintain data integrity, completeness, accuracy, and security.

Skills

SQL

Stakeholder management

Documentation

Collaboration

Education

Bachelor's Degree in Computer Science, IT, Data Management, Software Engineering

Tools

Oracle

SQL Server

MySQL

PostgreSQL

Informatica

Talend

SSIS

Azure Data Factory

Pentaho

Job description

DATA MIGRATION LEAD

Position: Data Migration Lead
Experience: 10 – 12 Years
Location: Nearby SOGO Mall, Kuala Lumpur
Working Mode: ONSITE
Employment Type: Full-Time

Job Summary

We are looking for an experienced Data Migration Lead with 10–12 years of relevant experience to lead and manage end-to-end data migration activities for enterprise IT projects.

The successful candidate will be responsible for developing the migration strategy, analysing source and target data, defining mapping and transformation rules, managing data quality, coordinating migration activities, and ensuring successful data validation, reconciliation, and cutover.

The candidate will work closely with Project Managers, Business Users, Data Architects, Developers, Database Administrators, QA teams, vendors, and other stakeholders to ensure data is migrated accurately, securely, and within the agreed project timeline.

Key Responsibilities

• Lead the end-to-end data migration lifecycle, from planning and assessment through migration, validation, cutover, and post-migration support.
• Develop and maintain the overall Data Migration Strategy, Migration Plan, and Migration Roadmap.
• Analyse source systems, databases, applications, data structures, and target systems.
• Identify data dependencies, data gaps, data quality issues, and migration risks.
• Define and maintain Source-to-Target Data Mapping (STTM) specifications.
• Establish data transformation, cleansing, validation, and enrichment rules.
• Lead data profiling, cleansing, standardization, deduplication, and quality improvement activities.
• Work with technical teams to design and implement ETL/ELT processes and migration scripts.
• Coordinate extraction, transformation, loading, and validation of data across multiple systems.
• Ensure data migration processes maintain data integrity, completeness, accuracy, consistency, and security.
• Develop data validation and reconciliation procedures to verify migrated data.
• Coordinate mock migrations, trial runs, dress rehearsals, and final production migration.
• Manage migration defects, issues, risks, and dependencies throughout the project lifecycle.
• Lead cutover planning and execution, including migration sequencing, downtime planning, rollback procedures, and contingency plans.
• Coordinate closely with application, infrastructure, database, security, testing, and business teams during migration activities.
• Support SIT, UAT, data validation, and post-go-live verification.
• Prepare migration dashboards, status reports, progress updates, risk registers, and management reports.
• Provide regular updates to the Project Manager, Steering Committee, and senior stakeholders.
• Manage and coordinate external vendors or migration partners where applicable.
• Ensure appropriate documentation of migration processes, mapping rules, validation results, reconciliation results, and lessons learned.
• Ensure compliance with organizational data governance, security, privacy, audit, and regulatory requirements.
• Provide technical guidance and leadership to data migration team members.

Required Qualifications & Experience

• Bachelor’s Degree in Computer Science, Information Technology, Data Management, Software Engineering, or a related field.
• 10–12 years of relevant IT experience, with significant experience in data migration and transformation projects.
• Proven experience leading large-scale or complex enterprise data migration projects.
• Strong understanding of data migration methodologies, ETL/ELT processes, data mapping, transformation, cleansing, validation, and reconciliation.
• Strong SQL and database knowledge.
• Experience working with relational databases such as Oracle, SQL Server, MySQL, PostgreSQL, or similar platforms.
• Experience with data migration/ETL tools such as Informatica, Talend, SSIS, Azure Data Factory, Pentaho, or equivalent.
• Strong understanding of data modelling, data structures, master data, reference data, and data quality.
• Experience preparing and managing Source-to-Target Mapping (STTM) documents.
• Experience managing migration testing, mock migration, cutover, rollback, and post-migration validation.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Ability to work effectively with both technical and business teams.
• Strong documentation and reporting skills.
• Ability to work under tight project timelines and manage multiple priorities.