Key Responsibilities

1. Integration Development (OIC)

• Design, build, and deploy inbound and outbound integrations between Oracle Fusion Cloud SaaS and external applications using Oracle Integration Cloud (OIC).
• Implement REST/SOAP web services, file-based integrations (FBDI/HDL), and event-driven orchestration patterns.
• Configure OIC adapters (Oracle SaaS, FTP, Database, REST/SOAP, Kafka/Messaging) and manage security policies.
• Perform payload debugging, exception handling, error resubmission strategies, and integration performance tuning.

2. Reporting & Analytics (BIP / OTBI)

• Build complex SQL-based Data Models, RTF/Excel templates, and XML layouts in Oracle BI Publisher (BIP) for operational documents (e.g., invoices, checks, purchase orders).
• Develop OTBI (Oracle Transactional Business Intelligence) reports and analysis objects.
• Schedule processes, manage bursting definitions, and deliver automated report extracts to secure SFTP servers or downstream applications.

3. Custom Application Development (VBCS) - NICE TO HAVE

• Build responsive web and mobile web applications using Visual Builder Cloud Service (VBCS) to extend standard Oracle Fusion SaaS capabilities.
• Consume Oracle SaaS REST APIs, custom OIC REST endpoints, and external web services within VBCS.
• Apply Oracle Redwood design patterns and standards (using VBS/Visual Builder Studio) for consistent user experience.

4. Architecture & Technical Support

• Create end-to-end technical documentation (MD50/TE040 or equivalent), code artifacts, and unit testing logs.
• Conduct code reviews, resolve production incidents, perform performance optimization, and engage with Oracle Support for SR management.

Qualifications & Requirements

Must-Have Skills:

• Core Technical Stack: Hands-on experience with OIC (App Integration, Process Automation), BI Publisher (BIP), and VBCS.
• Oracle SaaS Knowledge: Functional understanding of Oracle Cloud ERP, HCM, or SCM tables, data models, and REST/SOAP API structures.
• Languages & Standards: Strong SQL/PL-SQL skills, JSON, XML, XSLT, JavaScript, HTML, and CSS.
• Web Services & Tools: Deep working knowledge of RESTful API architecture, HTTP methods, OAuth authentication, and testing tools like Postman/SoapUI.

Nice-to-Have / Preferred:

• Experience with Oracle Visual Builder Studio (VBS) and Oracle Redwood UX framework.
• Familiarity with Groovy Scripting (Application Composer) or Oracle JET.
• Certification in Oracle Cloud Infrastructure (OCI) or Oracle Integration Cloud (OIC) Developer.