Oracle Apex Technical Consultant - Client Services

JOB SUMMARY:

A Lead Technical Consultant at Argano is a seasoned member of the Technical Consulting team with extensive technical expertise. They have a deep understanding of software development and often serve as technical experts within the company. This person is a skilled Oracle APEX Developer experienced in building enterprise-grade applications and integrations with Oracle Fusion Cloud (ERP/HCM/SCM). This role focuses on developing APEX extensions and REST-based integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, and Oracle PaaS services. A Lead Technical Consultant supports the analysis/design phase of the system development life cycle to deliver best business/technical solutions, while, additionally, ensuring the ability to meet users’ time frames.

RESPONSIBILITIES:

• Design and develop Oracle APEX applications that extend Oracle Fusion Cloud functionality (custom dashboards, approval tools, and process automation).
• Integrate APEX with Oracle Fusion Cloud via REST APIs and Oracle Integration Cloud (OIC) — consume and expose web services securely.
• Develop and maintain OIC integrations (REST/SOAP adapters, file-based integrations, data mappings) for real-time and batch processing.
• Build backend PL/SQL logic, procedures, and REST handlers to support APEX and Fusion interactions.
• Configure and utilize Fusion’s ESS jobs, FBDI templates, and Fusion REST endpoints for data movement between APEX and Fusion.
• Ensure security (OAuth2, JWT, OIC connections) and performance tuning in all integrations.
• Participate in requirement analysis, design reviews, and code walkthroughs.
• Troubleshoot, debug, and resolve technical issues across APEX–Fusion integrations.
• Document design and deployment guides, following best practices maintenance of well documented procedural instructions to hand-off to client
• Participate in requirements, design, and development reviews.
• Work closely with Argano/client resources to transfer technical knowledge and provide guidance on best practices
• Ensure quality of development deliverables by applying proven testing methodologies
• Provide knowledge transfer of Oracle's solutions through meetings, presentation demonstrations
• Status reporting to Reporting Manager

MINIMUM AND/OR PREFERRED QUALIFICATIONS:

• 5+ years of Oracle APEX development experience (APEX 19c or higher).
• 2+ years of Oracle Fusion Cloud technical experience (ERP/HCM/SCM modules).
• Proven experience integrating APEX with Oracle Fusion Cloud using REST APIs (GET/POST/PUT operations).
• Hands-on experience with Oracle Integration Cloud (OIC): developing and managing integrations, connections, and orchestrations.
• Strong PL/SQL and SQL skills; ability to create efficient database logic and web source modules.
• Understanding of Fusion APIs, FBDI, ESS jobs, and Functional Setup Manager (FSM).
• Familiarity with OAuth2 authentication and token-based security for REST API calls.
• Proficient in JavaScript, HTML, and CSS for dynamic APEX UI customization.
• Experience with ORDS and APEX RESTful Services.
• Ability to work independently in a distributed remote team across multiple time zones.
• Excellent written and verbal communication skills in English.