Oracle Data Migration - Consultant

Rolling Arrays; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

Rolling Arrays in Singapore is hiring a Data Migration Consultant to execute Oracle HCM data migration workstreams. Successful candidates will build, run, and validate HDL data loads across all HCM modules, ensuring accuracy and completeness.

Applicants should have 2-3 years of Oracle HCM experience, strong Excel skills, and a systematic error resolution approach. Rolling Arrays offers a structured career progression including Consultant to Solution Architect roles.

Qualifications

• 2-3 years of Oracle HCM or HR system data migration experience with hands-on HDL execution.
• Proficiency in Excel for data transformation, field mapping, and code conversion.
• Data reconciliation discipline — treats row count and field value validation as mandatory.

Responsibilities

• Build HDL data files with full awareness of the business object hierarchy.
• Design source-to-target field mapping with transformation logic.
• Execute data loads in development and test environments.

Skills

Oracle HCM or HR system data migration experience

Working knowledge of Oracle HCM worker data model

Proficiency in Excel

SQL or Python proficiency

Systematic error resolution approach

Education

Oracle Fusion Cloud Applications HCM Process Essentials certified

Oracle Global Human Resources Cloud Implementation Professional

Tools

Excel

Python

SQL

Job description

Data migration is where the implementation meets the ground — and where the most confident functional designs are put to the test. If you can build a clean HDL file, run it, read the error log without flinching, and correct the root cause without raising a support request, you belong on our data migration team.

About Rolling Arrays

Rolling Arrays is a private equity-backed, award-winning HR Tech consulting firm — Asia Pacific's premium partner for enterprise HR digital transformation. Headquartered in Singapore and with offices across India, Malaysia, Australia, and Hong Kong, we have delivered more than 200 HR Transformation projects since our founding in 2009, and were recognised as one of Singapore's Top 100 fastest-growing companies in 2025. We specialise in SAP SuccessFactors, Oracle HCM, and Workday across the full delivery spectrum: HR process design and consulting (ALIGN), technology implementation (AUTOMATE), change management and adoption (ADOPT), and managed support services (AMS).

Position Summary

RAC is hiring a Data Migration Consultant to execute Oracle HCM data migration workstreams on client implementations. You will build, run, and validate HDL and HSDL data loads across all HCM modules — ensuring accuracy, completeness, and auditability across all migration cycles from initial mock through production cutover.

What You Will Do

• Build HDL data files with full awareness of the business object hierarchy — loading Person, Work Relationship, Assignment, Employment, and dependent objects in the correct sequence across all in-scope HCM modules
• Design source-to-target field mapping with transformation logic — translating legacy data structures to Oracle HCM attributes, building code conversion tables, and resolving data quality issues at source before they become load failures
• Execute data loads in development and test environments — reading HDL output logs, distinguishing validation errors from import errors, and resolving failures at root cause rather than working around them
• Perform data reconciliation at every mock cycle — source row count versus Oracle load count by object, field‑level spot checks for high‑risk attributes, and business rule validation using Oracle‑side OTBI reports
• Build and maintain data mapping documentation — source‑to‑target mapping tables with transformation rules, load run logs, error resolution notes, and mock run sign‑off reports

Requirements

• 2-3 years of Oracle HCM or HR system data migration experience with hands‑on HDL execution — has submitted HDL files, read the error output, and resolved failures independently
• Working knowledge of the Oracle HCM worker data model: Person, WorkRelationship, Assignment, and their load dependency sequence
• Proficiency in Excel for data transformation, field mapping, and code conversion; SQL or Python is an advantage
• Systematic error resolution approach — does not re‑submit a failed load until the root cause is confirmed and corrected
• Data reconciliation discipline — treats row count and field value validation as mandatory, not optional

Preferred Qualifications

• Oracle Fusion Cloud Applications HCM Process Essentials certified — the foundational HCM credential; the expected starting certification for a Consultant‑level role
• Oracle Global Human Resources Cloud Implementation Professional — working toward this demonstrates that migration work is backed by genuine module understanding, not just file‑loading mechanics
• Python or SQL proficiency for automated transformation scripts and post‑load reconciliation queries
• Experience migrating from a prior HCM platform — PeopleSoft, Oracle EBS HRMS, Workday, or any other system — understanding how legacy data models map to Oracle Cloud's object hierarchy

Business & Consulting Skills

• Data documentation discipline — produces mapping documents, load run logs, and reconciliation reports that a client data team can follow without explanation
• Root‑cause mindset — does not re‑submit a failed load until the cause is confirmed; treats workarounds as technical debt
• Cross‑team collaboration — works alongside functional, security, and cutover workstreams without creating dependencies
• Client data team communication — explains HDL error messages and data quality requirements to non‑technical HR data owners clearly and without condescension
• Learning agility — adapts to new module objects and data structures across implementations without needing to be taught the same pattern twice
• Quality ownership — treats reconciliation as mandatory, not optional; takes personal accountability for data accuracy at each mock cycle

Career Progression

Consultant → Senior Consultant → Lead Consultant → Solution Architect → Practice Lead