Senior Technical Lead

Job Description

Job Summary

We are seeking a senior-level Lead Oracle Fusion Data Intelligence (FDI) Consultant with 10+ years of experience in Oracle Analytics, Data Warehousing, and Oracle Fusion Cloud reporting solutions to lead the implementation, optimization, and support of Oracle Fusion Data Intelligence (FDI) environments. In this role, you will bridge the gap between business strategy and data-driven insights, serving as a trusted advisor to global clients and business stakeholders.

You will lead the design and implementation of enterprise analytics solutions across Oracle Fusion ERP, SCM, HCM, and CX domains, while driving data integration, semantic modeling, dashboard development, and reporting using Oracle Fusion Data Intelligence. You will spearhead end-to-end FDI implementations, including data pipelines, Oracle Autonomous Data Warehouse (ADW), Semantic Model Extensions, custom KPIs, Oracle Analytics Cloud (OAC) dashboards, security, performance optimization, and advanced analytics. The ideal candidate should possess strong expertise in Oracle Fusion business processes, FDI architecture, data modeling, SQL, and analytics best practices, enabling organizations to transform business data into actionable insights and strategic decision-making.

Key Responsibilities

Oracle FDI & OAC Solution Delivery

Lead end-to-end implementation, configuration, and optimization of Oracle Fusion Data Intelligence (FDI) across Oracle Fusion ERP, SCM, HCM, and CX modules.

Design and extend Oracle FDI Semantic Models, including custom subject areas, KPIs, metrics, dimensions, and measures to meet business reporting requirements.

Configure and manage Oracle Fusion Data Intelligence environments, data pipelines, semantic model extensions, and Oracle Autonomous Data Warehouse (ADW) integrations.

Analytics Development & Data Engineering

Design, develop, and optimize enterprise dashboards, scorecards, and self-service analytics using Oracle Analytics Cloud (OAC).

Develop custom datasets, Data Flows, SQL queries, calculations, and advanced visualizations within Oracle Analytics Cloud.

Build and optimize Semantic Models, Logical Fact Tables, Dimensions, Hierarchies, Aggregations, and Row-Level Security.

Develop high-performance SQL queries and optimize Oracle ADW objects including tables, views, materialized views, and indexes for analytics workloads.

Integrate data from Oracle Fusion Applications and external systems using Oracle FDI pipelines, Oracle Data Integrator (ODI), and Oracle Cloud Infrastructure (OCI) services.

Client Advisory & Support Lifecycle

Act as the primary technical advisor for Oracle Fusion Data Intelligence and Oracle Analytics Cloud implementations.

Gather business requirements and translate them into scalable analytics and reporting solutions aligned with Oracle best practices.

Lead environment management, quarterly Oracle Cloud upgrade assessments, regression testing, data validation, and production deployments.

Troubleshoot data pipeline failures, semantic model issues, performance bottlenecks, and dashboard/reporting problems.

Prepare Functional Design Documents (FDD), Technical Design Documents (TDD), Solution Design Documents (SDD), Data Mapping Documents, and lead User Acceptance Testing (UAT), production deployments, and Hypercare support.

Experience Baseline

Required Skills & Qualifications

Minimum 10+ years of IT experience with strong expertise in Oracle Analytics, Oracle Fusion Data Intelligence (FDI), Oracle Analytics Cloud (OAC), Oracle ADW, OTBI, BIP, Oracle BI Reporting, and Enterprise Data Warehousing solutions.

Oracle Fusion Data Intelligence Expertise

Strong experience implementing and supporting Oracle Fusion Data Intelligence (FDI) for Oracle Fusion ERP, SCM, HCM, and CX applications.

Hands-on expertise with Dashboard design, AI Enabling, Semantic Model Extensions, Subject Area customization, KPIs, Metrics, Dimensions, Measures, Calculated Columns, and Security (Data and Object level).

Experience configuring and managing Oracle FDI Data Pipelines, Incremental Loads, Data Validation, Pipeline Monitoring, and Data Quality.

Strong understanding of Oracle Fusion transactional data models and Oracle Autonomous Data Warehouse (ADW).

Oracle Analytics Cloud (OAC)

Expertise in developing interactive dashboards, reports, Data Visualizations, Pixel-Perfect Reports, Data Flows, Workbooks, and Storyboards.

Experience building reusable Semantic Models, Logical Layers, Hierarchies, Aggregations, Variables, and Row-Level Security.

Strong knowledge of performance tuning, caching strategies, and query optimization in Oracle Analytics Cloud.

Technical Skills

Advanced SQL, PL/SQL, Oracle Autonomous Data Warehouse (ADW), Oracle SQL Developer.

Experience with Oracle Data Integrator (ODI), Oracle Cloud Infrastructure (OCI), REST APIs, and external data integrations.

Knowledge of Oracle BI Enterprise Edition (OBIEE), Oracle Analytics Server (OAS), and migration to Oracle Analytics Cloud is highly desirable.

Experience with Oracle FDI administration activities like Metadata migration, catalog migration, Patching, upgradation and maintenance.

Strong analytical, troubleshooting, and performance optimization skills across Oracle Analytics and Data Warehouse platforms.

Qualifications

B.Tech/B.E

Range Of Year Experience-Min Year

10

Range Of Year Experience-Max Year

12