The Oracle Fusion HCM & Payroll Data Migration Lead is responsible for leading and executing the end-to-end data migration lifecycle for Oracle Fusion implementations. The role works closely with customer data teams, business stakeholders and HCM/Payroll functional consultants to define what data is required, how legacy data must be extracted, how it maps to Oracle Fusion, and how it is transformed, loaded, reconciled and validated.

This is a hands-on delivery role, not a coordination-only position. The successful candidate is expected to personally create and review migration files, perform Oracle Fusion data loads, analyse load failures, correct and reload data, develop reconciliation outputs, investigate data quality issues and provide clear explanations and recommendations to both customer and project teams.

1. Data Migration Planning and Cycle Leadership

• Own and drive the data migration workstream across mock migrations, testing cycles, cutover rehearsals and production migration.
• Create and maintain detailed data migration plans covering extraction, mapping, transformation, file preparation, load, validation, reconciliation, defect resolution and rework.
• Define migration milestones, dependencies, entry/exit criteria, ownership and delivery checkpoints for each data object.
• Track migration progress, risks, data defects, decisions and actions, escalating issues that could impact the wider implementation plan.
• Coordinate with programme, customer, functional, technical, testing and business teams while retaining direct ownership of migration delivery.

2. Customer Extraction Requirements and Legacy Data Analysis

• Work closely with customer data/extraction teams to define the exact data required from the legacy system for each Oracle Fusion object.
• Translate Oracle Fusion functional and technical requirements into clear legacy extraction specifications, including required fields, selection criteria, effective dating, historical data rules, filters, defaults and valid values.
• Review customer-generated extracts for completeness, structure, data quality and fitness for migration before transformation and load activities begin.
• Analyse source data to identify duplicates, missing mandatory values, invalid dates, broken relationships, inconsistent codes, referential integrity issues and other migration risks.
• Provide actionable feedback to the customer on extraction issues and support iterative correction of source extracts.

3. Legacy-to-Fusion Mapping and Migration Design

• Create, maintain and mature mapping documents that establish field-level and value-level mappings between legacy systems and Oracle Fusion.
• Document source fields, Fusion target attributes, transformation rules, defaulting logic, lookup/value mappings, effective-date handling, derivation logic and business rules.
• Work with HCM and Payroll functional consultants to confirm target configuration, mandatory attributes, business rules, reference data and downstream dependencies.
• Ensure changes agreed during migration cycles, defect resolution or functional design discussions are reflected in migration mapping and transformation documentation.
• Identify gaps where legacy data cannot directly support Fusion requirements and define pragmatic transformation, cleansing or defaulting approaches with the relevant stakeholders.

4. Hands-on Data Preparation, Transformation and Oracle Fusion Loading

• Prepare Oracle Fusion migration templates and load-ready files from customer-provided legacy extracts.
• Perform data manipulation, transformation, enrichment, formatting and validation using SQL, Excel and other suitable analytical or data-processing tools.
• Create and execute HCM Data Loader (HDL) files and, where appropriate, HCM Spreadsheet Data Loader (HSDL) or other Oracle-supported loading mechanisms.
• Manage load sequencing and dependencies between related HCM and Payroll objects to ensure data is loaded in the correct order.
• Execute loads in Oracle Fusion, review load status and logs, identify failed records, investigate root causes, correct data or file structures and perform re-loads until agreed acceptance criteria are achieved.
• Differentiate between source-data, mapping, transformation, configuration, environment and load-mechanism issues and route or resolve them appropriately.
• Provide clear technical and business justification for rejected or failed records and recommend the required corrective action.

5. Reconciliation, Validation and Data Quality Assurance

• Develop, modify and execute reconciliation reports comparing source data, prepared migration files and successfully loaded Oracle Fusion data.
• Use SQL and Oracle Fusion reporting tools such as BI Publisher and OTBI to validate migrated data and identify variances.
• Create object-level validation reports covering record counts, key totals, critical attributes, balances, relationships and other business-significant measures.
• Perform detailed analytical review of migration results rather than relying only on load success percentages.
• Investigate reconciliation differences, identify root causes and drive corrective action through source correction, transformation changes, configuration updates or reload.
• Support business validation by supplying clear reports, exception lists, evidence and explanations that enable customer sign-off.

6. Functional, Business and Technical Collaboration

• Partner with Oracle Fusion HCM and Payroll functional consultants to understand configuration, statutory/legislative requirements, functional dependencies and object-specific migration requirements.
• Translate functional requirements into data requirements that customer extraction teams can understand and implement.
• Work directly with business users to clarify legacy data meaning, validate transformation assumptions and resolve data exceptions.
• Collaborate with reporting, integration, security and technical teams where migrated data affects downstream processes or reconciliation.
• Act as the primary data migration point of contact for assigned HCM/Payroll areas and provide confident, evidence-based updates to stakeholders.

7. Migration Governance and Continuous Improvement

• Maintain clear auditability of migration rules, mapping decisions, file versions, load results, reconciliation evidence and outstanding exceptions.
• Establish repeatable migration processes, templates, checklists and quality controls across migration cycles.
• Perform root-cause analysis on recurring migration issues and introduce preventative controls for subsequent cycles.
• Support cutover planning by defining final extraction windows, load sequence, estimated processing activities, reconciliation steps and business sign-off requirements.
• Contribute to migration closure reporting, lessons learned and transition of migration knowledge into support or BAU teams where required.