Oracle Consultant - EBS/APEX Modules (5-10 yrs)

We are seeking an experienced Oracle EBS & APEX Developer with strong expertise in Oracle E-Business Suite (EBS) technical development and Oracle APEX (Application Express). The ideal candidate will be responsible for designing, developing, and testing technical components in Oracle EBS and developing reports in APEX. The role involves working with SQL, PL/SQL, Reports, Forms, Interfaces, and other Oracle EBS technical components while collaborating with functional and technical teams to ensure smooth project delivery.

Key Responsibilities :

- Design, develop, and enhance technical components in Oracle EBS based on functional requirements.

- Develop and maintain Oracle EBS reports, forms, workflows, and interfaces using SQL, PL/SQL, and Oracle Reports.

- Work on Oracle Forms, Oracle Reports, BI Publisher, and XML Publisher for reporting needs.

- Develop and enhance concurrent programs, value sets, alerts, and customizations within Oracle EBS.

- Perform data migration, conversions, and interfaces between Oracle EBS and external systems.

- Develop interactive reports, dashboards, and applications in Oracle APEX.

- Create custom APEX pages, reports, and web-based solutions integrated with Oracle EBS.

- Optimize APEX applications for performance, security, and usability.

- Prepare technical design documents, unit test scenarios, and user guides.

- Conduct unit testing and document results, ensuring high-quality deliverables.

- Assist in debugging and resolving issues related to Oracle EBS and APEX applications.

- Work closely with functional and technical teams to gather requirements and deliver solutions.

- Provide technical support, troubleshooting, and performance tuning for Oracle EBS and APEX applications.

- Collaborate with business users and IT teams to ensure smooth implementation of enhancements and fixes.

Required Skills & Qualifications :

- 5 - 9 years of experience in Oracle EBS Apps technical development and Oracle APEX.

- Strong expertise in SQL, PL/SQL, Oracle Forms, Oracle Reports, BI Publisher, and XML Publisher.

- Experience in developing and maintaining interfaces, workflows, and concurrent programs in Oracle EBS.

- Hands-on experience with Oracle APEX for report development and application enhancements.

- Strong understanding of EBS modules (Financials, Supply Chain, HRMS, etc.).

- Knowledge of Oracle Workflow, AOL (Application Object Library), and FND (Foundation Tables).

- Experience in performance tuning, debugging, and troubleshooting Oracle EBS and APEX applications.

- Experience in APEX 20.x and above for modern web-based development.

- Knowledge of RESTful Web Services, APIs, and integrations with Oracle EBS.

- Exposure to cloud-based Oracle EBS solutions.