Oracle EBS Techno-Functional Consultant

We are looking for an experienced Oracle EBS Techno-Functional Consultant with strong expertise in Oracle E-Business Suite R12, General Ledger (GL), Accounts Payable (AP), PL/SQL, and BI Publisher .

The ideal candidate will have a strong combination of technical development and functional knowledge, with experience in requirements gathering, solution design, interface development, testing, data validation, and production implementation.

The role will primarily support the integration of an external procurement system with Oracle EBS , with a focus on designing, developing, testing, and implementing upstream and downstream interfaces.

Key Responsibilities

• Provide techno-functional expertise across Oracle EBS R12 , particularly General Ledger (GL) and Accounts Payable (AP) .
• Design, develop, test, and implement Oracle EBS interfaces and integrations .
• Develop and maintain PL/SQL programs, packages, procedures, and scripts .
• Develop and support BI Publisher reports and solutions .
• Understand and support end-to-end AP, GL, and payment processes .
• Gather and analyze business requirements from end users and stakeholders.
• Conduct requirements workshops and translate business needs into technical/functional solutions.
• Prepare solution designs, technical specifications, and related documentation.
• Develop test scenarios and support unit testing, system testing, and User Acceptance Testing (UAT) .
• Perform data validation, troubleshooting, root-cause analysis, and production issue resolution.
• Support Oracle Data Warehouse/DataMart development using Oracle PL/SQL and Unix.
• Package and release code into production environments following established SDLC processes.
• Collaborate with globally distributed technical, functional, business, and offshore teams.
• Provide technical guidance and effectively communicate with both technical and non-technical stakeholders.
• Support system enhancements and continuous improvement initiatives.

Required Skills & Experience

• 10+ years of experience in Oracle EBS development.
• Strong hands-on experience with Oracle E-Business Suite R12 .
• Extensive experience with Oracle General Ledger (GL) and Accounts Payable (AP) .
• Strong experience developing Oracle EBS interfaces and integrations .
• Advanced PL/SQL development skills.
• Strong experience with Oracle BI Publisher .
• Good understanding of Oracle EBS payment processes .
• Experience with Oracle Data Warehouse/DataMart development .
• Strong Unix/Linux scripting experience.
• Experience with requirements gathering, solution design, development, testing, and implementation.
• Strong understanding of the Software Development Life Cycle (SDLC) .
• Experience preparing technical and functional documentation.
• Experience supporting Unit Testing and UAT .
• Experience with production releases, code packaging, and deployment .
• Strong troubleshooting, analytical, and problem-solving skills.
• Experience working with globally distributed teams and offshore teams .
• Ability to work independently and proactively identify and resolve issues.
• Excellent written and verbal communication skills.

Preferred Candidate Profile

• Strong techno-functional understanding of Oracle EBS rather than purely technical development.
• Ability to translate business requirements into scalable technical solutions.
• Strong understanding of end-to-end Procure-to-Pay (P2P), Accounts Payable, General Ledger, and payment workflows .
• Comfortable working directly with business users and technical teams.
• Strong ownership, organization, and stakeholder management skills.