Role: Oracle APEX / Integration Consultant
Desired Experience : 8 to 10yrs
Location: New Delhi
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.
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.
