Description

No. of Positions : 1

Experience : 5+ Years

Job Location : Bengaluru

Job Type : Full Time

Position/Role : Oracle APEX Responsibilities :

Design and develop interactive web applications using Oracle APEX, ensuring a seamless user experience through dynamic UI components, AJAX-based interactions, and conditional rendering.
Write complex PL/SQL logic, including stored procedures, functions, packages, and database triggers to manage critical business processes such as subscription lifecycles and enforce secure business rules.
Integrate with third-party services, such as Cybersource Payment Gateway, using SOAP and RESTful APIs for secure transaction processing, including authentication, XML/JSON parsing, and response handling.
Utilize Oracle REST Data Services (ORDS) to expose and consume RESTful web services, enabling real-time data exchange between APEX and external systems.
Work with APEX Collections, JSON_TABLE, and CLOB parsing to process, store, and present dynamic API-driven content within APEX applications.
Collaborate across the full Software Development Life Cycle (SDLC), including requirements gathering, UI/UX design, development, testing (including UAT), deployment, and ongoing maintenance/support.
Ensure application security, performance optimization, and compliance with coding standards and best practices.
Document code, processes, and procedures for ongoing knowledge sharing and future enhancements.
Integration with Fusion Applications (P2P, O2C, GL Module, BIP Report) for seamless data exchange and business process alignment.

Required Skills & Experience

Minimum 3 years of experience in Oracle APEX development.
Strong proficiency in PL/SQL development.
Solid experience in integrating with external APIs (SOAP and REST), handling authentication protocols, and parsing JSON/XML data.
Hands-on experience with ORDS, APEX Collections, and advanced SQL techniques.
Familiarity with web technologies such as HTML5, JavaScript, CSS, and jQuery within the APEX framework.
Experience managing complex business logic and transactional operations at the database level.
Excellent problem-solving skills and attention to detail.
Strong communication skills and the ability to work collaboratively with cross-functional teams and stakeholders

(ref:hirist.tech)

Estuate - Oracle APEX Developer