Job Title : Oracle FDI Data Warehouse Developer
Location : Remote (Must Work MST Hours)
Type : Contract
Overview
Seeking an experienced Oracle Fusion Data Intelligence (FDI) Developer to architect and build a full FDI Data Warehouse from scratch, supporting Financials and enterprise analytics.
Key Responsibilities
- Architect, design, and develop Oracle FDI Data Warehouse (staging, curated, semantic layers).
- Build fact / dimension models, star schemas, KPIs, and metadata structures.
- Design ELT / ETL pipelines using FDI pipelines, BICC, ODI, or custom ingestion.
- Map ERP Financial (GL / AP / AR / FA / Projects) data into the FDI warehouse.
- Optimize performance, partitioning, error handling, and refresh logic.
- Validate warehouse outputs for OTBI, BIP, DV, and FDI dashboards.
- Work with finance teams to support data validation and reporting needs.
- Document transformations, data mappings, and technical specifications.
Requirements
5 10+ years in Oracle Data & Analytics (FDI, ODI, OBIEE, OAC).3+ years hands-on experience with Oracle Fusion Data Intelligence (FDI).Strong experience building or rearchitecting enterprise data warehouses.Deep understanding of Financials data models (GL, AP, AR, FA, Projects).Expertise with Oracle Cloud ERP data structures, BICC, FBDI, and OTBI.Strong SQL / ELT skills and financial analytics knowledge.Excellent communication; able to work fully remote during MST hours.#Li-BS1