Senior Consultant

RAC is seeking a Senior 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
  

  • Requirements

    • 2–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