Senior Consultant | OTBI | Bengaluru | HR Transformation

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Bengaluru; On-site; INR 3,000,000 - 5,000,000; Full time

Job summary

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft seeks an experienced Manager with Oracle OTBI and BI Publisher reporting expertise to design, develop, and deliver tailored reports for Oracle Cloud ERP, HCM, and SCM. You will work with clients to capture requirements and translate them into high-quality reports that meet business needs.

The role requires strong Oracle OTBI/BIP development skills, data modeling, and SQL proficiency, with a focus on performance tuning and reporting best

Qualifications

• Bachelor's degree in CS/IT/Engineering.
• 5+ years in Oracle reporting with OTBI and BI Publisher.
• Proficient with Oracle Cloud modules and data modeling.
• Strong SQL and data retrieval skills.
• Experience with ETL and data warehousing concepts.
• Excellent client-facing communication.

Responsibilities

• Lead design, development, and delivery of OTBI and BI Publisher reports.
• Translate reporting requirements into technical specs with cross-functional teams.
• Develop, customize, and optimize OTBI reports for Oracle Cloud.
• Build and deploy BI Publisher reports with layouts and templates.
• Perform data extraction, transformation, and reporting within Oracle Cloud.
• Troubleshoot OTBI, BI Publisher, and data discrepancies.
• Participate in full SDLC from requirements to deployment.
• Tune performance of OTBI and BIP reports.
• Provide best practices to junior consultants and end-users.
• Stay updated with Oracle Cloud reporting tools.

Skills

Oracle OTBI

BI Publisher (BIP)

SQL

Data Modeling

ETL concepts

Oracle Cloud

Troubleshooting

Client communication

Oracle Analytics Cloud (OAC)

Oracle BI

Education

Bachelor's degree in Computer Science / Information Technology / Engineering

Tools

Oracle Analytics Cloud (OAC)

Oracle BI

Oracle Reports

XML

XSL

Web technologies

Job description

Job Summary

We are seeking an individual with expertise in Oracle OTBI (Oracle Transactional Business Intelligence) and Oracle BI Publisher (BIP) reports.

The ideal candidate will have a strong background in designing and implementing reporting solutions using Oracle Cloud applications and have deep knowledge in developing, customizing, and optimizing reports.

As a Manager, you will work with clients to understand their reporting requirements and deliver tailored, high-quality reports using OTBI and BI Publisher.

Key Responsibilities

• Lead the design, development, and delivery of customized OTBI and BI Publisher reports for Oracle Cloud Applications (ERP, HCM, SCM, etc.).
• Collaborate with functional teams to understand reporting requirements and translate them into technical specifications.
• Develop, customize, and optimize OTBI reports to ensure efficient and accurate reporting from Oracle Cloud applications.
• Build and deploy BI Publisher reports, including layouts, data models, and templates.
• Perform data extraction, transformation, and reporting tasks within Oracle Cloud and integrate with other applications as needed.
• Troubleshoot and resolve issues related to OTBI reports, BI Publisher reports, and data discrepancies.
• Participate in the full SDLC, from gathering requirements and designing reports to testing and deployment.
• Perform performance tuning on OTBI and BIP reports to improve efficiency and data retrieval times.
• Provide best practices and guidance to junior consultants, development teams, and end-users on Oracle reporting tools.
• Work closely with clients to gather feedback and ensure reports meet business needs and user expectations.
• Maintain and enhance existing reports, ensuring they remain aligned with business requirements and Oracle Cloud updates.
• Stay up to date with the latest Oracle Cloud updates and reporting tools enhancements.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Minimum of 5+ years of experience in Oracle reporting, with at least 5 years of hands-on experience in Oracle OTBI and BI Publisher (BIP).
• Strong knowledge of Oracle Cloud applications and how OTBI/BIP integrates with these modules.
• Extensive experience in designing, developing, and deploying OTBI reports and BI Publisher reports.
• Expertise in developing custom layouts, data models, and templates in BI Publisher.
• In-depth understanding of Oracle Data Models, SQL, and data retrieval techniques.
• Familiarity with data warehousing concepts, ETL processes, and reporting best practices.
• Experience in performance tuning of OTBI and BIP reports.
• Strong troubleshooting skills to resolve issues related to data quality, report performance, and functional requirements.
• Knowledge of other Oracle tools like Oracle Analytics Cloud (OAC), Oracle BI, or Oracle Reports is a plus.
• Experience with XML, XSL, and web technologies related to BI Publisher is highly desirable.
• Strong communication and interpersonal skills, with the ability to work directly with clients and business stakeholders.

Preferred Skills

• Oracle certifications in BI, OTBI, or Oracle Analytics Cloud (OAC) are a plus.
• Familiarity with Oracle Cloud security and roles management related to report access.
• Experience in Agile project management or implementation methodologies.
• Familiarity with integration of OTBI/BIP with external systems or third-party tools.

Personal Attributes

• Strong analytical and problem-solving skills with attention to detail.
• Ability to work independently and manage multiple projects simultaneously.
• Customer-focused, with the ability to understand and address client needs effectively.
• Ability to mentor and guide junior consultants and team members.
• Strong organizational and time-management skills, with the ability to prioritize tasks efficiently.