Oracle APEX / Integration Consultant

<p>Role : Oracle APEX Integration Consultant</p><p>Location: New Delhi</p><p>Experience: 8-10 Years</p><p><br></p><p>Required Technical Skill Set</p><p><br></p><p>Oracle APEX (SQL, PL/SQL, Forms, Reports, Workflows)</p><p>Oracle Integration Cloud (OIC)</p><p>REST & SOAP APIs</p><p>API Development & Integration</p><p>Oracle Database & PL/SQL</p><p>Data Modelling & Validation</p><p>Oracle Fusion ERP APIs</p><p>Fusion REST Services</p><p>JSON/XML Processing</p><p>OAuth & Token-based Authentication</p><p>Performance Tuning & Debugging</p><p>SaaS Extensions & Cloud Integrations</p><p><br></p><p>Must-Have</p><p><br></p><p>Strong expertise in Oracle APEX development with hands-on experience in SQL, PL/SQL, Forms, Interactive Reports, and workflow-based application development.</p><p>Experience designing and implementing integrations using Oracle Integration Cloud (OIC), REST APIs, and SOAP web services.</p><p>Proficiency in API design, development, consumption, and integration orchestration across enterprise applications.</p><p>Strong understanding of Oracle Database architecture, PL/SQL optimization, data modelling, and data validation techniques.</p><p>Experience working with Oracle Fusion ERP APIs, Fusion REST Services, and SaaS extension frameworks.</p><p>Knowledge of integration patterns including real-time, batch, and event-driven architectures.</p><p>Hands-on experience with JSON/XML processing, data transformation, and secure integrations using OAuth and token-based authentication.</p><p>Ability to troubleshoot application and integration issues, perform performance tuning, and deliver scalable cloud-based solutions.</p><p><br></p><p>Good-to-Have</p><p><br></p><p>JSON/XML expertise</p><p>OAuth security knowledge</p><p>Exposure to BICC, FBDI and OTBI</p><p><br></p><p>Responsibility of / Expectations from the Role</p><p><br></p><p>Design, develop, and support Oracle APEX applications, leveraging Forms, Interactive Reports, workflows, and REST-enabled services to address business requirements.</p><p>Build and manage enterprise integrations using Oracle Integration Cloud (OIC), ensuring reliable connectivity between Oracle Fusion applications and external systems.</p><p>Design, develop, and consume REST and SOAP web services while adhering to enterprise integration and security standards.</p><p>Develop robust API-based solutions involving data transformation, mapping, orchestration, and exception handling across multiple applications.</p><p>Collaborate with business stakeholders, functional consultants, and technical teams to analyze requirements and translate them into scalable technical solutions.</p><p>Optimize Oracle Database objects, PL/SQL programs, and application performance through effective tuning, debugging, and best-practice implementation.</p><p>Integrate Oracle Fusion ERP modules using Fusion REST Services, FBDI, BICC, and other Oracle-recommended integration approaches.</p><p>Implement secure integration frameworks using OAuth, token-based authentication, and industry-standard security practices to protect enterprise data.</p><p>Support application testing, deployment, production issue resolution, and continuous improvement initiatives to ensure operational stability and performance.</p><p>Prepare technical documentation, contribute to knowledge-sharing activities, and provide guidance on Oracle APEX, OIC, and Fusion integration best practices across project teams.</p>