Oracle OIC/ APEX Developer

About the role

We are seeking a highly experienced, hands-on Senior Oracle OIC, Oracle APEX, and Fusion Order Management Developer to support a large-scale Oracle digital transformation initiative. This role will play a critical part in the implementation and enhancement of a custom Oracle APEX-based solution called Vantage, along with the design and development of enterprise integrations using Oracle Integration Cloud (OIC).

The immediate focus of this position will be Oracle Integration Cloud (OIC) and Oracle APEX. The consultant will support ongoing enhancements, integrations, and future modernization initiatives, including Oracle Redwood adoption.

The ideal candidate will possess strong hands-on development experience across Oracle Integration Cloud, Oracle APEX, PL/SQL, and Oracle Fusion applications. Oracle Fusion Order Management experience is highly preferred.

This position requires an individual who can develop end-to-end solutions, including front-end development, back-end development, integrations, database development, and Oracle Fusion connectivity.

Responsibilities

• Oracle Integration Cloud (OIC)
  • Design, develop, and support enterprise integrations using Oracle Integration Cloud (OIC Gen 2 and Gen 3).
  • Build and maintain integration flows, orchestrations, scheduled integrations, and file-based integrations.
  • Develop integrations using REST, SOAP, and event-driven architecture patterns.
  • Configure and support OIC adapters including: REST, SOAP, FTP/SFTP, Database, Kafka.
  • Design reusable integration frameworks, monitoring solutions, and error-handling strategies.
  • Manage OIC environments, security certificates, connection configurations, and deployment pipelines across development, testing, and production environments.
  • Support the organization’s transition from OIC Gen 2 to Gen 3.
• Oracle APEX Development
  • Design, develop, and deploy enterprise-grade Oracle APEX applications from end to end.
  • Build interactive reports, dashboards, forms, workflows, and custom business applications.
  • Develop front-end functionality using: JavaScript, HTML, CSS.
  • Develop and maintain back-end functionality using: PL/SQL, Packages, Procedures, Functions, Triggers.
  • Implement RESTful Web Services and REST Data Sources within APEX.
  • Integrate Oracle APEX applications with Oracle Fusion and third-party systems.
  • Build responsive and accessible applications using APEX Universal Theme and Oracle design standards.
  • Develop APEX plug-ins, dynamic actions, and advanced JavaScript enhancements.
  • Optimize application performance through SQL tuning, query optimization, and efficient PL/SQL design.
  • Manage APEX workspaces, application deployments, version migrations, and environment promotions.
• Oracle Fusion Order Management
  • Support Oracle Fusion Order Management processes and integrations.
  • Maintain orchestration process definitions and task configurations.
  • Troubleshoot order orchestration issues, fulfillment failures, stuck orders, and exception workflows.
  • Support Order-to-Cash business processes and future Order Management enhancements following Vantage go-live.

Required Qualifications

• Education
  • Bachelor’s Degree in Computer Science, Information Technology, or a related field.
• Experience
  • 10+ years of overall IT experience.
  • 8+ years working with Oracle Cloud technologies.
  • 5+ years of hands-on Oracle Integration Cloud (OIC) experience.
  • 8+ years of hands-on Oracle APEX development experience.
  • Strong experience developing complete Oracle APEX solutions including both front-end and back-end components.
  • Strong PL/SQL development experience.
  • Experience integrating Oracle Fusion applications with enterprise systems.
  • Proven ability to serve as a hands-on senior developer rather than solely an architect or manager.

Highly Preferred Experience

• Oracle Fusion Order Management (OM).
• Order orchestration and fulfillment processes.
• Order-to-Cash lifecycle management.
• Oracle Redwood experience.
• Experience supporting large-scale Oracle Cloud implementations and digital transformation initiatives.