Oracle Fusion OTBI ERP Specialist
India
Job Description
Oracle Fusion OTBI ERP Specialist
Bengaluru, Karnataka

Job Summary

The Principal BI Developer I is responsible for designing, implementing, and maintaining the Oracle Fusion Reporting and Analytics Suite, including OTBI, BI Publisher, Fusion Data Intelligence (FDI) and Oracle Analytics Cloud. This role will architect and build data pipelines, enable data integration and extensibility frameworks, and deliver Reporting, analytics solutions to meet evolving business needs. The position also involves administration, performance tuning, and environment migration/setup, while providing training and guidance to business users.

Key Responsibilities

DETAILED RESPONSIBILITIES/DUTIES: 

 

  • Architect and maintain a high-performing Oracle Fusion Reporting and Analytics Suite.
  • Design and implement data pipelines and integration frameworks using Oracle Data Integrator (ODI) or equivalent tools.
  • Develop semantic layers, attributes, metrics, and hierarchies for reporting in Oracle Analytics Cloud.
  • Build and optimize OTBI analyses, BI Publisher reports, and FDI dashboards.
  • Enable extensibility in FDI through custom data ingestion, Data Augmentation and transformation.
  • Perform administration tasks: environment setup, upgrades, schema subscriptions, cache management.
  • Collaborate with business units to translate requirements into technical solutions.
  • Create technical documentation, training materials, and conduct knowledge transfer sessions.
  • Monitor application health and ensure compliance with performance SLAs.

Skill Requirements

Skills:

 

Required

  • Expertise in Oracle Fusion Reporting tools: OTBI, BI Publisher, FDI/FAIDP.
  • Strong experience in data integration (ODI or similar ETL tools).
  • Proficiency in dimensional modeling, data warehouse design, and SQL.
  • Knowledge of Fusion extensibility frameworks and data augmentation techniques.
  • Experience with security architecture, migration activities, and administration.
  • Ability to manage multiple priorities and communicate effectively.

 

 

Certificates / Training:

Oracle BI Publisher, Oracle Data Integrator, Oracle Analytics Cloud, OCI , Oracle Fusion SaaS

 

Experience:

 

  • 10+ years experience in Oracle Fusion Reporting and Analytics Suite development
  • 10+ years experience in data warehouse and schema design architecture
  • 4+ years experience leading implementations
  • 4+ years experience running architecture and administration activities

Other Requirements

1.Oracle Certified Specialist in Oracle Fusion OTBI is preferred.
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.