Description:
We're seeking an experienced Oracle FAW Consultant to lead the design and implementation of technical solutions for Oracle Analytics Warehouse (FAW/FDI).
Key Responsibilities:
- Collaborate with the implementation team to define and execute the FAW integration strategy for the ERP solution.
- Engage with the reporting committee and business functions to leverage and customize FAW models to meet project requirements.
- Manage data models and data pipelines, ensuring FAW can support external data integration with other platforms.
- Assist with provisioning, configuring, and activating FAW, ensuring data pipeline loads are successful.
- Maintain FAW models and oversee the deployment process from test environments to production, ensuring smooth transitions through various test cycles.
Qualifications:
- Proven experience in implementing Fusion Analytics Warehouse (FAW) and BI Analytics using Oracle Analytics Cloud (OAC) and Autonomous Data Warehouse (ADW).
- Expertise in Oracle ADW, data modeling, SQL development, and data warehouse concepts.
- Experience with custom data warehouse projects using ETL tools like ODI/ODI Marketplace on Oracle Cloud Infrastructure (OCI).
- Strong understanding of Oracle Applications (HCM, ERP, and SCM modules) data models, PVO analysis, and designing star schema models for data warehouses.
- Familiarity with integrating data between Oracle Applications and third-party applications.
- Strong SQL and PL/SQL skills for managing and manipulating Oracle databases.
- Bonus: Previous experience with ODI/OBIA.