Oracle Data Migration

Role & responsibilities

Role purpose

Lead the extraction, transformation, loading, and reconciliation of HCM, Core HR, and Payroll data for the divested business unit, ensuring that active workers, assignments, payroll relationships, element entries, balances, payment methods, work structures, and payroll-related conversion data are migrated accurately and securely into the target Fusion instance.

Key responsibilities

• Own HCM, Core HR, and Payroll data conversion execution for in-scope workforce populations.
• Profile source HCM data to identify active employees, contingent workers, pending workers, assignments, work relationships, managers, departments, jobs, grades, positions, locations, legal employers, payroll relationships, and payroll eligibility.
• Prepare source-to-target mapping for person numbers, worker types, legal entities, payrolls, departments, jobs, positions, grades, locations, supervisors, costing, banks, payment methods, and payroll balances.
• Develop or coordinate extraction logic using HCM Extracts, BI Publisher, REST APIs, HDL exports where appropriate, and staged transformation logic.
• Prepare HDL/HSDL/load-ready files for person, work relationship, assignment, salary, element entries, payment methods, payroll relationships, costing, balances, and related HCM objects as applicable.
• Coordinate with functional leads to apply data privacy, masking, security, and regulatory controls during migration.
• Support payroll conversion design including opening balances, year-to-date balances, arrears, deductions, element entries, retro items, tax details, and bank/payment data.
• Support OTL and Projects dependencies by ensuring time reporters, project resources, assignments, schedules, and eligibility are available for downstream processes.
• Execute mock conversions, analyze HDL/import errors, correct transformation defects, and manage retest cycles.
• Build reconciliation re

Preferred candidate profile