Oracle FDI Architect

Prophecy Technologies Corp

Buffalo (NY)

On-site

USD 140,000 - 190,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle FDI Architect: Analytics & Data Integration Lead
Senior Oracle FDI Architect: Analytics & Data Integration Lead

Prophecy Technologies Corp • Buffalo (NY)

On-site
USD 140,000 - 190,000
Senior Oracle Fusion Data Intelligence (FDI) Architect / Consultant
Senior Oracle Fusion Data Intelligence (FDI) Architect / Consultant

TechDigital Group • New York (NY)

On-site
USD 180,000 - 240,000
Senior Oracle Fusion Data Intelligence (FDI) Architect - Only W2
Senior Oracle Fusion Data Intelligence (FDI) Architect - Only W2

Saransh Inc • New York (NY)

On-site
USD 140,000 - 200,000
Oracle FDI Solution Architect
Oracle FDI Solution Architect

AppsTek Corp • Palo Alto (CA)

On-site
USD 180,000 - 240,000
Senior Oracle Fusion Analytics Architect
Senior Oracle Fusion Analytics Architect

TechDigital Group • New York (NY)

On-site
USD 180,000 - 240,000
Oracle Fusion Data Intelligence Administrator
Oracle Fusion Data Intelligence Administrator

Select Minds LLC • United States

Remote
USD 120,000 - 180,000
Remote work
Competitive compensation
Opportunities for advancement
Remote Oracle Fusion Data Intelligence Architect
Remote Oracle Fusion Data Intelligence Architect

Select Minds LLC • United States

Remote
USD 120,000 - 180,000
Remote work
Competitive compensation
Opportunities for advancement
Looking for Oracle Fusion Data Intelligence(FDI) urgent need
Looking for Oracle Fusion Data Intelligence(FDI) urgent need

Tech Mirrors • Phoenix (AZ)

On-site
USD 74,000 - 91,000
Oracle FDI & Financial Analytics Solution Architect
Oracle FDI & Financial Analytics Solution Architect

AppsTek Corp • Palo Alto (CA)

On-site
USD 180,000 - 240,000
Oracle FDI & Analytics Manager — Cloud Data Leader
Oracle FDI & Analytics Manager — Cloud Data Leader

EY • McLean (VA)

On-site
USD 143,000 - 262,000