Oracle FDI Architect

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

Oracle FDI Architect

Role Type

Contract

Work Mode

ONSITE

Experience

10

Description

Lead the design and implementation of enterprise analytics solutions using Oracle FDI, Oracle AIDP, OAC, and ODIMP. Architect and develop dimensional data models (fact and dimension structures) to support cross-functional reporting and analytics.

Design and implement data integration frameworks to consolidate data from Fusion and multiple non-Oracle source systems 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 to ensure scalability and reliability.

Provide technical leadership to offshore teams, including solution design reviews, code reviews, estimation, and delivery governance.

Coordinate seamlessly with onsite teams to ensure alignment on requirements, design decisions, delivery timelines, and issue resolution.

Engage in direct client communication to clarify requirements, present solution approaches, address concerns, and ensure stakeholder satisfaction.

Perform detailed validations across ingestion pipelines, transformations, semantic models, and reporting outputs to ensure accuracy, completeness, and adherence to business rules.

Prepare high-quality design documents, technical specifications, and architecture diagrams to support development and stakeholder understanding.

Conduct peer reviews for design, code, and test deliverables to ensure compliance with standards and best practices.

Collaborate with business stakeholders, functional teams, and architects to translate requirements into scalable analytics and reporting solutions.

Ensure adherence to data governance, security, deployment standards, and best practices throughout the project lifecycle.

Experience: 10+ years in Data warehousing & analytics with strong experience in Oracle FDI, Oracle AIDP, OAC, ADW, SQL, Data Modeling and Enterprise Data Integration