OIC Technical Consultant (Integration for HCM)

Role: OIC Technical Consultant (Integration for HCM)

The project requires to work onsite and local at Richmond VA to interact with client on the daily basis.

• no citizenship requirement.
  
  

Background

Inhouse conversion tools, Integration templates and COA translation applications called accelerators to help client project successful. These delivery tools used at multiple projects that requires strong Oracle Cloud implementation experience.

Client Management Skills

• Effective communication skills to understand conversion process, overall Oracle conversion skills.
• PeopleSoft technical experience since the source system for the data conversion is from PeopleSoft and Oracle database custom applications.
• Technical implementation knowledge and hands-on experience of Oracle Cloud HCM, Finance and SCM modules
• SDLC development cycle, code repository, code control and change control process.
  
  

Certification Required

• Oracle Integration Cloud (OIC) certification required.
• Oracle SaaS technical implementation (application developer / implementor) certification
• PL-SQL expert level
  
  

Data Conversion

• Experience in implementing multiple full cycle Oracle HCM and ERP (Finance and SCM) cloud with the latest version of Oracle fusion cloud.
• Strong hand on experience in creating PLSQL query, packages, and Stored Procedure to develop conversion scripts to load Client provided DB queries, flat file in the specific format into HDL, HCM extracts and FBDI.
• Troubleshooting skills in Conversion development in pre-validation, data loading, loading errors and post validation process
• Experience in creating data validation and reconciliation scripts.
• Strong data mapping knowledge to work with business and functional team members.
• Alteryx experience to use conversion template for HCM for the data mapping, translation to create HDL to load the data.
• Understanding of the OIC-ATP, data mapping and translation to create FBDI file required to use conversion tool.
  
  

Integration

• Deep working knowledge and hands-on experience in OIC Gen2/Gen3
• Strong OIC components skills for integration data mapping, transformation between various formats, structures are essential.
• BPEL, Error / Exception handling, OIC adaptors, Callback, ATP based integration development and designing extension using VBCS and BPA, workflow.
• Develop OIC security design to manage the encryption keys.