Sr. Oracle Business Intelligence Cloud Connector (BICC)
Request ID: 83349-1Title: Sr. Oracle Business Intelligence Cloud Connector (BICC)Locations: New York, NY 10001Duration: 6 MonthsRate Range: $65 - $70/Hour on W2 (All inclusive)Note: Applicants must be willing to work on W2Must Have 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 & PythonRoles & Responsibilities1. BICC Extraction & Fusion Apps IntegrationConfigure 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 logicIdentify required View Objects (VOs), validate VO schema attributes, and ensure schema aware incremental loading.2.Coordinate with Client Infra team to configure OCI Object Storage for BICC extract landing as required byFusion SaaS and deploy and manage OCI Transfer VM. Implement rclone based pull & push patterns (OCI AWS S3),including: Cron scheduling, MD5/SHA256 checksum verification3.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/Zippedfiles follow naming conventions suitable for automated ingestion.4. Implement audit logging using: ESS Job Requests API, BICC Activity API,Manage OCI VM audit logs for rclone command execution.5. Understand, discuss and review with Client Infra and networking team on networking options such asFastConnect + Direct Connect for secure, non internet transfers.6. Troubleshoot extract failures, schema changes, Fusion updates, or missing LAST_UPDATE_DATE fields.Skills: Digital: PAAS Oracle Integration CloudExperience Required: 6-8 YearsCompany Benefits & CultureInclusive and diverse work environmentOpportunities for professional growth and developmentComprehensive health and wellness benefitsAppreciate your quick response and please feel free to reach me out for any query you may have.Thanks