Oracle EBS developer

Key Responsibilities

• Develop, customize, and maintain Oracle EBS applications across Finance, SCM, Procurement, Inventory, Order Management, and HRMS modules.
• Design and develop PL/SQL packages, procedures, functions, triggers, and performance-tuned database objects .
• Create and modify Oracle Forms, Reports, XML Publisher Reports, BI Publisher Reports, and Oracle Discoverer Reports .
• Develop and support Inbound/Outbound Interfaces using:
• SQL*Loader
• UTL_FILE
• APIs
• Open Interfaces
• Web Services
• Design and develop Oracle Workflow customizations .
• Develop and support Concurrent Programs and Request Sets .
• Troubleshoot production issues and provide timely resolutions.
• Work closely with functional consultants and business users for requirement gathering and solution design.
• Perform code migration across instances using Oracle Application Object Library (AOL).
• Participate in upgrades, patching, and implementation projects.
• Optimize SQL queries and PL/SQL programs for performance improvements.
• Prepare technical design documents and unit test cases.

Required Technical Skills

Oracle EBS

• Oracle EBS R12 / R12.2
• Oracle Applications Framework (OAF)
• AOL Concepts
• System Administration

Oracle Development

• SQL
• PL/SQL
• Performance Tuning
• Packages, Procedures, Functions, Triggers

Reporting Tools

• Oracle Reports
• XML Publisher / BI Publisher
• RDF Reports

Interfaces & Integrations

• SQL Loader
• UTL_FILE
• APIs
• Open Interfaces
• REST/SOAP Web Services
• Oracle Integration Techniques

Oracle EBS Technical Components

• Concurrent Programs
• Value Sets
• Request Sets
• Lookups
• Descriptive Flexfields (DFF)
• Key Flexfields (KFF)
• Workflow Builder