Oracle (BI Cloud Connector (BICC)
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
8 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Oracle BICC SME(BI Cloud Connector (BICC) Sr. BICC Expert with Oracle Fusion Applications Knowledge
Location:NewyorkNY (Hybrid)
Duration: Contract
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 LASTUPDATEDATE-based refresh logic
Identify required View Objects (VOs) validate VO schema attributes and ensure schema-aware incremental loading
Data Movement & Storage Setup
Coordinate with Client Infra team to configure OCI Object Storage for BICC extract landing
Deploy and manage OCI Transfer VM
Implement rclone-based pull & push patterns (OCI AWS S3)
Use cron scheduling and MD5/SHA256 checksum verification
AWS S3 to Snowflake Data Movement Support (Optional)
Collaborate with Snowflake engineers on Snowpipe COPY INTO file format and ingestion tuning
Ensure extracted CSV/Zipped files follow naming conventions for automated ingestion
Logging & Monitoring
Implement audit logging using ESS Job Requests API and BICC Activity API
Manage OCI VM audit logs for rclone command execution
Networking & Infrastructure Coordination
Work with Client Infra and networking team on options like FastConnect Direct Connect for secure non-internet transfers
Troubleshooting & Maintenance
Location:NewyorkNY (Hybrid)
Duration: Contract
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 LASTUPDATEDATE-based refresh logic
Identify required View Objects (VOs) validate VO schema attributes and ensure schema-aware incremental loading
Data Movement & Storage Setup
Coordinate with Client Infra team to configure OCI Object Storage for BICC extract landing
Deploy and manage OCI Transfer VM
Implement rclone-based pull & push patterns (OCI AWS S3)
Use cron scheduling and MD5/SHA256 checksum verification
AWS S3 to Snowflake Data Movement Support (Optional)
Collaborate with Snowflake engineers on Snowpipe COPY INTO file format and ingestion tuning
Ensure extracted CSV/Zipped files follow naming conventions for automated ingestion
Logging & Monitoring
Implement audit logging using ESS Job Requests API and BICC Activity API
Manage OCI VM audit logs for rclone command execution
Networking & Infrastructure Coordination
Work with Client Infra and networking team on options like FastConnect Direct Connect for secure non-internet transfers
Troubleshooting & Maintenance
