Oracle Fusion Finance Technical Consultant

Zensar Technologies; Hyderabad; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Zensar Technologies is seeking an experienced Oracle Fusion Finance Technical Consultant in India. The role focuses on implementing and integrating Oracle Fusion Finance modules with Oracle EBS, developing extensions with Oracle APEX, and building robust data extraction and reporting solutions.

The candidate will design scalable financial data models, optimize PL/SQL code, and work with BI Publisher reports and REST APIs to enable seamless automation and data exchange across finance systems.

Qualifications

• Strong Oracle technical consultant with deep Fusion Finance knowledge.
• Hands-on experience in Oracle Fusion Finance Cloud modules across GL, AP, AR, FA, CM.
• Proficient in SQL/PLSQL and performance tuning for large financial datasets.
• Experience building BI Publisher reports and data models.

Responsibilities

• Design, develop, and support technical solutions for Oracle Fusion Finance modules.
• Integrate Fusion Finance with Oracle EBS.
• Develop extensions using Oracle APEX.
• Create and optimize PL/SQL packages, procedures, and queries.

Skills

Fusion Finance modules

Oracle EBS tech

Oracle APEX development

SQL/PLSQL

BI Publisher

BICC extracts

Oracle REST APIs

FBDI/ADFDI/HDL

Fusion data models

Integration with Oracle EBS

Tools

Oracle Fusion Finance Cloud

Oracle EBS

Oracle APEX

PL/SQL

BI Publisher

BICC extracts

Oracle REST APIs

FBDI

ADFDI

HDL

OIC

OTBI

Smart View

Job description

We are looking for an experienced Oracle Fusion Finance Technical Consultant with strong hands‑on expertise in Oracle Fusion Finance modules, along with Oracle EBS, Oracle APEX, PL/SQL, BI Publisher, BICC extracts, and Oracle REST APIs.

Experience: 8-12 years

Key Responsibilities

• Design, develop, and support technical solutions for Oracle Fusion Finance modules such as GL, AP, AR, FA, CM, Expenses, and Tax.
• Work on technical integrations between Oracle Fusion Finance and Oracle EBS.
• Develop custom applications and extensions using Oracle APEX.
• Build, enhance, and troubleshoot PL/SQL packages, procedures, functions, triggers, and queries.
• Develop and customize BI Publisher reports, data models, templates, and bursting logic.
• Configure and manage BICC extracts for financial data extraction and downstream integrations.
• Work with Oracle REST APIs for finance integrations, automation, and data exchange.
• Support data migration and interface activities using FBDI, ADFDI, HDL where applicable.
• Analyze finance business requirements and translate them into scalable technical designs.
• Collaborate with finance functional consultants, business users, and integration teams.
• Perform issue analysis, debugging, performance tuning, and production support.

Required Skills

• Strong technical experience in Oracle Fusion Finance Cloud modules.
• Good working knowledge of Oracle EBS Finance technical architecture.
• Hands‑on experience with Oracle APEX development.
• Strong expertise in SQL, PL/SQL, and performance tuning.
• Good knowledge of BICC extracts, scheduling, and financial data extraction.
• Experience with Oracle REST APIs, SOAP services, and Fusion web services.
• Understanding of Fusion Finance data models, security roles, ESS jobs, lookups, value sets, and flexfields.
• Experience with finance integrations, custom reports, workflows, and data conversion activities.

Preferred Skills

• Experience with OIC, OTBI, Smart View, FBDI, ADFDI, and Web Services.
• Knowledge of key finance processes such as procure‑to‑pay, order‑to‑cash, record‑to‑report, and fixed assets.
• Exposure to implementation, rollout, upgrade, and support projects.

Candidate Profile

The ideal candidate should be a strong Oracle technical consultant with deep exposure to Fusion Finance modules and prior experience in Oracle EBS Finance. They should be capable of working independently with functional and business teams to deliver robust reports, integrations, extensions, and data extraction solutions.