GlobalSource IT · 2 days ago

Oracle Analytics Warehouse (FAW) Consultant

United States

Contract

Remote

Senior Level

Maximize your interview chances

Information TechnologySoftware

Actively HiringU.S. Citizen Only

Hiring Manager

Fred Wachtel

Insider Connection @GlobalSource IT

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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 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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Fusion Analytics WarehouseOracle Analytics CloudAutonomous Data WarehouseData modelingSQL developmentData warehouse conceptsETL toolsOracle Cloud InfrastructureOracle ApplicationsPL/SQLPVO analysisStar schema modelsThird-party applications integrationODI/OBIA

Required

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.

Candidates must have a complete LinkedIn profile.