Oracle OIC/ APEX Developer

Key Responsibilities

• 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.
• Create 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.
• 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.
• 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

• Bachelor's Degree in Computer Science, Information Technology, or a related field.
• 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.