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