Senior Oracle Fusion Technical Consultant (OIC + Reporting)

Experience: 10+ Years

Work Mode: Remote

Shift: 2:00 PM – 11:00 PM IST

Domain: Oracle Fusion ERP – Finance & SCM

Position Overview

We are looking for an experienced Oracle Fusion Technical Consultant with strong expertise in both Oracle Integration Cloud (OIC) and Oracle ERP Reporting. The ideal candidate should have hands-on experience designing and supporting Oracle Fusion integrations while also developing enterprise reporting solutions using BI Publisher (BIP) and OTBI across Finance and SCM modules.

The candidate should be comfortable working across integrations, reporting, data migration, troubleshooting, and production support within Oracle Fusion Cloud environments.

Key Responsibilities

Oracle Integration Cloud (OIC)

- Design, develop, and maintain integrations using Oracle Integration Cloud (OIC).
- Build inbound and outbound integrations between Oracle Fusion ERP and third-party applications.
- Develop and support REST, SOAP, FTP/SFTP, and file-based integrations.
- Configure OIC connections, lookups, orchestrations, mappings, schedules, and fault handling.
- Troubleshoot integration failures and support production incidents.
- Work with ERP Cloud adapters and Fusion web services.

Reporting Development

- Develop and support Oracle BI Publisher (BIP) reports.
- Create and maintain Data Models, RTF Templates, Excel Templates, eText Templates, and Bursting configurations.
- Develop OTBI analyses, dashboards, and subject-area based reports.
- Implement report scheduling, ESS jobs, parameters, and security.
- Write and optimize complex SQL queries for reporting requirements.
- Design Finance and SCM reports based on business requirements.




- Support report reconciliation, validation, and month-end reporting activities.

Data Migration & Technical Support
- Support FBDI and ADFDI-based data migration activities.
- Perform data validation and reconciliation activities.
- Assist with UAT, deployment, go-live, and post-production support.
- Prepare technical documentation, test cases, and deployment documents.

Required Skills

- 10+ years of Oracle ERP technical experience.
- Strong hands-on Oracle Integration Cloud (OIC) experience.
- Strong BI Publisher (BIP) experience.
- Solid OTBI experience.
- Strong SQL / PL-SQL development skills.
- Experience with REST, SOAP, XML, JSON, XSLT, and Web Services.
- Experience with ESS Jobs, Bursting, Data Models, and Report Scheduling.
- Experience in Oracle Fusion Financials and/or SCM.
- Experience with FBDI and ADFDI data migration.
- Understanding of P2P and O2C business processes.
- Strong troubleshooting and production support experience.

Functional Modules

Finance

- General Ledger (GL)
- Accounts Payable (AP)
- Accounts Receivable (AR)
- Fixed Assets (FA)
- Cash Management

SCM
- Procurement
- Purchasing
- Inventory
- Order Management
- Supply Chain

Preferred Skills

- Oracle Fusion Implementation experience.
- Oracle EBS to Fusion migration experience.
- Oracle Fusion Security and Roles.
- Oracle VBCS / Redwood exposure.
- Experience working with global implementation and support projects.
- Agile delivery experience.

Ideal Candidate A senior Oracle Fusion technical professional who can independently handle:

✅ Oracle Integration Cloud (OIC)

✅ BI Publisher & OTBI Reporting

✅ Fusion Finance & SCM

✅ Data Migration (FBDI/ADFDI)

✅ Production Support

✅ P2P & O2C Business Processes

📌 Senior Oracle Fusion Technical Consultant (OIC + Reporting) (India)
🏢 Collaborative Mind
📍 India