Oracle Data Migration - Consultant at Rolling Arrays

Singapore, , Singapore -

Full Time

Start Date

Immediate

Expiry Date

16 Aug, 26

Salary

0.0

Posted On

18 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle HCM, HDL, HSDL, Data Migration, Excel, SQL, Python, Data Mapping, Data Reconciliation, OTBI Reports, Source-to-Target Mapping, Root Cause Analysis, Oracle Fusion Cloud, HCM Process Essentials, Global Human Resources Cloud Implementation, Data Transformation

Industry

IT Services and IT Consulting

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 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 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

Responsibilities

Execute Oracle HCM data migration workstreams by building, running, and validating HDL and HSDL data loads. Ensure data accuracy and auditability through rigorous reconciliation and documentation across all migration cycles.