Data Migration Specialist – System Transition Planning

Houston Skilled Consultancy; Singapore; Hybrid; SGD 60,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Professional development

Flexible work options

Job summary

Houston Skilled Consultancy in Singapore seeks a Data Migration Specialist to drive planning, mapping, validation, and execution across legacy systems, modern apps, databases, and cloud platforms.

You will collaborate with IT infrastructure, business stakeholders, and project managers to ensure migration activities align with business objectives, technical requirements, and timelines, while minimizing downtime and ensuring data integrity.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, Software Engineering, Data Management, or related discipline.
• Experience with data migration planning, source-to-target mapping, data transformation, validation, and reconciliation.
• Knowledge of cloud platforms (Azure/AWS/GCP) and database concepts.

Responsibilities

• Develop comprehensive data migration plans based on business requirements and project objectives.
• Assess systems, databases, and data repositories to determine scope and complexity.
• Define migration approaches (phased/full/incremental) and schedule milestones.
• Coordinate with project managers and technical teams to align migration activities with transition plans.
• Monitor progress, troubleshoot issues, and ensure data integrity during migration.

Skills

Data migration lifecycle

SQL queries

ETL/ELT

Data governance

Python/ scripting

Cloud platforms

Project coordination

Education

Bachelor's degree in CS/IT/Data management

Tools

SQL Server

MySQL

PostgreSQL

Oracle

Azure

AWS

GCP

ETL tools

Job description

Job Summary

Houston Skilled Consultancy is seeking a detail-oriented and technically proficient Data Migration Specialist – System Transition Planning to support data migration initiatives, system modernization projects, and technology transition programs. The successful candidate will play a vital role in planning, coordinating, and executing secure and efficient data migration activities across legacy systems, modern applications, databases, and cloud-based platforms.

This position involves analyzing existing data environments, assessing migration requirements, identifying potential risks, developing structured migration strategies, and ensuring the accurate transfer of information between systems. The specialist will collaborate with IT infrastructure teams, database administrators, application owners, business stakeholders, and project managers to ensure that migration activities align with business objectives, technical requirements, and project timelines.

The ideal candidate will have a strong understanding of data management principles, system integration, data validation, migration methodologies, and transition planning. They should be comfortable working with complex datasets, documenting technical processes, troubleshooting migration issues, and supporting testing activities before and after system cutover.

At Houston Skilled Consultancy, the Data Migration Specialist will contribute to improving operational efficiency, maintaining data integrity, minimizing business disruption, and enabling successful technology transitions. Candidates who enjoy solving technical problems, organizing complex projects, and working collaboratively across teams are encouraged to apply.

Key Responsibilities

Data Migration Planning and Strategy

• Develop comprehensive data migration plans based on business requirements, technical dependencies, system architecture, and project objectives.
• Assess existing systems, databases, applications, and data repositories to determine migration scope and complexity.
• Define migration approaches, including phased migration, full migration, incremental migration, and parallel-running strategies, as appropriate.
• Establish migration schedules, milestones, resource requirements, dependencies, and completion criteria.
• Coordinate with project managers and technical teams to align migration activities with broader system transition plans.
• Identify opportunities to simplify migration processes, improve efficiency, and reduce implementation risks.

Data Assessment and Preparation

• Analyze source data to evaluate its structure, quality, completeness, consistency, and compatibility with target systems.
• Conduct data profiling, mapping, cleansing, transformation, and standardization activities.
• Identify duplicate records, missing values, formatting inconsistencies, and other data quality issues.
• Develop source-to-target data mapping documents and transformation specifications.
• Work with business stakeholders to clarify data definitions, ownership, retention requirements, and validation rules.
• Ensure that migration datasets are properly prepared before execution.

System Transition and Migration Execution

• Support the transfer of data between legacy platforms, enterprise applications, relational databases, cloud environments, and other target systems.
• Develop or maintain migration scripts, workflows, and automated processes using appropriate technical tools.
• Coordinate migration activities across development, testing, staging, and production environments.
• Perform trial migrations and pilot runs to identify technical issues before the final transition.
• Monitor migration progress, investigate errors, and resolve data transfer or transformation problems.
• Coordinate with infrastructure, application, and database teams to ensure system readiness before migration activities begin.

Data Validation and Quality Assurance

