Diamond Bar, CA30+ days ago
Design, develop, and maintain: • BI Publisher (BIP) reports • OTBI reports and dashboards • SQL/PLSQL programs and data models • Develop and manage FBDI/BICC extracts and inbound data loads • Work with ERP AI Agents and automation frameworks to enable intelligent workflows and proactive monitoring • Build and support Oracle Integration Cloud (OIC) integrations (REST/SOAP, file-based, event-driven) • Troubleshoot and resolve production issues, including ESS jobs, integrations, reports, and data processing pipelines • Support performance tuning, error recovery, and system optimization activities • Participate in release management, migration activities, and environment promotions. Expertise in: • BI Publisher (BIP) • SQL and PL/SQL • OTBI reporting • FBDI, BICC, and ESS jobs • VBCS, APEX, Groovy script or Redwood extensions • ERP AI Agents and Intelligent Automation • Oracle Integration Cloud (OIC) • REST/SOAP services and file-based integrations • Solid understanding of Oracle Fusion data model and security frameworks • Strong functional knowledge of SCM, Manufacturing, and Finance modules • Experience supporting enterprise production environments and Hypercare/post-go-live operations.