Oracle APEX Integration Consultant

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.