R

Data Migration Lead (Oracle / Enterprise Systems)

RedM Professional Services
7 days ago
Full-time
On-site
Johannesburg, South Africa

Introduction

 

The Data Migration Lead is responsible for planning, designing, and executing end-to-end data migration activities across enterprise systems, with a strong focus on Oracle environments. The role ensures accurate, secure, and complete migration of data from legacy systems to target platforms, while maintaining data integrity, governance, and compliance standards.

Duties & Responsibilities

 

Data Migration Strategy & Planning

  • Define and implement the end-to-end data migration strategy and framework.
  • Develop data migration plans, timelines, and governance structures.
  • Identify data sources, mapping requirements, and transformation rules.
  • Ensure alignment with Oracle ERP implementation and upgrade projects.

Data Analysis & Mapping

  • Analyse source and target data structures across systems.
  • Develop detailed data mapping specifications and transformation logic.
  • Work closely with business and functional teams to validate data requirements.

Migration Execution & Delivery

  • Lead data extraction, cleansing, transformation, and loading (ETL) processes.
  • Oversee migration cycles including mock loads, rehearsals, and final cutover.
  • Ensure minimal downtime and disruption during migration activities.
  • Coordinate with technical teams on data pipelines and scripts.

Data Quality & Validation

  • Define and execute data validation and reconciliation processes.
  • Ensure accuracy, completeness, and consistency of migrated data.
  • Resolve data discrepancies in collaboration with business and technical teams.

Oracle ERP Data Migration

  • Support data migration for Oracle ERP modules (e.g., GL, AP, AR, Procurement, Projects).
  • Ensure data readiness for Oracle ERP implementations, upgrades, and conversions.
  • Validate Oracle data structures, conversion rules, and load processes.

Stakeholder Management

  • Collaborate with business users, functional leads, developers, and DBAs.
  • Provide regular updates on migration progress, risks, and issues.
  • Facilitate data migration workshops and validation sessions.

Governance, Risk & Compliance

  • Ensure data migration processes comply with governance and security standards.
  • Maintain audit trails and documentation for all migration activities.
  • Manage risks related to data loss, duplication, or corruption.

Desired Experience & Qualification

 

  • Qualification:
    B Degree / NQF Level 6 in Information Systems, Data Science, Computer Science, or related field
  • Experience:
    • Minimum 3+ years in data migration roles
    • Experience in end-to-end data migration lifecycle (ETL, validation, cutover)
    • Strong exposure to Oracle ERP environments

    • Required

    • Data migration and ETL processes (extract, transform, load)
    • Oracle ERP (EBS or Oracle Cloud) data structures
    • SQL for data analysis, validation, and reconciliation
    • Data mapping and transformation techniques
    • Data profiling and cleansing