Oracle Apex Technical Consultant - Client Services

Keste; Remote; CAD 90,000 - 120,000; Full time

Job summary

A leading technology consulting firm in Canada is looking for a Lead Technical Consultant with extensive experience in Oracle APEX development and Oracle Fusion Cloud integrations. The role includes designing APEX applications, integrating with REST APIs, and developing OIC integrations. Ideal candidates should possess at least 5 years of development experience, strong PL/SQL skills, and the ability to work independently within a remote team. Join us to drive innovative solutions in technical consulting.

Qualifications

• 5+ years of Oracle APEX development experience (APEX 19c or higher).
• 2+ years of Oracle Fusion Cloud technical experience.
• Proficient in JavaScript, HTML, and CSS for APEX UI customization.

Responsibilities

• Design and develop Oracle APEX applications extending Oracle Fusion Cloud functionality.
• Integrate APEX with Oracle Fusion Cloud via REST APIs.
• Develop and maintain OIC integrations for real-time and batch processing.

Skills

Oracle APEX development

Oracle Fusion Cloud integration

REST APIs

PL/SQL and SQL skills

JavaScript

HTML and CSS

OAuth2 authentication

Oracle Integration Cloud (OIC)

Job description

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 Argando/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.