Oracle EBS Technical Developer

Oracle EBS Technical Developer

Location: Los Angeles, CA (Onsite)
Experience: 5–10+ Years
Role: Full-Time

Role Overview:

We are seeking a highly skilled Oracle EBS Technical Developer with strong experience in designing, developing, implementing, and supporting Oracle E-Business Suite (EBS) solutions. The ideal candidate will combine deep technical expertise in PL/SQL, Oracle Forms, Reports, OAF, and XML Publisher with strong experience in RICEW development, integrations, data migration, and performance tuning.

The candidate will collaborate closely with functional and technical teams to deliver robust, scalable, and maintainable enterprise solutions across Finance and Supply Chain Management environments.

Key Responsibilities

• Lead end-to-end technical design and development of Oracle EBS customizations, extensions, and integrations.
• Develop, optimize, and maintain PL/SQL packages, procedures, functions, and materialized views across Finance, SCM, Projects, and HRMS modules.
• Build and maintain Oracle Forms and Reports customizations and migrate legacy forms to modern R12 standards.
• Design and implement integrations between Oracle EBS and third-party systems using REST/SOAP Web Services, Oracle SOA Suite, ICS/OIC, FTP/flat files, and APIs.
• Develop concurrent programs, request sets, and custom managers with a focus on high-volume processing and performance.
• Implement and customize OAF pages and personalizations to enhance workflows and user experience.
• Lead data migration and conversion using SQL*Loader, FBDI, WebADI, CSV/Excel imports, and custom ETL scripts.
• Design and maintain BI/XML Publisher templates, data models, and reporting outputs.
• Troubleshoot production incidents, perform root cause analysis, and support patching, cloning, and upgrade activities.
• Collaborate with offshore/nearshore support teams and contribute to knowledge transfer and training.
   

Required Skills & Experience

• Strong expertise in Oracle EBS R12 / 12.2 development across Finance and SCM modules.
• Advanced PL/SQL programming experience, including packages, cursors, bulk operations, exception handling, collections, and performance tuning.
• Strong experience with Oracle Forms and Reports development and troubleshooting.
• Experience with OAF/ADF page customization and Java development.
• Expertise in building and consuming Web Services for system integrations, including Integrated SOA Gateway.
• Hands-on experience with Oracle APIs, OPEN_INTERFACE tables, FND APIs, and concurrent programs.
• Strong experience with BI/XML Publisher template design for transactional and batch reporting.
• Experience with SQL tuning and performance optimization using EXPLAIN PLAN, SQL Trace, and TKPROF.
• Experience with RICEW object development, data migration, and technical production support.
• Strong analytical, problem-solving, and technical design skills.
• Excellent stakeholder communication and cross-functional collaboration skills.
• Ability to manage multiple priorities in agile/hybrid delivery environments.
• Experience mentoring junior developers and maintaining code-quality standards.
• Strong documentation and testing practices.
   

Nice to Have

• Experience with Oracle APEX development.
• Oracle EBS certifications.
• Master’s degree in Computer Science, Engineering, Information Systems, or a related field.
• Experience with full-lifecycle Oracle EBS implementation and upgrade projects.
• Strong experience with production support, performance tuning, and enterprise-scale EBS environments.