• Establish data validation procedures to confirm that migrated information meets defined quality and completeness standards.
• Reconcile source and target datasets using record counts, checksums, control totals, and field-level comparisons where appropriate.
• Support functional testing, integration testing, user acceptance testing, and post-migration verification.
• Investigate discrepancies and implement corrective actions to maintain data accuracy.
• Prepare migration test reports and document validation outcomes.
• Obtain appropriate stakeholder confirmation that migration results meet business and technical requirements.

Risk Management and Cutover Planning

• Identify migration risks related to data loss, downtime, application dependencies, security, performance, and compatibility.
• Develop mitigation strategies, contingency procedures, and rollback plans.
• Prepare detailed cutover runbooks outlining task sequences, responsibilities, dependencies, checkpoints, and escalation procedures.
• Coordinate migration readiness reviews and confirm that required approvals are obtained before production cutover.
• Support go-live activities and help resolve issues that arise during system transition.
• Participate in post-migration reviews to identify lessons learned and recommend improvements.

Security, Compliance, and Documentation

• Follow organizational policies for data confidentiality, access control, encryption, retention, and secure data handling.
• Ensure migration activities comply with applicable contractual, regulatory, and internal governance requirements.
• Maintain technical documentation covering migration architecture, mapping rules, scripts, test evidence, risks, and approvals.
• Apply appropriate controls when working with personal, confidential, or business-critical information.
• Support audit requests by maintaining traceable records of migration activities and validation results.
• Communicate project status, risks, dependencies, and outstanding issues to relevant stakeholders.

Stakeholder Collaboration and Reporting

• Collaborate with business analysts, system administrators, database administrators, developers, cybersecurity specialists, and project managers.
• Translate business requirements into practical migration specifications and execution plans.
• Provide regular progress updates and elevate issues that may affect project delivery.
• Participate in project meetings, technical reviews, migration workshops, and readiness assessments.
• Prepare status reports detailing migration progress, data quality, risks, defects, and outstanding actions.
• Contribute to knowledge-sharing activities and continuous improvement initiatives.

Required Skills and Qualifications

Educational Qualifications

• Bachelors degree in Computer Science, Information Technology, Information Systems, Software Engineering, Data Management, or a related discipline.
• Relevant technical certifications or professional training in database administration, cloud platforms, data engineering, or data migration will be an advantage.
• Candidates with equivalent practical experience and demonstrated technical capabilities may also be considered.

Technical Skills

• Strong understanding of data migration lifecycle activities, including discovery, planning, extraction, transformation, loading, validation, and reconciliation.
• Knowledge of relational database concepts, SQL queries, database structures, and data integrity principles.
• Familiarity with ETL and ELT processes, data transformation techniques, and integration workflows.
• Understanding of data mapping, data cleansing, data profiling, and quality assurance methodologies.
• Experience with scripting languages such as Python, PowerShell, or Bash is desirable.
• Familiarity with databases such as Microsoft SQL Server, MySQL, PostgreSQL, or Oracle.
• Awareness of cloud-based data environments, including Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP).
• Understanding of APIs, file transfers, data formats, and system integration methods.
• Familiarity with migration documentation, project tracking systems, version control, and testing procedures.
• Knowledge of backup, recovery, access management, and secure data handling practices.

Professional Skills

• Strong analytical and problem-solving abilities.
• Excellent attention to detail and commitment to data accuracy.
• Effective written and verbal communication skills.
• Ability to organize tasks, manage priorities, and meet project deadlines.
• Strong documentation and reporting capabilities.
• Ability to collaborate with technical and non-technical stakeholders.
• A proactive approach to identifying risks and resolving issues.
• Willingness to learn new technologies, migration tools, and project methodologies.

Experience

Houston Skilled Consultancy welcomes applications from qualified professionals at different stages of their careers, depending on project requirements.

Preferred experience includes:

• Approximately 2–5 years of experience in data migration, database operations, data engineering, application implementation, system integration, or related IT functions.
• Practical exposure to migration planning, source-to-target mapping, data transformation, validation, and reconciliation.
• Experience supporting system upgrades, application replacements, cloud adoption, database modernization, or enterprise technology transitions.
• Familiarity with migration testing, defect tracking, cutover preparation, and post-migration support.
• Experience preparing technical documentation, migration reports, and operational procedures.

Candidates with less experience may be considered for junior opportunities if they demonstrate strong technical fundamentals, relevant training, problem-solving skills, and a willingness to learn.

Experience with large-scale enterprise migrations, regulated environments, business-critical systems, or multi-platform transitions will be an advantage.

Working Hours

