Oracle APEX / Integration Consultant

Role : Oracle APEX Integration Consultant

Location: New Delhi

Experience: 8-10 Years

Required Technical Skill Set

Oracle APEX (SQL, PL/SQL, Forms, Reports, Workflows)

Oracle Integration Cloud (OIC)

REST & SOAP APIs

API Development & Integration

Oracle Database & PL/SQL

Data Modelling & Validation

Oracle Fusion ERP APIs

Fusion REST Services

JSON/XML Processing

OAuth & Token-based Authentication

Performance Tuning & Debugging

SaaS Extensions & Cloud Integrations

Must-Have

Strong expertise in Oracle APEX development with hands-on experience in SQL, PL/SQL, Forms, Interactive Reports, and workflow-based application development.

Experience designing and implementing integrations using Oracle Integration Cloud (OIC), REST APIs, and SOAP web services.

Proficiency in API design, development, consumption, and integration orchestration across enterprise applications.

Strong understanding of Oracle Database architecture, PL/SQL optimization, data modelling, and data validation techniques.

Experience working with Oracle Fusion ERP APIs, Fusion REST Services, and SaaS extension frameworks.

Knowledge of integration patterns including real-time, batch, and event-driven architectures.

Hands-on experience with JSON/XML processing, data transformation, and secure integrations using OAuth and token-based authentication.

Ability to troubleshoot application and integration issues, perform performance tuning, and deliver scalable cloud-based solutions.

Good-to-Have

JSON/XML expertise

OAuth security knowledge

Exposure to BICC, FBDI and OTBI

Responsibility of / Expectations from the Role

• Design, develop, and support Oracle APEX applications, leveraging Forms, Interactive Reports, workflows, and REST-enabled services to address business requirements.
• Build and manage enterprise integrations using Oracle Integration Cloud (OIC), ensuring reliable connectivity between Oracle Fusion applications and external systems.
• Design, develop, and consume REST and SOAP web services while adhering to enterprise integration and security standards.
• Develop robust API-based solutions involving data transformation, mapping, orchestration, and exception handling across multiple applications.
• Collaborate with business stakeholders, functional consultants, and technical teams to analyze requirements and translate them into scalable technical solutions.
• Optimize Oracle Database objects, PL/SQL programs, and application performance through effective tuning, debugging, and best-practice implementation.
• Integrate Oracle Fusion ERP modules using Fusion REST Services, FBDI, BICC, and other Oracle-recommended integration approaches.
• Implement secure integration frameworks using OAuth, token-based authentication, and industry-standard security practices to protect enterprise data.
• Support application testing, deployment, production issue resolution, and continuous improvement initiatives to ensure operational stability and performance.
• Prepare technical documentation, contribute to knowledge-sharing activities, and provide guidance on Oracle APEX, OIC, and Fusion integration best practices across project teams.