Logo for Elfonze Technologies

OIC, BIP, PL SQL

Elfonze Technologies

Roles & Responsibilities

  • Strong hands-on experience with Oracle Integration Cloud (OIC), including App Driven, Scheduled, and Basic Integrations
  • Expertise in integrating Oracle Fusion (ERP/HCM/SCM) with third-party systems using REST/SOAP adapters
  • Experience with Oracle BI Publisher (BIP) and OTBI integration, including report development and bursting
  • Advanced PL/SQL skills: stored procedures, functions, packages, complex queries, and performance tuning

Requirements:

  • Design and develop OIC integrations (App Driven, Scheduled, Basic) and connect Oracle Fusion ERP/HCM/SCM with external systems
  • Implement REST and SOAP adapters, manage lookups, tracking, fault handling, reusable integration patterns, and monitor via Insight Activity Stream
  • Develop BIP reports and templates, including Data and RTF templates, bursting, and OTBI integration
  • Develop PL/SQL components (stored procedures, functions, packages), write complex SQL, and perform performance tuning and exception handling

Job description

This is a remote position.

Roles & Responsibilities

Oracle Integration Cloud (OIC)

  • Design and develop integrations using App Driven, Scheduled, and Basic Integrations

  • Build integrations between Oracle Fusion (ERP/HCM/SCM) and 3rd-party systems

  • Strong experience with REST & SOAP adapters

  • Handle lookups, packages, tracking, and fault handling

  • Implement reusable integrations and best practices

  • Debug and monitor integrations using Insight & Activity Stream

BI Publisher (BIP)

  • Develop Data Templates, RTF Templates, and Bursting Programs

  • Create reports using SQL/PLSQL Data Models

  • Experience in Fusion OTBI + BIP integration

  • Schedule and distribute reports via email, FTP

  • Performance tuning of BIP reports

PL/SQL & SQL

  • Strong hands-on in Stored Procedures, Functions, Packages

  • Writing complex SQL queries, joins, subqueries, analytical functions

  • Experience in performance tuning

  • Knowledge of exception handling, cursors, collections

  • Used PL/SQL in OIC & BIP integrations
Ready to apply?
APPLY
·

Related jobs

Poland

Other jobs at Elfonze Technologies

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

✨

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.