Job Title: Oracle Fusion Technical Lead (Data & Integration, Individual Contributor)
Location: Remote, US
Type: Contract to hire
Job Summary
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.
Key Responsibilities
- 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.
Preferred Technical Skills
- 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
“Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.”
