Oracle Data Migration - Senior Consultant

The Senior Data Migration Consultant is the person who designs the loading strategy, runs the dress rehearsal, finds the data quality issue at 11pm five days before cutover, makes the go/no-go recommendation with a clear rationale, and then fixes it. If that is your experience — not adjacent to it, but personally yours — we want to meet you.

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 seeking a Senior Data Migration Consultant to lead Oracle HCM data migration workstreams end-to-end on mid-to-large implementations. You will own the migration strategy — from legacy data analysis through object sequencing design, mock run cycles, dress rehearsal, and production cutover — while managing the client data team and mentoring junior consultants.

WHAT YOU WILL DO

• Own the data migration strategy — determining the full object load sequence across all in-scope HCM modules, mapping object dependencies, and designing the mock run schedule that surfaces data quality issues before they become cutover risks
• Lead legacy data analysis — profiling source system structures, identifying field mapping gaps, data quality issues, and legislative compliance gaps that must be resolved before any load can succeed
• Design complex transformation logic — building transformations for legislative-specific objects including Calculation Cards, historical salary records with back-dated effective dates, and benefits enrolments that must respect Oracle plan eligibility rules at load time
• Govern the mock run cycle — setting data quality acceptance criteria per mock round, tracking error rate reduction across cycles, escalating client data team delivery failures, and making the data quality sign-off recommendation to project leadership
• Plan and execute production cutover — designing the T-minus timeline, the delta data strategy for capturing changes between the last mock and go-live, the verification checklist, and the documented go/no-go criteria
• Mentor junior Data Migration Consultants — reviewing HDL files and transformation logic, teaching error diagnosis patterns, and building their capability to work independently on assigned object tracks

WHY ROLLING ARRAYS

RAC delivers complex Oracle HCM migrations across multi-country APAC programmes with real legislative complexity. As Senior Data Migration Consultant, you own the workstream that determines go-live success — with a clear pathway to Lead Consultant and Data Migration Practice Lead roles.

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

• 4–5 years of Oracle HCM experience with proven end-to-end data migration workstream ownership on at least two live implementations — not just HDL file execution under supervision
• Expert HDL knowledge: has loaded complex objects beyond Core HR workers (absence balances, benefits, compensation, legislative calculation cards) and resolved their specific failure modes
• Has designed and executed at least two production cutover migrations including dress rehearsal, delta data strategy, and go/no-go decision
• Python or SQL proficiency for transformation automation and post-load reconciliation at scale
• Demonstrated client data team management — has set quality gates, held data owners accountable, and escalated delivery failures through the project governance structure

PREFERRED QUALIFICATIONS

• Oracle Global Human Resources Cloud Implementation Professional — the primary module certification for Senior Data Migration; expected at this level as evidence that migration work is grounded in genuine module understanding
• Oracle Payroll Cloud Implementation Professional — payroll data migration is the highest-risk object track; a Payroll certification signals the depth required to own cutover decisions on payroll-in-scope programmes
• Oracle Fusion Cloud Applications HCM Process Essentials certified — the foundational credential confirming cross-module process understanding
• Experience migrating legislative calculation card history: CPF (Singapore), EPF/SOCSO (Malaysia), or superannuation (Australia)
• Oracle Integration Cloud (OIC) hands-on experience for automating HDL file submission, status monitoring, and error notification during high-volume migration cycles

BUSINESS & CONSULTING SKILLS

• Cutover communication — presents go/no-go recommendations to project leadership with a clear rationale that holds up under pressure
• Client data team governance — sets quality gates, holds external data owners accountable, and escalates through the project structure without damaging the relationship
• Migration risk articulation — translates data quality issues into business impact language that project leadership can act on, not just technical error counts
• Delivery accountability — owns the migration workstream outcome, not just the individual load runs
• Mentoring delivery — builds junior consultant capability through structured review, not just observation
• Structured escalation — knows the difference between a data quality issue that can be resolved and one that requires a go-live date conversation.

CAREER PROGRESSION

Senior Consultant → Lead Consultant → Solution Architect → Practice Lead