JOB DESCRIPTION

The ideal candidate will possess deep technical reporting expertise and play a critical role in designing, developing, and deploying Oracle Cloud SaaS solutions. The consultant will be responsible for integrating and extending these solutions using Oracle Platform as a Service (PaaS) offerings such as Oracle Integration Cloud (OIC). This role involves writing code, analyzing data, and contributing to design and implementation while delivering high-quality outcomes.
The Technical Consultant will work closely with both business and IT teams to build customizations within Oracle Fusion ERP. Technical areas of focus include VBCS, OIC, PL/SQL, SOAP, REST, ATP Database, OTBI, and ADFDI.

TOP SKILLS & YEARS OF EXPERIENCE

• Oracle Integration Cloud (OIC) Reports – Required – 5 Years
• Building OTBI and BIP Reports – Required – 5 Years
• Proficiency in OIC using REST, SOAP, FBDI, and BI Publisher – Required – 5 Years

• Design and develop RICEW objects (Reports, Interfaces, Conversions, Extensions, and Workflows).
• Create comprehensive Business Requirement Documents (BRDs) for reports, interfaces, conversions, and extensions.
• Develop solutions using Oracle Fusion tools including VBCS, OIC, PL/SQL, SOAP/REST web services, OTBI, and ADFDI.
• Design and build Oracle Integration Cloud (OIC) integrations between Oracle Cloud applications and legacy systems.
• Lead technical design, implementation, and deployment of Oracle ERP Cloud integrations.
• Customize and configure Oracle ERP Cloud using sandbox environments.
• Build reports using BI Publisher (BIP), OTBI, and BICC.
• Work with middleware technologies, particularly Oracle Integration Cloud.
• Utilize Fusion APIs, FBDI, ADF DI Loads, and ESS jobs for integration and data load processes.
• Configure and manage Flex Fields (DFF, EFF, KFF), Lookups, and Value Sets.
• Collaborate with cross-functional teams to analyze business requirements and recommend solutions.
• Create and maintain technical documentation including architecture diagrams, integration design specs, and user guides.
• Mentor junior developers and conduct code reviews to ensure best practices and coding standards are met.
• Provide ongoing support and training on OIC integrations and custom development.