Oracle Analytics Cloud Consultant (FDI ADW ODI)

Solution IT Inc. is looking for Oracle Analytics Cloud Consultant (FDI / ADW / ODI) for one of its clients in Houston TX

Job Title: Oracle Analytics Cloud Consultant (FDI / ADW / ODI)

Summary

We are seeking an experienced Oracle Fusion Reporting & Analytics Developer to design develop and support enterprise reporting solutions using Oracle Fusion Analytics Warehouse (FDI) Autonomous Data Warehouse (ADW) and Oracle Data Integrator (ODI). This role will partner closely with business and technical stakeholders to migrate and integrate data from SAP and other source systems into Oracles analytics ecosystem delivering scalable high-quality dashboards and reports.

Key Responsibilities:

• Design and develop reporting and analytics solutions using Oracle Fusion Analytics Warehouse (FDI) and ADW.
• Build enhance and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
• Support data migration and integration from SAP (BW/BI ECC or S/4HANA) into ADW and FDI. Develop semantic models metrics and KPIs aligned with business requirements.
• Create and optimize SQL queries views and data models in Autonomous Data Warehouse. Partner with functional teams (HCM SCM Finance EPM) to understand Fusion application data structures.
• Perform data validation reconciliation and pre-/post-load checks between SAP and Oracle Fusion.
• Support and enhance FDI/OAC dashboards and reports ensuring performance and usability. Troubleshoot data ETL and reporting issues across environments (Dev Test Prod).
• Document data models ETL logic and reporting standards. Follow data governance security and best practices for enterprise analytics.

Required Skills:

• 5 years of experience in enterprise reporting and analytics development.

Strong hands-on experience with:

• Oracle Fusion Analytics Warehouse (FDI)
• Oracle Autonomous Data Warehouse (ADW)
• Oracle Data Integrator (ODI)
• Advanced SQL development and performance tuning skills.
• Solid understanding of Oracle Fusion Applications data models (HCM SCM Finance or EPM).
• Strong SAP business and reporting knowledge (SAP BW/BI ECC or S/4HANA).
• Experience with data migration and integration from SAP to Oracle platforms.
• Knowledge of data warehousing concepts (facts dimensions star schemas).
• Ability to translate business requirements into technical reporting solutions.

Preferred Qualifications

• Experience with Oracle Analytics Cloud (OAC).
• Prior involvement in SAP-to-Oracle Fusion implementation or transformation projects. Knowledge of Oracle FDI out-of-the-box subject areas and extensibility.
• Experience supporting executive dashboards and operational reporting. Familiarity with data governance security and role-based access.

Work Site: Houston TX

Duration: 6 Months

Expected Start Date: 2 weeks

Number of Positions: 1

Please send your responses back to

About Solution IT

Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston Massachusetts.