Senior Oracle Hyperion ETL Developer

  • Seattle, WA
  • Posted 12 hours ago | Updated 12 hours ago

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2

Skills

Oracle
Hyperion
Hyperion Financial Management
Management
Meta-data Management
Oracle Data Integrator
Data Management
Data Quality
Extract
Transform
Load
Finance
HFM
Analytical Skill
Business Data
Collaboration
Data Integration
Data Loading
Forms
Reporting
SQL
Scripting
Specification Gathering
Translation
Workflow
Writing

Job Details

Title: Senior Oracle Hyperion ETL Developer
Location: Seattle, WA

About the Role:

We are looking for a highly skilled Senior Oracle Hyperion ETL Developer with proven expertise in Financial Data Quality Management Enterprise Edition (FDMEE) and Oracle Data Integrator (ODI). This role is central to designing, developing, and optimizing robust data integration solutions aligned with financial business needs. The ideal candidate will work closely with data architects, analysts, and cross-functional teams to deliver high-performance, scalable ETL processes that support enterprise reporting and planning systems.

Key Responsibilities:

  • Design, develop, and maintain ETL workflows using FDMEE and ODI.

  • Convert business data requirements into detailed technical specifications and FDMEE solutions.

  • Optimize SQL queries and ETL processes for maximum performance and reliability.

  • Collaborate across teams to support data integration across multiple platforms.

  • Manage and monitor FDMEE jobs, workflows, patches, and version upgrades.

  • Troubleshoot issues related to FDMEE load scripts, including table and file-based loading.

  • Engage with stakeholders to clarify integration requirements and deliver appropriate solutions.

  • Apply ETL performance best practices to optimize interface execution times.

Required Skills & Experience:

  • Strong experience with Oracle Hyperion Financial Management (HFM), including:

    • Dimension design, metadata loading, member list management, and data management.

    • Creating data forms, folders, grids, dynamic forms, and cell text.

    • Currency translation, consolidation logic, and writing multi-currency rules.

  • Proficient in using the HFMCopy utility and advanced troubleshooting techniques.

  • Expertise in FDMEE, including:

    • Writing mappings, load formats, configuring workbench settings, and creating event scripts.

    • Transferring data between HFM and Planning applications.

  • Hands-on experience with Oracle Data Integrator (ODI 12c) for loading data into HFM, Anaplan, and Oracle 19C.

  • Strong analytical and reporting skills using Smart View and pre-built reports.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.