Utilize standard and custom Oracle APIs to build tailored system extensions
Design, develop, and deploy custom REST APIs to enable real-time integration between Oracle EBS and external systems
Technical Skills
Deep knowledge of Order Management (OM), Bills of Materials(BOM), Work in Process (WIP), and Shipping Execution (WSH) and working experience with underlying tables, views, standard APIs, and concurrent programs.
Expertise in Oracle PL/SQL, SQL, SQL*Loader, Forms, Reports, Workflow Builder, and BI/XML Publisher.
Proven track record working with standard API/interfaces in Oracle EBS (OM/WIP/Shipping).
Solid experience in exposing standard and custom PL/SQL APIs as functional REST services via JSON/XML payloads
Proficient in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF, and SQL Trace.
Hands-on experience with Java and Python for building standalone utilities or extensions is highly desirable.
Proven ability to diagnose and resolve technical issues across all lifecycle environments (Test, UAT, and Production).
Proficient in Agile/Scrum development methodologies
Excellent verbal and written communication skills.
Strong ability to work in a team and collaborate with business analysts, stakeholders, and DBAs to deliver complex ERP solutions.
Qualifications
Minimum 5-7 years of technical experience in Oracle EBS R12 environment.
Bachelor’s degree in Computer Science or equivalent