Data Engineer (Oracle Fusion Cloud) at Roth Staffing Companies in Fullerton, California

Job Description:

Job Title: Data Engineer (Oracle Cloud Fusion, OIC, PL/SQL)

Location: 3 days onsite nearby Fullerton, CA (Local candidates to only)

Job Type: Direct-hire

Compensation: $120,000 to 150,000 (Based on experience)


.



Overview



We are seeking an experienced Data Engineer with deep expertise in Oracle Cloud Fusion, Oracle Integration Cloud (OIC), and database programming (PL/SQL) to join our team. The ideal candidate will bring 10-15 years of experience in data engineering, with a focus on transaction log management, real-time data processing, and cloud-based integrations. This role requires someone with a strong understanding of the retail industry (high-volume transactions), to work closely with business teams and deliver solutions tailored to domain-specific needs.



.




Key Responsibilities

• 
  Data Engineering & Integration: Design, implement, and optimize data pipelines, focusing on real-time data processing, API integrations, and data flow between Oracle Fusion Cloud, Oracle Integration Cloud (OIC), and Oracle databases.


• 
  Database Development: Develop and maintain database scripts using PL/SQL, focusing on transaction logs, data retrieval, and efficient database programming (non-DBA functions).


• 
  Transaction Log Management: Handle transaction logs as a core component of daily operations, ensuring accurate and timely data extraction, transformation, and loading (ETL) for real-time processing.


• 
  Oracle Fusion Cloud Integration: Leverage Oracle Fusion Cloud to build and manage cloud-based applications, data integration, and workflows, ensuring seamless connectivity between Fusion Cloud, Oracle databases, and other systems.


• 
  Business Collaboration: Work closely with business stakeholders to understand domain-specific nuances, translating business requirements into technical solutions and ensuring alignment with operational goals.


• 
  Optimization & Troubleshooting: Continuously monitor, optimize, and troubleshoot data systems and integration points to maintain system performance, reliability, and scalability in high-volume transaction environments.


• 
  Documentation & Best Practices: Maintain clear and thorough documentation of data engineering processes, integration workflows, and system configurations to ensure transparency and knowledge sharing across teams.

• 
  Experience:




• Minimum of 10-15 years in data engineering or related roles, with a strong emphasis on cloud-based data solutions, integrations, and Oracle technologies.


• At least 3+ years of experience working specifically with Oracle Fusion Cloud (must have experience beyond Oracle E-Business Suite).


• Solid background in Oracle Integration Cloud (OIC) for seamless data integration across cloud environments.


• Extensive experience in PL/SQL programming for Oracle databases (non-DBA), focusing on data manipulation, query optimization, and transaction processing.




• 
  Retail Experience: Experience working in a retail environment: high-volume retail experience, dealing with large-scale transaction data.


• 
  Transaction Logs: Experience handling and analyzing transaction logs, particularly in real-time transaction environments.


• 
  Technical Skills:




• Expertise in real-time data processing, including API integration, data extraction, and communication between systems.


• Strong understanding of d