Senior Consultant | OTBI | Bengaluru | HR Transformation
On-site · Bengaluru, Karnataka, India
Job Summary
Senior Consultant specializing in OTBI and BI Publisher for Oracle Cloud Applications, responsible for leading the design, development, and deployment of customized OTBI and BI Publisher reports (ERP, HCM, SCM) and collaborating with functional teams to translate requirements into technical specifications. Drives data extraction/transformation, builds data models and templates, performs performance tuning, and troubleshoots data quality and reporting issues. Leads end-to-end SDLC activities, mentors junior staff, and stays current with Oracle Cloud updates to ensure reports meet business needs and client expectations.
Required 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
- 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
- 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
This role has closed. Sorce can match you with similar open roles and apply on your behalf.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.