Oracle Autonomous Data Warehouse (ADW) Analyst
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+10 more
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