Oracle Data Migration - Consultant

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