Oracle Fusion Applications Technical Consultant

Summary: The Oracle Fusion Applications Technical Consultant role involves designing, developing, and supporting technical solutions specifically for Oracle Fusion Financials, with a focus on various financial modules. The consultant will also be responsible for developing SQL and PL/SQL programs, creating reports, and integrating systems using Oracle Integration Cloud. This position requires collaboration with functional consultants and business users to ensure technical solutions meet business needs. The role is remote and requires extensive experience in Oracle technologies and financial systems.

Key Responsibilities:

• Design, develop, and support technical solutions for Oracle Fusion Financials, focusing on Accounts Receivable (AR), Tax, Accounts Payable (AP), and 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 BI Publisher and OTBI as needed.
• Design and develop integrations using Oracle Integration Cloud (OIC), including File Server, REST/SOAP integrations, scheduled and event-driven integrations, error handling, monitoring, and troubleshooting.
• 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.
• 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.

Key Skills:

• 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.

Salary (Rate): £48.00 hourly

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT