Oracle Apex Technical Consultant

Oracle Apex Technical Consultant - Client Services 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 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 Advanced English communication skills. 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. About Us Argano is the first of its kind: a digital consultancy totally immersed in high‑performance operations. We steward enterprises through ever‑evolving markets, empowering them with transformative strategies and technologies to exceed customer expectations, unlock commercial innovation, and drive optimal efficiency and growth. Equal Opportunity Statement Argano is an equal‑opportunity employer. All applicants will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status. Seniority level Mid‑Senior level Employment type Full‑time Job function Information Technology Industries IT Services and IT Consulting #J-18808-Ljbffr