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

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

• Job requisition ID: 107275
• Location: Bangalore
• Entity: Deloitte Touche Tohmatsu India LLP

The team

• Oracle Reporting Development & Delivery
• Develop and maintain Oracle BI Publisher reports using data models, data templates, and RTF layouts
• Build and enhance OTBI analyses, dashboards, and subject area reports
• Configure report parameters, prompts, scheduling, and bursting requirements
• Develop operational, financial, and management reports across Oracle Fusion modules
• Support report deployment and migration across environments
• Reporting Analysis & Solution Support
• Analyze business reporting requirements and translate them into reporting solutions
• Understand Oracle Fusion data structures and reporting subject areas
• Develop and optimize SQL queries for report development
• Support custom reporting requirements and data extraction needs
• Assist in report performance tuning and optimization
• Testing & Quality Assurance
• Prepare and execute report test cases
• Support SIT and UAT activities for reporting workstreams
• Validate report outputs against business requirements
• Reconcile report data with Oracle Fusion transactions
• Support defect analysis and issue resolution

Key skills required

• 2–5 years of experience in Oracle reporting, BI, or analytics solutions
• Hands-on experience with BI Publisher (BIP) and/or OTBI
• Strong SQL query development skills
• Understanding of Oracle Fusion reporting concepts and data structures
• Experience in report testing, validation, and troubleshooting
• Experience working in a global delivery or offshore model

Preferred

• Experience with Oracle Fusion Financials, SCM, HCM, or PPM reporting
• Exposure to Oracle Analytics Cloud (OAC) or Fusion Data Intelligence (FDI)
• Experience with data migration, reconciliation, or reporting integrations

Oracle BI Publisher, OTBI, or Analytics certification(s)