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. Required 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.
Top Companies
Hiring Now!