BICC (Oracle Business Intelligence Cloud Connector) SME at NY

VOLTO Consulting; New York (NY); Hybride; USD 120 000 - 170 000; Plein temps

Résumé du poste

VOLTO Consulting seeks a Sr BICC SME to lead Oracle BI Cloud Connector integrations onsite in New York, with hybrid work options. The role covers configuring full and incremental extracts for Fusion modules, VO validation, and secure data movement to OCI and Snowflake.

Strong Oracle Fusion Apps knowledge is essential, along with Spark and Python. The position requires hands-on experience with BICC, OCI services, and cross-functional collaboration with Infra teams to ensure reliable data

Qualifications

• Deep hands on experience with BI Cloud Connector (BICC).
• Strong Oracle Fusion Apps knowledge across Financials, HCM, SCM, FAH, and GL modules.
• Experience with OCI Object Storage, OCI VM, and rclone.
• Familiarity with AWS S3, Snowflake ingestion patterns, and basic SQL.
• Need to have knowledge in Spark & Python

Responsabilités

• BICC Extraction & Fusion Apps Integration Configure and manage BICC extracts for Fusion modules such as Financials, HCM, Procurement, SCM, GL, FAH, PPM, etc.
• Set up Full Extract and Incremental Extract jobs using LAST_UPDATE_DATE based refresh logic Identify required View Objects (VOs), validate VO schema attributes, and ensure schema aware incremental loading.
• Coordinate with Client Infra team to configure OCI Object Storage for BICC extract landing as required by Fusion SaaS and deploy and manage OCI Transfer VM. Implement rclone based pull & push patterns (OCI AWS S3), including: Cron scheduling, MD5/SHA256 checksum verification 3.AWS S3 to Snowflake Data Movement Support (good to have\optional) Collaborate with Snowflake engineers on Snow pipe, COPY INTO, file format, and ingestion tuning, Ensure extracted CSV/Zipped files follow naming conventions suitable for automated ingestion.
• Implement audit logging using: ESS Job Requests API, BICC Activity API, Manage OCI VM audit logs for rclone command execution.
• Understand, discuss and review with Client Infra and networking team on networking options such as FastConnect + Direct Connect for secure, non internet transfers.
• Troubleshoot extract failures, schema changes, Fusion updates, or missing LAST_UPDATE_DATE fields.

Connaissances

BICC expertise

Oracle Fusion Apps

SQL

Python

Spark

Outils

OCI Object Storage

OCI VM

rclone

AWS S3

Snowflake

Description du poste

Role: BICC (Oracle Business Intelligence Cloud Connector) SME - Sr

Location: ONSITE- NY USA - Hybrid

Duration: 6 months

Descriptions: Oracle Business Intelligence Cloud Connector (BICC) Sr.

Must Have Technical/Functional Skills

• Deep hands on experience with BI Cloud Connector (BICC).
• Strong Oracle Fusion Apps knowledge across Financials, HCM, SCM, FAH, and GL modules.
• Experience with OCI Object Storage, OCI VM, and rclone.
• Familiarity with AWS S3, Snowflake ingestion patterns, and basic SQL.
• Need to have knowledge in Spark & Python

Roles & Responsibilities

• BICC Extraction & Fusion Apps Integration Configure and manage BICC extracts for Fusion modules such as Financials, HCM, Procurement, SCM, GL, FAH, PPM, etc.
• Set up Full Extract and Incremental Extract jobs using LAST_UPDATE_DATE based refresh logic Identify required View Objects (VOs), validate VO schema attributes, and ensure schema aware incremental loading.
• Coordinate with Client Infra team to configure OCI Object Storage for BICC extract landing as required by Fusion SaaS and deploy and manage OCI Transfer VM. Implement rclone based pull & push patterns (OCI AWS S3), including: Cron scheduling, MD5/SHA256 checksum verification 3.AWS S3 to Snowflake Data Movement Support (good to have\optional) Collaborate with Snowflake engineers on Snow pipe, COPY INTO, file format, and ingestion tuning, Ensure extracted CSV/Zipped files follow naming conventions suitable for automated ingestion.
• Implement audit logging using: ESS Job Requests API, BICC Activity API, Manage OCI VM audit logs for rclone command execution.
• Understand, discuss and review with Client Infra and networking team on networking options such as FastConnect + Direct Connect for secure, non internet transfers.
• Troubleshoot extract failures, schema changes, Fusion updates, or missing LAST_UPDATE_DATE fields.

Skills: Digital : PAAS Oracle Integration Cloud Experience Required: 6-8