Oracle Application Technical Consultant

JD / Skillset :

NEED IMMEDIATE JOINERS ONLY

Oracle EBS Technical Consultant with 5-8 years of experience in designing, developing, and supporting Oracle E-Business Suite (EBS) R12.

Expertise in Finance (GL, AP, AR, FA, CM) or Supply Chain (PO, OM, INV).

Proficient in developing and maintaining PL / SQL packages, procedures, functions, and triggers to support EBS customizations.

Hands-on experience with advanced PL / SQL features such as Cursors, REF Cursors, Native Dynamic SQL, FORALL, and BULK COLLECT for high-performance data processing.

Skilled in handling SQL operations (DDL, DQL, DML, TCL, DCL), ensuring robust database design and transactional integrity.

Experience in query tuning using explain Plan, indexing, and creation of materialized views to improve reporting performance.

Hands-on experience with RICE components, including Reports (RDF, BI / XML Publisher), Interfaces (Inbound / Outbound), Conversions (Data Migration), and Extensions.

Built and maintained complex inbound and outbound interfaces integrating Oracle EBS with third-party systems such as banks, payment gateways, and logistics providers (WMS, TMS, DHL).

Developed audit-compliant financial reports using Oracle Reports, BI Publisher, XML Publisher, and Report Builder.

Expertise in AOL (Application Object Library), system administration, responsibilities, and EBS security standards.

Proficient in tools such as SQL Developer, TOAD, Workflow Builder, Data Loader, WinSCP, and PuTTY.

Experienced in scripting to automate deployment and development tasks.

Worked in Agile / Scrum environments, collaborating with cross-functional teams to ensure timely and quality delivery of Oracle ERP enhancements.