Job Description

Development (Reports & Data Load)

• Design and build custom reports using:

o BI Publisher (BIP) with XML/RTF/Excel templates
o Oracle Transactional Business Intelligence (OTBI)
o Smart View / FRS (optional - Finance)

• Build and validate FBDI, ADFdi, HDL templates for large-scale data operations
• Automate batch uploads, schedule report jobs, and manage ESS processes

Integration & API Work

• Design, build, and deploy REST/SOAP APIs for data exchange with:

o Banking, DMS, SFA, Logistics, Webtel, ERP, and portal systems

• Consume third-party APIs and manage authentication, payload formats (JSON/XML),

and error handling

• Work with Oracle Integration Cloud (OIC) and Oracle PaaS for real-time sync or

scheduled integrations

• Use UCM, interface tables, and staging logic to support inbound/outbound flows

Support & Maintenance

• Troubleshoot report failures, API errors, payload mismatches, and interface failures

MDH Spices. - JD for Oracle Fusion consultant.

• Provide real-time resolution during month-end, data reconciliations, and go-lives
• Own the quarterly Fusion upgrade process, perform impact analysis, test and fix

custom objects
Documentation & Governance

• Maintain technical specs, interface design docs, error logs, SOPs
• Follow version control (Git), promotion paths, and internal audit guidelines