We are looking for an experienced Oracle Fusion Data Intelligence (FDI) Developer to design, develop, and maintain enterprise analytics and data solutions using Oracle Fusion Data Intelligence, Oracle Analytics Cloud (OAC), and Oracle Autonomous Data Warehouse (ADW). The ideal candidate should have strong experience in data modeling, ETL/ELT, analytics, dashboards, and Oracle cloud data technologies.
Key Responsibilities
- Design and develop enterprise data and analytics solutions using Oracle Fusion Data Intelligence (FDI).
- Work with Oracle Fusion Applications data sources and FDI pipelines to support enterprise reporting and analytics.
- Develop and maintain data pipelines, data models, facts, dimensions, and analytical datasets.
- Configure and customize FDI subject areas and extend the data model based on business requirements.
- Develop OAC dashboards, reports, visualizations, and analytical applications.
- Work with Oracle Autonomous Data Warehouse (ADW) for data storage, transformation, and analytical workloads.
- Develop SQL queries, views, transformations, and data validation processes.
- Perform data extraction, transformation, loading, and integration across enterprise data sources.
- Analyze data quality issues and implement appropriate data cleansing and validation processes.
- Optimize data models, SQL queries, dashboards, and data pipelines for performance.
- Work closely with business analysts, functional teams, data architects, and application teams to understand reporting requirements.
- Troubleshoot data pipeline, integration, reporting, and dashboard issues.
- Implement security, access controls, and data governance requirements.
- Support testing, deployment, production releases, and post-production issues.
- Prepare technical documentation for data models, pipelines, reports, dashboards, and integrations.
Required Technical Skills
- Strong hands-on experience with Oracle Fusion Data Intelligence (FDI).
- Experience with Oracle Analytics Cloud (OAC).
- Strong knowledge of Oracle Autonomous Data Warehouse (ADW).
- Strong SQL development and data analysis skills.
- Experience with data modeling, including fact and dimension tables.
- Experience developing OAC dashboards and reports.
- Good understanding of ETL/ELT processes and data pipelines.
- Experience working with Oracle Fusion Cloud Applications data.
- Knowledge of Oracle FDI data warehouse architecture and subject areas.
- Experience with data validation, reconciliation, and troubleshooting.
- Understanding of enterprise data warehousing concepts.
- Experience with Oracle Cloud Infrastructure (OCI) is preferred.