Oracle Fusion Applications Technical Consultant

Role: Oracle Fusion Applications Technical Consultant

Duration: 6 months+

Location: Remote (resource need to work during PST/CST hours)

C2C/W2

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. Strong communication skills and the ability to collaborate with business and technical stakeholders are essential.

Key Responsibilities

• Design, develop, and support technical solutions for Oracle Fusion Financials, with focus on:

o Accounts Receivable (AR), Tax, Accounts Payable (AP), 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, OTBI (as needed)

• Design and develop integrations using Oracle Integration Cloud (OIC):

o File Server, REST/SOAP integrations

o Scheduled and event-driven integrations

o Error handling, monitoring, and troubleshooting

o Leverage in-depth knowledge of Oracle Integration Cloud (OIC) and Oracle Platform as a Service (PaaS).

• Develop and maintain applications using Oracle VBCSfor custom UI and business workflows
• Maintain and enhance complex revenue and financial data pipelines, ensuring data accuracy, reconciliation, and compliance
• Collaborate with functional consultants and business users to translate requirements into technical solutions
• Perform production support, root cause analysis, and issue resolution
• Ensure adherence to best practices, security standards, and documentation requirements

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
• Strong troubleshooting and performance tuning skills
• 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