Oracle Apex Technical Consultant

  • Posted 3 hours ago | Updated 3 hours ago

Overview

Remote
$140,000 - $160,000
Full Time
No Travel Required

Skills

Apex
Oracle Fusion Cloud
OIC
REST API's
FSM
Functional Setup Manager

Job Details

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Argano