Oracle Technical Consultant

JD For OIC Technical Consultant

Total experience - 10+Years

We are seeking an experienced Oracle Technical Consultant specializing in Oracle Integration Cloud (OIC) and BI Publisher (BIP) to design, develop, and implement integration solutions within Oracle Fusion Cloud environments (ERP/HCM/SCM). The ideal candidate will have strong experience in building end-to-end integrations, data conversions, and custom reporting.

Key Responsibilities

Integration Development (OIC): Design and develop robust integration flows using Oracle Integration Cloud (OIC) orchestration, Scheduled, and Application-driven patterns.

Reporting (BIP): Develop and maintain complex BI Publisher (BIP) reports, including RTF, Excel, and PDF templates, using SQL data models.

Data Conversion & Loading: Utilize FBDI (File-Based Data Import) and HDL (HCM Data Loader) for large-scale data migrations and bulk data uploads.

Web Services & Connectivity: Proficient in using SOAP, REST APIs, and configuring OIC Adapters (ERP, FTP, DB, SOAP, REST) to connect Oracle SaaS with third-party systems.

Technical Design: Translate functional specifications into Technical Design Documents (TDD) and create unit test scripts.

Error Handling & Monitoring: Monitor integration performance, debug errors in OIC, and implement robust error-handling frameworks.

Collaboration: Work alongside functional consultants, business analysts, and stakeholders to deliver seamless technology solutions.