Experience: 14+ years preferred
Primary Skill: Oracle E-Business Suite Technical
Functional Exposure: SCM and Finance, Moderate
Role Summary
We are looking for an experienced Oracle EBS Technical Consultant with strong expertise in Oracle E-Business Suite technical development, customization, integration, and production support. The candidate should have hands-on experience across Oracle EBS R12/R12.2 and possess moderate functional understanding of SCM and Finance modules, enabling effective collaboration with functional consultants and business teams.
The ideal candidate should be capable of independently analysing business requirements, performing technical design, developing solutions, troubleshooting complex issues, and supporting end-to-end Oracle EBS implementations, enhancements, integrations, and upgrades.
Key Responsibilities
- Design, develop, customize, and support Oracle EBS R12/R12.2 solutions.
- Develop and troubleshoot:
- PL/SQL packages, procedures, functions, and triggers
- Oracle Reports
- XML Publisher / BI Publisher reports
- Interfaces and conversions
- Concurrent Programs
- Oracle Forms and Forms Personalization
- Workflow / AME solutions
- Application Object Library (AOL) components
- Build and support inbound and outbound integrations between Oracle EBS and external applications using REST/SOAP services, APIs, interface tables, and file-based integration approaches.
- Perform technical analysis of business requirements and prepare Technical Design Documents (TDDs).
- Analyse and resolve production issues involving SQL/PLSQL, concurrent programs, interfaces, workflows, and application data.
- Perform SQL performance tuning and optimize long-running programs and queries.
- Follow Oracle EBS development and deployment standards, including appropriate use of custom schemas, custom application objects, and standard APIs.
- Conduct code reviews, unit testing, defect resolution, and technical documentation.
- Coordinate closely with Finance, SCM, business, integration, DBA, and infrastructure teams.
- Support SIT, UAT, production rollout, hypercare, and BAU support activities.
Mandatory Technical Skills
Candidates should have strong hands-on experience in:
- Oracle E-Business Suite R12/R12.2
- Oracle SQL and PL/SQL
- Packages, procedures, functions, triggers, cursors, collections, and exception handling
- Oracle Forms and Reports
- BI Publisher / XML Publisher
- Oracle Workflow
- Concurrent Programs and AOL
- Oracle EBS APIs and Open Interfaces
- Interface development and troubleshooting
- REST/SOAP Web Services
- XML/JSON processing
- Unix/Linux shell scripting
- SQL performance tuning and debugging
- Oracle EBS table structures and data model
- Technical documentation and deployment processes
Experience with tools such as SQL Developer, TOAD, Git, Jira, ServiceNow, and Oracle Application Framework (OAF) will be advantageous.
SCM Functional Knowledge
The candidate should have moderate functional understanding of Oracle SCM processes and associated technical data flows, preferably covering:
- Inventory (INV)
- Purchasing (PO)
- Basic Procure-to-Pay processes
The candidate is not expected to be an SCM Functional Consultant but should be able to understand business requirements, identify relevant EBS entities/tables/APIs, discuss processes with functional consultants, and independently perform technical analysis.
Finance Functional Knowledge
Moderate functional and technical understanding are expected in:
- General Ledger (GL)
- Accounts Payable (AP)
- Accounts Receivable (AR)
- Fixed Assets (FA)
- Cash Management (CE)
- Basic accounting and period-close concepts
The candidate should understand how SCM transactions flow into Oracle Finance and be able to troubleshoot issues across interfaces, subledgers, SLA, and GL.
