Oracle Fusion Data Migration Lead

ProPhoenix Corporation; Stafford; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Restaurant d'entreprise

Indemnités de stage/alternance

Job summary

ProPhoenix Corporation seeks an experienced Oracle Fusion HCM data migration expert to lead migration activities for HCM and Payroll data, ensuring accurate data structures and dependencies are respected. You will leverage HDL, diagnose HDL errors, and work with HCM/Payroll teams to translate designs into actionable migration tasks.

ProPhoenix requires strong SQL skills for data analysis and reconciliation, expertise in BI Publisher/OTBI for post-load validation, and advanced Excel proficiency

Qualifications

• Strong hands-on experience delivering Oracle Fusion HCM and/or Payroll data migration activities.
• Strong understanding of Oracle Fusion HCM data structures, effective-dated data and dependencies between key migration objects.
• Practical experience preparing and loading data using Oracle HCM Data Loader (HDL); HSDL experience is beneficial.
• Ability to interpret HDL load errors, diagnose root causes and independently resolve or coordinate fixes.
• Strong SQL skills for data analysis, transformation, validation and reconciliation; PL/SQL experience is advantageous.
• Working knowledge of Oracle Fusion reporting capabilities, particularly BI Publisher and OTBI, for post-load validation and reconciliation.
• Advanced Microsoft Excel capability, including complex formulas, lookups, pivots, data cleansing, comparison and large-volume analysis; Power Query or similar analytical tooling is advantageous.
• Strong understanding of data mapping, transformation, cleansing, validation, reconciliation and migration quality controls.
• Experience working with HCM and Payroll functional teams and translating functional design/configuration into actionable migration requirements.
• Ability to analyse large and complex datasets, identify anomalies and explain data issues clearly to technical and non-technical stakeholders.

Responsibilities

Job description

Strong hands-on experience delivering Oracle Fusion HCM and/or Payroll data migration activities.

Strong understanding of Oracle Fusion HCM data structures, effective-dated data and dependencies between key migration objects.

Practical experience preparing and loading data using Oracle HCM Data Loader (HDL); HSDL experience is beneficial.

Ability to interpret HDL load errors, diagnose root causes and independently resolve or coordinate fixes.

Strong SQL skills for data analysis, transformation, validation and reconciliation; PL/SQL experience is advantageous.

Working knowledge of Oracle Fusion reporting capabilities, particularly BI Publisher and OTBI, for post-load validation and reconciliation.

Advanced Microsoft Excel capability, including complex formulas, lookups, pivots, data cleansing, comparison and large-volume analysis; Power Query or similar analytical tooling is advantageous.

Strong understanding of data mapping, transformation, cleansing, validation, reconciliation and migration quality controls.

Experience working with HCM and Payroll functional teams and translating functional design/configuration into actionable migration requirements.

• Ability to analyse large and complex datasets, identify anomalies and explain data issues clearly to technical and non-technical stakeholders.