Oracle Autonomous Data Warehouse (ADW) Analyst

Indotronix Avani Group
Akron, OH, United States
12 days ago
Apply on candidateportal.ceipal.com
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours

Tech stack

Data Analysis Data Validation Extract Transform Load (ETL) Data Structures Data Warehousing Data Flow Control Hardware Description Language Identity and Access Management Data Intelligence Oracle (Applications) Standard Sql Oracle Fusion Middleware
+10 more
Data Streaming User Provisioning Software Oracle Integration Solutions Software Troubleshooting Data Loader Enterprise Integration Oracle HCM Oracle Analytics Cloud Oracle Cloud Infrastructure Servicenow

Job description

We are seeking an experienced Oracle Autonomous Data Warehouse (ADW) and Fusion Data Intelligence (FDI) Administrator to support an established Oracle HCM analytics environment.

This is primarily an administration and production support role. The environment is already in place, so this individual will focus on maintaining, monitoring, troubleshooting, securing, and supporting the existing Oracle ADW and FDI ecosystem rather than building a new platform.

The ideal candidate will have hands-on experience supporting Oracle HCM Cloud, ADW, and FDI/FAW, including data loads, environment refreshes, integrations, user access, security, production incidents, and end-to-end HCM data flows., Oracle ADW Administration

  • Administer and support Oracle Autonomous Data Warehouse environments.
  • Manage environment refreshes, maintenance, and configuration changes.
  • Manage users, roles, privileges, provisioning, and security.
  • Monitor environment health, availability, connectivity, and performance.
  • Troubleshoot ADW environment and data-related issues.
  • Support upgrades, patches, and ongoing platform maintenance.

Oracle Fusion Data Intelligence

  • Administer and support Oracle FDI/FAW environments.
  • Monitor scheduled loads, refreshes, batch processes, and data availability.
  • Troubleshoot failed loads, synchronization issues, and data discrepancies.
  • Support FDI configuration, security, and user access.
  • Perform root-cause analysis and resolve production issues.

Oracle HCM Integration Support

  • Support end-to-end Oracle HCM * ADW * FDI data flows.
  • Troubleshoot connectors, integrations, pipelines, and data movement issues.
  • Validate data loads and reconcile data across Oracle platforms.
  • Investigate missing, stale, or incorrect HCM data.
  • Monitor integrations and proactively address failures.
  • Read and troubleshoot Oracle HCM Fast Formulas.

Production & Platform Support

  • Provide day-to-day operational support for critical Oracle environments.
  • Respond to incidents, outages, failed jobs, and end-user issues.
  • Support access management and security administration.
  • Assist with release validation, environment changes, upgrades, and patches.
  • Document configurations, troubleshooting procedures, and operational processes.
  • Partner with HCM functional, data, integration, and technical teams., The primary focus is hands-on administration and ongoing operational support of an established Oracle environment, including:
  • ADW administration
  • FDI/FAW administration
  • Environment refreshes
  • Load monitoring
  • User provisioning and security
  • HCM data-flow support
  • Integration and connector troubleshooting
  • Production support
  • Fast Formula troubleshooting

Requirements

  • 7+ years of experience supporting Oracle technologies in enterprise environments.
  • Hands-on experience with Oracle Autonomous Data Warehouse (ADW).
  • Hands-on experience with Oracle Fusion Data Intelligence (FDI) and/or Fusion Analytics Warehouse (FAW).
  • Experience supporting Oracle HCM Cloud.
  • Experience troubleshooting Oracle HCM * ADW * FDI/FAW data flows.
  • Experience managing environment refreshes and production support activities.
  • Experience with user provisioning, roles, access controls, and security.
  • Experience monitoring and troubleshooting scheduled data loads and refreshes.
  • Experience troubleshooting Oracle integrations, connectors, pipelines, and data movement.
  • Working knowledge of SQL for troubleshooting and data validation.
  • Ability to read, analyze, and troubleshoot Oracle Fast Formulas.
  • Strong understanding of Oracle HCM data structures and integration concepts.
  • Strong troubleshooting, analytical, and communication skills.

Preferred Qualifications

  • Experience creating or modifying Oracle Fast Formulas.
  • Experience with Oracle HCM Data Loader (HDL).
  • Experience with Oracle Analytics Cloud (OAC).
  • Experience supporting large-scale Oracle Cloud environments.
  • Experience with ServiceNow or similar incident-management platforms.
  • Experience supporting complex production integrations., Required Skills : ADW administration FDI/FAW administration Oracle HCM integration/data-flow support Required geographic footprint, ADW administration FDI/FAW administration Oracle HCM integration/data-flow support Required geographic footprint

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on candidateportal.ceipal.com
Prepare application

Good distractions

Loading talks and stories from around this role…