Job Title:  Senior Consultant | Oracle Analytics Cloud | Hyderabad | Oracle

Senior Consultant | Oracle Analytics Cloud | Hyderabad | Oracle
Job requisition ID : 110649 
Location: Hyderabad
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

We are seeking a skilled Oracle Analytics Cloud (OAC) Developer with 5- 8 years of experience in designing, developing, and implementing enterprise reporting and analytics solutions. The ideal candidate should have hands-on experience with Oracle Analytics Cloud, data modeling, dashboard development, and Oracle databases, with the ability to deliver scalable BI and reporting solutions.

Key Responsibilities

  • Design, develop, and maintain interactive dashboards, reports, scorecards, and visualizations using Oracle Analytics Cloud (OAC).
  • Develop and manage semantic models (RPD) and subject areas.
  • Build and optimize data models to support reporting and analytics requirements.
  • Gather business requirements and translate them into technical reporting solutions.
  • Develop BI reports, KPIs, and executive dashboards.
  • Perform data validation, reconciliation, and troubleshooting to ensure data accuracy.
  • Optimize dashboard and query performance.
  • Integrate OAC with Oracle and non-Oracle data sources.
  • Develop and schedule Data Flows and Data Sets within OAC.
  • Collaborate with business users, data engineers, and architects to deliver analytical solutions.
  • Support UAT, production deployment, and post-production activities.
  • Prepare technical documentation and knowledge transfer materials.

Required Skills

  • 3–5 years of experience in Oracle Analytics Cloud (OAC) development.
  • Hands-on experience in creating dashboards, analyses, reports, and data visualizations.
  • Experience in developing and maintaining RPD/Semantic Models.
  • Strong SQL and Oracle Database knowledge.
  • Experience with Oracle BI technologies (OBIEE/OAS/OAC).
  • Knowledge of Data Visualization (DV), Data Flows, and Data Sets in OAC.
  • Experience connecting OAC to Oracle Database, Autonomous Database (ADB), ADW, and other data sources.
  • Strong understanding of dimensional modeling and data warehousing concepts.
  • Experience in performance tuning of dashboards and reports.
  • Familiarity with Oracle Cloud Infrastructure (OCI) is preferred.
  • Experience working in Agile/Scrum environments.

Preferred Skills

  • Experience with Oracle Autonomous Data Warehouse (ADW).
  • Exposure to Oracle Integration Cloud (OIC).
  • Knowledge of ETL tools such as ODI, Informatica, or Azure Data Factory.
  • Experience integrating OAC with ERP, HCM, or Fusion Applications.
  • Knowledge of Power BI or Tableau is an added advantage.
  • Basic scripting knowledge (Shell, Python, or JavaScript) is a plus.
  • Experience with Git or other version control tools.
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • Oracle Analytics Cloud, Oracle Business Intelligence, or Oracle Cloud certifications are preferred.

Soft Skills

  • Strong analytical and problem-solving abilities.
  • Excellent communication and stakeholder management skills.
  • Ability to work independently as well as in a collaborative team environment.
  • Strong documentation and presentation skills.
  • Willingness to learn new Oracle Cloud technologies and best practices.