Oracle Data Migration - Consultant

Rolling Arrays; Singapore; In loco; SGD 60.000 - 90.000; Tempo pieno

Descrizione del lavoro

Rolling Arrays in Singapore is seeking a Data Migration Consultant to drive HDL-based Oracle HCM migrations across client implementations. You will build, run, and validate HDL/HSDL data loads, ensuring accuracy and auditability throughout mock and production cutovers.

The role requires 2–3 years of Oracle HCM data migration experience, strong mapping and transformation skills, and a disciplined approach to error resolution and data reconciliation.

Competenze

• 2-3 years of Oracle HCM or HR data migration experience with HDL execution
• Hands-on HDL files submission, error output reading, and independent fixes
• Familiar with the Oracle HCM worker data model: Person, WorkRelationship, Assignment, and their load sequence
• Proficiency in Excel for data transformation, field mapping; SQL or Python is a plus
• Systematic error resolution approach and data reconciliation discipline

Mansioni

• Build HDL data files with awareness of the business object hierarchy across HCM modules
• Design source-to-target field mapping with transformation logic
• Execute data loads in development and test environments and resolve root causes
• Perform data reconciliation at every mock cycle including OTBI-based checks
• Build and maintain data mapping documentation, load run logs, and reconciliation reports

Conoscenze

Oracle HCM data migration

HDL/HDL execution

Data transformation & mapping

Error resolution

Data reconciliation

Cross-team collaboration

Learning agility

Formazione

Oracle Fusion Cloud HCM certification

Oracle Global Human Resources Cloud Implementation Professional

Strumenti

Excel

SQL

Python

Descrizione del lavoro

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

WHY ROLLING ARRAYS

Data migration is a structured, valued delivery workstream at RAC — not a task handed to a junior consultant. You will develop HDL expertise across multiple Oracle HCM modules in APAC legislative contexts, with a clear pathway to Senior and Lead Data Migration Consultant as the practice scales.

OUR CULTURE CODE

Six values define how we operate every day at Rolling Arrays:

• Thinking Smart — spot patterns, chase smarter solutions, and illuminate the path to greater productivity
• Never Stop Learning — refine and elevate skills constantly; explore the world with a curiosity lens
• Being Nice to Everyone — treat everyone with genuine warmth and respect, regardless of seniority
• Be Super Patient with Customers — exercise patience and proactivity in every client interaction
• Help Your Teammates — share the load, lighten the stress, nurture a truly collaborative team
• Acknowledge Your Mistakes — embrace mistakes as steppingstones; grow from each one

Requirements

WHAT WE'RE LOOKING FOR

• 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