Job Description

Role : Oracle APEX Integration Consultant

n

Location: Current Delhi

n

Experience: 8-10 Years

n

Required Technical Skill Set

n

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

n

Oracle Integration Cloud (OIC)

n

REST & SOAP APIs

n

API Development & Integration

n

Oracle Database & PL/SQL

n

Data Modelling & Validation

n

Oracle Fusion ERP APIs

n

Fusion REST Services

n

JSON/XML Processing

n

OAuth & Token-based Authentication

n

Performance Tuning & Debugging

n

SaaS Extensions & Cloud Integrations

n

Must-Have

n

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

n

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

n

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

n

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

n

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

n

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

n

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

n

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

n

Good-to-Have

n

JSON/XML expertise

n

OAuth security knowledge

n

Exposure to BICC, FBDI and OTBI

n





Responsibility of / Expectations from the Role

n

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

📌 Oracle APEX / Integration Consultant (New Delhi)
🏢 Tata Consultancy Services
📍 New Delhi