KGS - MC - Oracle HCM - Data Conversion

Job description

Roles and Responsibilities
• Come up with a data conversion strategy for HCM cloud application tailored to client needs

• Explain the HDL/PBL architecture, walkthrough the delivered templates to customer and assist the customer in mapping legacy to Oracle Fusion application fields.

• Understand the data conversion functional requirements and write data mapping specification documents - for Core HR, Payroll and Benefits modules

• If required, write technical specifications for data extraction program logic

• Interact with the other project team members such as functional consultants to understand the impact of configurations on data conversion needs.

• If required, write data extraction/transformation programs (using Oracle PL/SQL or other tools such as Alteryx) to extract the data from legacy applications or transform the file provided by customer into HDL/PBL compatible format.

• Come up with data conversion plan and schedules

• Review and update the conversion runbook from time to time

• Troubleshoot data conversion issues and provide resolution, data cleanup recommendations.

• Define testing scenarios and develop test scripts for functional testing of data conversion and develop data reconciliation reports to ensure the legacy data has been converted correctly.

• Support clients with the execution of test scripts and resolve Issues raise.

• Provide status and issue reports to the Project Manager on a regular basis.

• Develop data reconciliation reports and functional data validation reports to ensure that the data converted is correct and valid for business transactions.

Qualifications and Skills


• Extensive Experience with the data conversion tools such as HDL, PBL and HCM Spreadsheet Data loaders and BIP Reports.

• Very good exposure and technical knowledge on Fast formulas (PBL and Payroll)

• Good exposure to HCM Extracts is preferred

• Strong PL/SQL knowledge is preferred

• Advanced Excel skills such as Pivot, VLookup, writing VBA macros

• Ability to work independently and manage multiple task assignments.

• Ability to lead junior data conversion team members in data conversion track.

• Strong written and oral communication skills, including presentation skills.

• Strong problem solving and troubleshooting skills with the ability to exercise mature judgement.

Experience and Background


• Bachelor's Degree (B.E or B.Tech) is preferred.

o 5+ years of experience in a similar role - for Consultant.

o 7+ years of experience in a similar role - for Assistant Manager

• Expertise in HDL/PBL/Spreadsheet loader tools for Core HR, Payroll and Benefits conversions.

• Must have done at least 2 Oracle HCM implementations with focus on data conversions.

• Oracle HCM Cloud Certified candidate is preferred.