Senior Oracle Fusion Technical Consultant – BICC / BI / OTBI Reporting

Hyderabad, Telangana
Permanent
Full-time

2 months ago
Apply easily

Job Title: Senior Oracle Fusion Technical Consultant – BICC / BI / OTBI ReportingExperience: 5–8 YearsJob Location: Hyderabad / Chennai / BangaloreJob Summary:We are looking for a Senior Oracle Fusion Technical Consultant with strong hands-on experience in Oracle Fusion Applications, specializing in BICC data extracts, OTBI analytics, and BI Publisher reporting.The ideal candidate will have a proven ability to design scalable reporting solutions, lead technical initiatives, and support enterprise-level Oracle Fusion implementation and support engagements.Key Responsibilities:Reporting & Analytics:

Design, develop, and optimize OTBI reports and dashboards across Fusion modules including Finance, HCM, SCM, and Procurement
Build complex BI Publisher reports using RTF, Excel, XML, bursting, and multi-language features
Translate business reporting requirements into scalable technical solutions and best practices

BICC & Data Extraction:

Lead configuration and execution of BICC extract jobs (full and incremental loads)
Monitor, schedule, and troubleshoot BICC processes and performance issues
Manage data extraction from Oracle Fusion to ADW, ADB, and external data warehouses
Ensure data quality, reconciliation, and audit compliance

Integrations & Technical Ownership:

Support integrations using Fusion REST/SOAP APIs, FBDI, and ADFdi
Collaborate with middleware and data engineering teams for end-to-end integration delivery
Perform impact analysis for Fusion upgrades and patches affecting reports and data extracts

Leadership & Support:

Mentor junior consultants and review technical deliverables
Act as the technical point of contact for reporting and data extraction
Support UAT, production releases, and post-go-live stabilization
Prepare and maintain technical documentation and design specifications

Required Skills:Core Skills:

Oracle Fusion Applications (Finance / HCM / SCM – one or more modules)
BICC – Expert level
OTBI Reports & Dashboards – Advanced
BI Publisher – Advanced (RTF templates, bursting, data templates)
Strong SQL skills and performance tuning expertise

Good to Have:

Oracle Analytics Cloud (OAC)
Autonomous Data Warehouse (ADW)
Fusion REST and SOAP APIs
Knowledge of Fusion security roles, data access, and subject areas

Experience & Qualifications: * 5–8 years of Oracle Fusion Technical experience

Minimum 3+ years of hands-on experience in BICC and BI reporting
Experience working on multiple Fusion implementation or support projects
Oracle Fusion certification is preferred

Soft Skills:

Strong stakeholder communication and presentation skills
Ability to lead technical discussions and solution design
Analytical mindset with strong attention to detail
Team leadership and mentoring capabilities

OSI Digital