Design, develop, and support OIC integrations and BI Publisher reports within Oracle Fusion Cloud environments. Monitor and optimize integration performance while managing data mapping and error handling.
This is a remote position.
Core Skills
Hands-on experience with Oracle Integration Cloud (OIC) and Oracle BI Publisher (BIP) in Oracle Fusion Cloud environments
Strong understanding of Oracle Fusion Cloud business processes (Finance, HCM, SCM, Procurement, etc.)
Experience in designing, developing, and supporting:
OIC Integrations
App-Driven Orchestrations
Scheduled Integrations
File-Based Integrations
Proficiency in working with:
REST APIs
SOAP Web Services
Oracle ERP/HCM Cloud Adapters
FTP/SFTP Integrations
Experience with data mapping, transformations, and error handling in OIC
Ability to monitor, troubleshoot, and optimize integration performance
Strong knowledge of BI Publisher report development
Experience creating and modifying:
Data Models
SQL Queries
Bursting Reports
RTF Templates
Excel Templates
XML Publisher Reports
Knowledge of Oracle Fusion reporting tools:
BI Publisher (BIP)
OTBI (preferred)
Fusion Analytics (good to have)
Experience working with:
SQL and PL/SQL
XML, XSD, XSLT, JSON
Web Services and API integrations
Understanding of Fusion security concepts, roles, and data access controls
Experience in incident management, root cause analysis, and enhancement delivery
Familiarity with migration and deployment across DEV, TEST, and PROD environments
Preferred Skills
Oracle Fusion Financials, HCM, SCM, or Procurement functional knowledge
Experience with FBDI, HDL, HSDL, and Spreadsheet Loaders
Knowledge of Oracle Visual Builder (VBCS) and Oracle APEX
Experience with CI/CD and release management processes
Exposure to Oracle SaaS extensions and Oracle Cloud Infrastructure (OCI)