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