> Markdown version of [/jobs/ext/4704815-hiring-oracle-senior-fusion-technical-resource-for-remote](https://www.wearedevelopers.com/jobs/ext/4704815-hiring-oracle-senior-fusion-technical-resource-for-remote). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Hiring: Oracle Senior Fusion Technical Resource for Remote - **Company:** Key2Source INC - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Contract - **Skills:** Amazon Web Services, Business Analytics Applications, Data Analysis, Big Data, Cloud Computing, Cloud Engineering, Data Architecture, Data Integration, Data Integrity, Data Mapping, Data Migration, Data Mining, Data Structures, Data Warehousing, Database Schema, Database Storage Structures, Oracle (Applications), Performance Tuning, Query Optimization, SQL Databases, Oracle Fusion Middleware, Systems Integration, Strategies of Testing, Web Services, Enterprise Data Management, Freeform SQL, Bi Publisher, Data Lakes, Data Lineage, AWS Data Analytics, Oracle Analytics Cloud, Oracle Integration - **Published:** November 13, 2026 - **Apply:** https://www.dice.com/job-detail/3c27b848-f866-4b1b-8cfe-41fb384ba940 ## About the Role * Data Model & Table Structure * TCA - Customer and Supplier data models and strong understanding of customer master and party relationships. * SQL & Reporting * BICC * OTBI * BI Publisher * Oracle Analytics Cloud (OAC) * Oracle Integration Cloud (OIC) * REST & SOAP APIs * AWS Data Lake Architecture ## Description Role: Oracle Senior Fusion Technical Resource Or Oracle Fusion Technical Lead (Data & Integration, Individual Contributor), We are seeking an experienced Senior Oracle Fusion Technical Consultant or Oracle Fusion Technical Lead who will be an individual contributor with deep expertise in Oracle Fusion data architecture, table structures, TCA (Trading Community Architecture), BI Cloud Connector (BICC), SQL, and enterprise data extraction frameworks. The ideal candidate will drive data integration, reporting, analytics, and data migration initiatives involving Oracle Fusion Cloud applications and enterprise data platforms, including Data Lakes and AWS environments., * Serve as the senior technical resource or Technical Lead for Oracle Fusion data, reporting, and integration initiatives. * Strong understanding of Oracle Fusion Cloud architecture. * Deep knowledge of Fusion database structures and subject areas * Have experience in + Data Model & Table Structure + TCA - Customer and Supplier data models and strong understanding of customer master and party relationships. + SQL & Reporting * Develop a deep understanding of Oracle Fusion Cloud data models across ERP, HCM, Procurement and Project portfolio modules. * Support data warehouse, analytics, and enterprise reporting initiatives. * Analyze and optimize Oracle Fusion data structures, relationships, and reporting requirements. * Design and implement scalable data extraction solutions using BICC. * Lead data integration efforts between Oracle Fusion and downstream systems such as Data Lakes, AWS, and analytics platforms. * Design data mapping, reconciliation, and validation strategies. * Build and optimize complex SQL queries for reporting and data analysis. * Work closely with functional teams to understand business processes and translate requirements into technical solutions. * Mentor technical team members and establish best practices for data extraction and governance. * Troubleshoot data integrity, reconciliation, and performance issues. * Drive solution design reviews and provide technical leadership for enterprise data initiatives. Required Technical Skills Oracle Fusion Expertise * Strong understanding of Oracle Fusion Cloud architecture. * Deep knowledge of Fusion database structures and subject areas. * Expertise across Fusion modules such as: + Financials (GL, AP, AR, FA, CM) + Procurement + Projects + HCM Data Model & Table Structure * Extensive experience with: + Oracle Fusion Data Model + Core Fusion Table Structures + Entity Relationships + Data Lineage + Reporting Data Stores TCA (Trading Community Architecture) * Hands-on expertise in using + HZ_PARTIES + HZ_CUST_ACCOUNTS + HZ_LOCATIONS + HZ_PARTY_SITES + HZ_CUST_ACCT_SITES_ALL + Customer and Supplier data models * Strong understanding of customer master and party relationships. BICC (BI Cloud Connector) * Expert-level experience with: + BICC Extracts + Incremental Data Extraction + Full Loads + Scheduling and Monitoring + Data Lake Integrations + PVO-based Extractions SQL & Reporting * Advanced SQL development skills. * Query tuning and performance optimization. * Data reconciliation and validation. * Experience creating complex datasets for reporting and analytics.