Senior Oracle FDI Architect: Analytics & Data Integration Lead

Prophecy Technologies Corp; Buffalo (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Prophecy Technologies Corp is hiring an Oracle FDI Architect to lead enterprise analytics design using Oracle FDI, AIDP, OAC and ODIMP. You will architect dimensional models and data integration frameworks to consolidate Fusion data with non-Oracle sources into a unified analytics platform.

You will drive ETL optimization, oversee offshore teams, review designs, and communicate with clients to ensure alignment on requirements, timelines, and quality.

Qualifications

• 10+ years in data warehousing and analytics.
• Strong experience with Oracle FDI, Oracle AIDP, OAC, and ADW.
• Expertise in SQL, data modeling and enterprise data integration.

Responsibilities

• Lead design and implementation of enterprise analytics solutions using Oracle FDI, Oracle AIDP, OAC, and ODIMP.
• Architect and develop dimensional data models to support cross-functional reporting and analytics.
• Design and implement data integration frameworks to consolidate data from Fusion and non-Oracle sources into a unified analytics platform.
• Lead development of AIDP workflows, data pipelines, extensions, and custom analytical solutions.
• Drive performance optimization across ETL processes, SQL queries, data models, dashboards, and reporting workloads.

Skills

Data warehousing

Analytics

Leadership

Stakeholder communication

Problem solving

SQL

Tools

Oracle FDI

Oracle AIDP

Oracle OAC

ODIMP

ADW

SQL

Job description

Prophecy Technologies Corp is hiring an Oracle FDI Architect to lead enterprise analytics design using Oracle FDI, AIDP, OAC and ODIMP. You will architect dimensional models and data integration frameworks to consolidate Fusion data with non-Oracle sources into a unified analytics platform.

You will drive ETL optimization, oversee offshore teams, review designs, and communicate with clients to ensure alignment on requirements, timelines, and quality.