Standard schedule: Typically 40 hours per week, subject to the employment agreement and applicable local requirements.

Working days: Generally Monday to Friday, depending on project arrangements.

Flexible scheduling: May be available depending on team structure, client requirements, and business needs.

Migration windows: Occasional evening, weekend, or out-of-hours work may be necessary during critical migration, testing, or production cutover activities.

Remote or hybrid work: May be available where supported by the project and company policies.

Project deadlines: Some periods may require additional coordination and schedule flexibility to complete time-sensitive transition activities.

Specific working hours, location, and overtime arrangements will be communicated during the recruitment process.

Knowledge, Skills, and Abilities

Knowledge

• Understanding of the data migration lifecycle and system transition methodologies.
• Knowledge of database structures, data relationships, data dependencies, and integrity constraints.
• Awareness of enterprise application architecture and system interoperability.
• Understanding of data governance, quality management, privacy, and information security principles.
• Familiarity with project planning, change management, testing, and release coordination.
• Awareness of business continuity, disaster recovery, and rollback planning.

Skills

• Ability to prepare detailed migration schedules, technical specifications, and cutover plans.
• Proficiency in analyzing datasets and identifying data inconsistencies.
• Ability to write and interpret SQL queries for data analysis and reconciliation.
• Capability to document source-to-target mapping and transformation logic.
• Strong troubleshooting skills for investigating migration failures and unexpected results.
• Ability to prepare clear technical reports and communicate progress to stakeholders.
• Effective time management and coordination across multiple project activities.

Abilities

• Ability to manage sensitive information responsibly and follow established security procedures.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Ability to understand complex technical requirements and convert them into actionable tasks.
• Ability to remain organized and focused during high-pressure migration and cutover periods.
• Ability to identify potential issues early and recommend practical solutions.
• Ability to adapt to changing project priorities, technical environments, and business requirements.
• Commitment to continuous learning, professional development, and process improvement.

Benefits

Houston Skilled Consultancy aims to offer a professional environment that supports employee development, collaboration, and long-term career growth. Depending on the employment agreement, role location, and applicable company policies, benefits may include:

• Competitive Compensation: Salary aligned with the candidates qualifications, relevant experience, technical expertise, and role responsibilities.
• Professional Development: Opportunities to strengthen skills in data migration, database management, cloud technologies, and enterprise system modernization.
• Technical Learning: Exposure to contemporary migration approaches, integration technologies, and data management practices.
• Career Development: Opportunities to progress into senior migration, data engineering, database administration, solution architecture, or technical project leadership roles.
• Collaborative Work Environment: Opportunities to work with professionals across infrastructure, applications, security, and business operations.
• Flexible Work Arrangements: Remote or hybrid options where permitted by project requirements and company policy.
• Project-Based Learning: Practical exposure to system transitions, data quality improvement, testing, and production readiness activities.
• Performance Recognition: Potential recognition for quality delivery, process improvements, teamwork, and successful project outcomes.
• Employee Support: Applicable leave, statutory benefits, and other employment benefits in accordance with company policy and local law.
• All benefits are subject to eligibility, employment terms, location, and the companys applicable policies.

Why Join Houston Skilled Consultancy?

Joining Houston Skilled Consultancy offers an opportunity to contribute to technology initiatives that help organizations modernize systems, improve data reliability, and transition to more effective digital environments.

As a Data Migration Specialist, you will have the opportunity to apply analytical thinking, technical knowledge, and structured planning to solve real-world data challenges. Your work will help ensure that essential business information is transferred accurately, securely, and efficiently during important technology changes.

Reasons to consider this opportunity include:

• Meaningful Technical Work: Contribute to migration and modernization projects that support business continuity and operational improvement.
• Career Growth Opportunities: Build a foundation for advancement into specialized data, database, cloud, and technology consulting roles.
• Cross-Functional Collaboration: Work with technical experts and business stakeholders to deliver coordinated transition projects.
• Continuous Learning: Develop practical knowledge of emerging tools, migration methodologies, and enterprise technology environments.
• Problem-Solving Opportunities: Address data quality issues, system compatibility challenges, and complex migration dependencies.
• Professional Contribution: Help reduce migration risks, protect data integrity, and support successful system implementation.
• A Quality-Focused Culture: Contribute to work that emphasizes accuracy, accountability, documentation, and continuous improvement.

If you are passionate about data management, system modernization, and delivering dependable technology solutions, this role offers an opportunity to develop your expertise while contributing to important IT initiatives.