Oracle Fusion ERP Technical Specialist

Ohana Development; Abu Dhabi; On-site; AED 320,000 - 520,000; Full time

Job summary

Ohana Development seeks an Oracle Fusion ERP Technical Specialist to own the technical architecture and integration layer of the enterprise landscape in Abu Dhabi. You will lead end-to-end technical life cycle for integrations (OIC, APIs), reporting (BI Publisher/OTBI), data migrations and workflow automation while coordinating quarterly updates and P2T refreshes.

The role requires 5–8 years ERP tech experience with at least 3 years on Oracle Fusion Cloud; strong API, BI Publisher/OTBI, and data

Qualifications

• Bachelor's degree in computer science, IT, software engineering or a related field.
• Oracle Integration Cloud certification or strong certification preference.
• Experience with Oracle Fusion Cloud ERP, HCM, SCM or Procurement certifications is a plus.
• Strong hands-on experience with Oracle Integration Cloud, REST/SOAP APIs, Fusion adapters, BI Publisher/OTBI, data migration and integration troubleshooting.

Responsibilities

• Design & Support: Build and maintain scalable integrations using OIC, REST/SOAP APIs, and Oracle Adapters across cloud and on-premise systems.
• Specialized System Flow: Maintain robust technical links with Primavera/Unifier, Salesforce, e-invoicing platforms, and banking gateways.
• Process Automation: Configure BPM workflows, approvals, Fast Formulas, ESS jobs, and sandbox extensions.
• Analytics Delivery: Develop and optimize BI Publisher reports, OTBI dashboards, FRS reports, and complex SQL queries.
• Data Migration: Execute and validate data loading using FBDI, ADFDI, HDL, HSDL, HCM Extracts, and UCM.
• Environment Maintenance: Coordinate P2T refreshes, release testing, and quarterly Oracle cloud updates.
• Level 2 Support: Monitor integrations, resolve issues, root-cause analysis, and manage SRs with partners.
• Security & Compliance: Enforce cybersecurity standards, API authentication, PGP encryption, and audit logging.
• Documentation: Maintain technical design docs, report catalogues, interface mappings, and deployment logs.

Skills

Oracle Fusion Cloud

Oracle Integration Cloud (OIC)

REST/SOAP APIs

BI Publisher

OTBI

Data migration

Security & Compliance

Root cause analysis

Vendor coordination

Education

Bachelor's degree in Computer Science/Information Technology/Software Engineering

Oracle Integration Cloud certification

Oracle cloud certifications (ERP/HCM/SCM)

Tools

OIC

REST Adapter

SOAP Adapter

FHIR/HL7 data concepts

BI Publisher

OTBI

FBDI/ADFDI/HDL/HSDL

UCM

Job description

The Oracle Fusion ERP Technical Specialist will own the technical architecture and integration layer of OHANA's enterprise landscape. This role ensures seamless data flow, security, and stability between Oracle Fusion (ERP, HCM, Procurement, SCM) and external ecosystem applications, including Primavera/Unifier, Salesforce, Microsoft 365, banking portals, and third-party systems.

You will lead the end-to-end technical life cycle, covering integrations (OIC, APIs), custom reporting (BI Publisher/OTBI), data migrations, workflow automations, and environment coordination (quarterly updates & P2T refreshes).

Key Responsibilities

Integration & Automation

• Design & Support: Build and maintain scalable integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, and Oracle Adapters across cloud and on-premise systems.
• Specialized System Flow: Maintain robust technical links with Primavera/Unifier, Salesforce, e-invoicing platforms, and banking gateways.
• Process Automation: Configure BPM workflows, approvals, Fast Formulas, ESS jobs, and controlled sandbox extensions.

Reporting & Data Management

• Analytics Delivery: Develop and optimize BI Publisher reports, OTBI dashboards, FRS reports, and complex SQL queries.
• Data Migration: Execute and validate data loading using FBDI, ADFDI, HDL, HSDL, HCM Extracts, and UCM.

Operations, Governance & Security

• Environment Maintenance: Coordinate P2T refreshes, release testing, and seamless management of Oracle quarterly cloud updates.
• Level 2 Support: Monitor integrations, resolve technical issues, conduct root-cause analysis, and manage Oracle Service Requests (SRs) alongside implementation partners.
• Security & Compliance: Enforce enterprise cybersecurity standards, including API authentication, PGP encryption, and audit logging.
• Documentation: Maintain precise documentation, including technical design documents, report catalogues, interface mappings, and deployment logs.

Requirements

• 5-8 years of ERP technical experience, including at least 3 years of hands-on Oracle Fusion Cloud technical experience.
• Strong hands-on experience with Oracle Integration Cloud, REST/SOAP APIs, Fusion adapters, BI Publisher, OTBI, data migration and integration troubleshooting.
• Experience supporting at least one full Oracle Fusion Cloud implementation, migration, major integration rollout or post-go-live support environment.
• Experience integrating Oracle Fusion with CRM, banking, payroll/attendance, procurement, e-invoicing, document management, Microsoft 365, Primavera/Unifier or other third-party systems.
• Strong understanding of ERP, HCM, Procurement and SCM data structures, business objects, interface points and security constraints.
• Experience in a multi-entity, project-based or construction/real-estate organization is strongly preferred.

Required Technical Skills

• Oracle Integration Cloud, Oracle ERP Cloud Adapter, HCM Adapter, REST Adapter, SOAP Adapter and integration monitoring.
• REST/SOAP APIs, JSON, XML, WSDL, XSLT/basic transformations, API authentication, certificates, SFTP, PGP encryption and secure file handling.
• BI Publisher, OTBI, FRS, report data models, SQL, scheduling, bursting and report security.
• FBDI, ADFDI, HDL, HSDL, HCM Extracts, UCM, ESS jobs, file import/export and data reconciliation.
• BPM workflows, notifications, Fast Formula, sandbox configuration and controlled extension approaches.
• Ability to read functional requirements and convert them into technical designs, integration mappings, report specifications and testable deliverables.
• Strong troubleshooting, root-cause analysis, documentation and vendor coordination skills.

Qualifications and Certifications

• Bachelor's degree in computer science, Information Technology, Software Engineering, Computer Engineering or a related field.
• Required or strongly preferred: Oracle Cloud Infrastructure Application Integration Professional / Oracle Integration Cloud certification.
• Preferred: Oracle Fusion Cloud ERP, HCM, SCM or Procurement certification; Oracle Cloud Infrastructure Foundations or Architect Associate.
• Additional advantages: ITIL 4 Foundation, security fundamentals, API/integration certifications or cloud architecture certifications.