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

• 25 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)