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.