Oracle APEX / Integration Consultant

Open 15d

Summary

Oracle APEX developer and integration specialist building forms, interactive reports, and workflows while designing REST/SOAP integrations using Oracle Integration Cloud and Oracle Fusion ERP APIs. Works with PL/SQL, data modeling, and API orchestration to connect enterprise systems.

Core APEX Skills

  • Strong SQL & PL/SQL expertise

  • APEX components: Forms, Interactive Reports, Workflows

  • APEX REST integration capabilities

  • Performance tuning and debugging

? Integration Skills (Critical)

  • Oracle Integration Cloud (OIC)

  • REST & SOAP web services

  • API design, development, and consumption

  • Data transformation, mapping, and orchestration

  • Understanding of integration patterns (real-time, batch, event-driven)

? Database & Backend

  • Oracle Database architecture

  • PL/SQL programming and optimization

  • Data modelling and data validation

? Oracle Cloud & Fusion

  • Exposure to Oracle Fusion ERP APIs and data structures

  • Experience in:

  • FBDI / BICC / OTBI

  • Fusion REST services

  • Knowledge of SaaS extension approaches

? Supporting Technical Skills

  • JSON / XML handling

  • Security (OAuth, token-based authentication)

  • Basic JavaScript (for APEX enhancements)