You will manage and execute technical and functional duties within the Oracle EBS Financials ecosystem.
Responsibilities
Design and develop interfaces using Oracle Open Interfaces and Oracle Public APIs.
Build and maintain RICE components including reports, interfaces, conversions, and extensions for data migration.
Develop and customize reports using XML Publisher and manage PL/SQL packages as concurrent programs and request sets.
Perform advanced SQL querying and performance tuning to optimize database operations.
Resolve technical issues by working directly with Oracle Support.
Required Skills
20+ years of relevant experience in Oracle EBS Financials.
Deep knowledge of Accounts Payable, Accounts Receivable, General Ledger, iSupplier, Oracle Projects, and Fixed Assets.
Expertise in PL/SQL, including creating packages, procedures, functions, triggers, views, and materialized views.
Proficiency with Oracle Developer Suite (Forms, Reports, JDeveloper, OAF) and Workflow Builder.
Extensive experience with XML Publisher, SQL*Loader, and WebADI.
Strong Unix Shell Scripting skills.
Experience with Oracle SOA gateway and registering PL/SQL packages as concurrent programs.
A degree from an accredited college/university is required; if the degree is not in a related field, an additional four years of experience is required.
Preferred Skills
Knowledge of iProcurement, Sub-Ledger Accounting, Foreign Post Settlement (FPS), and Treasury Offset Program (TOP).
Experience with Finance Number Control Master (FNCM) and Journal Entry Voucher (JEV).