Job Title:  Consultant | (BI Reports, OTBI, FRS, SmartView) | Bengaluru | Oracle

Consultant | BI reports | Banglore| Oracle

• Job requisition ID: 96714
• Location: Banglore
• Entity: Deloitte Touche Tohmatsu India LLP

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

Oracle Reporting Development & Delivery

• Design and develop BI Publisher reports including data templates, RTF layouts, and bursting definitions
• Build and enhance OTBI analyses, dashboards, and subject areas
• Develop pixel-perfect operational and statutory reports across Oracle Fusion modules (Financials, SCM, HCM)
• Support report migration, testing, deployment, and post-go-live stabilization

Reporting Analysis & Solution Design

• Analyze reporting requirements and map them to BI Publisher and OTBI capabilities
• Understand Oracle Fusion data models, subject areas, and security frameworks
• Write and optimize SQL queries for BI Publisher data templates
• Implement report parameters, prompts, filters, and scheduling
• Ensure reports meet performance, security, and compliance requirements

Key skills required

• 4–7 years of experience in Oracle Reporting or Oracle Fusion Applications
• Strong hands-on experience with BI Publisher (data templates, RTF layouts, bursting)
• Experience building OTBI reports and dashboards
• Strong SQL skills and understanding of Oracle Fusion data models
• Experience working in a global delivery or offshore model