Oracle HCM Data Conversion Consultant

Job description:

We are seeking an experienced Oracle HCM Data Conversion Cycle Lead to oversee the data migration workstream in Oracle HCM Cloud implementations. This role will be responsible for leading end-to-end data conversion efforts, ensuring accurate extraction, transformation, and loading (ETL) of employee, organizational, payroll, and historical HR data into Oracle HCM Cloud from legacy systems. The ideal candidate will have deep experience in data conversion strategy, mapping, validation, reconciliation, and collaboration across cross-functional teams.

Required skill and experience:

• Must have 5+ year experience, hands-on experience in Oracle HCM Cloud implementations, with at least 3 years in a data conversion or data migration lead role.
• Lead the data conversion lifecycle for Oracle HCM Cloud implementations across all key phases: planning, extraction, transformation, validation, and load (ETL).
• Define and execute data conversion strategy including data governance, cutover planning, and migration sequencing.
• Collaborate with functional leads, data owners, and technical teams to gather requirements and establish data mapping rules between legacy systems and Oracle HCM.
• Manage development of data conversion programs, scripts, and automation to extract and transform data according to Oracle HCM Cloud specifications.
• Coordinate mock conversions, trial loads, and final cutover activities to ensure successful go-live.
• Perform data quality checks, audits, and reconciliations to ensure completeness and accuracy of migrated data.
• Lead issue triage and resolution related to data load errors, validation failures, and transformation logic.
• Ensure compliance with data security and privacy policies during all phases of data handling.
• Provide clear documentation, conversion logs, data dictionaries, and reconciliation reports.
• Support test cycles (System Integration Testing, UAT) and provide data-related defect resolution.
• Work with Oracle and third-party partners to troubleshoot and resolve data conversion issues.
• Strong understanding of Oracle HCM Cloud data structures and functional modules (Core HR, Payroll, Benefits, Talent, Absence, etc.).
• Proficient in SQL, Excel, and ETL tools used for data transformation and reconciliation.
• Experience working with Oracle HDL (HCM Data Loader), HSDL, and Spreadsheet Loader.
• Deep understanding of data mapping, data validation, and reconciliation techniques.
• Experience with legacy HRIS systems (e.g., Workday) is a plus.
• Strong project management and cross-functional collaboration skills.