Oracle Technical Consultant with Oracle Integration Cloud (OIC) and VBCS

Location: Remote

Job description:

Experience
6 7+ years of overall technical experience in Oracle Applications
3 4 years of hands-on experience with Oracle Integration Cloud (OIC)

Job Summary
We are seeking an experienced Oracle Fusion Applications Technical Consultant with strong expertise in AR, Tax, AP, and GL modules. The ideal candidate will have deep hands-on experience in SQL/PLSQL development, Oracle reporting, Oracle Integration Cloud (OIC), and Oracle Visual Builder Cloud Service (VBCS), along with proven experience in building and maintaining complex revenue and financial data pipelines.

Key Responsibilities
Design, develop, and support technical solutions for Oracle Fusion Financials, with focus on:
o Accounts Receivable (AR)
o Tax
o Accounts Payable (AP)
o General Ledger (GL)
Develop and maintain complex SQL and PL/SQL programs, including packages, procedures, functions, and performance tuning
Build, enhance, and support Oracle Fusion reports, including:
o BI Publisher
o OTBI (as needed)
Design and develop integrations using Oracle Integration Cloud (OIC):
o File Server, REST/SOAP integrations
Develop and maintain applications using Oracle VBCS for custom UI and business workflows
Maintain and enhance complex revenue and financial data pipelines, ensuring data accuracy, reconciliation, and compliance

Required Skills & Qualifications
Strong understanding of Oracle Fusion Financials architecture
Deep functional technical knowledge of AR, Tax, AP, and GL modules
6 7+ years of hands-on SQL / PL/SQL development experience
3 4 years of hands-on experience with Oracle Integration Cloud (OIC)
Experience with BI Publisher (data models, templates, bursting, scheduling and integrating with OIC)
Advanced SQL for reporting and troubleshooting
Proven experience working on complex revenue pipelines and financial data flows
Experience with Oracle REST APIs, FBDI, and web services
Proficiency in developing VBCS applications from scratch with multi-screen functionality.
Expertise in designing and implementing complex OIC integrations, including Oracle Adapters, FTP Adapters, Database Adapters, SOAP/REST Adapters.
Expertise in OIC (ICS), SOAP/REST APIs, JSON, XML, XSD, WSDL
Excellent verbal and written communication skills
Nice to Have
Experience with Oracle Fusion Revenue Management / RMCS
Exposure to Databricks, Snowflake, downstream financial systems, or analytics platforms
Experience in Agile/Scrum delivery environments