1. PL/SQL Development Design, develop, and maintain PL/SQL packages, procedures, functions, and structured exception handling aligned with Oracle ERP coding standards and RICEW framework
2. Reporting Build, customize, and optimize reports and dashboards using BI Publisher (BIP) and OTBI across Finance and PPM modules; ensure data accuracy and query performance
3. Payment Templates & Positive Pay Develop and maintain RTF (Check Print) and E-Text (EFT) payment templates; customize and test Positive Pay file templates and support bank transmission configuration and end-to-end validation in coordination with functional consultants
4. SQL, Data Modeling & Query Optimization Write complex SQL queries against Oracle Fusion views to support data models and custom reports; optimize slow-running queries and BIP report data models for performance and efficiency
5. BICC & FBDI — Configure BICC for scheduled data extraction across Finance, PPM, and Procurement; use FBDI for data loads, migrations, and pipeline automation to downstream reporting and analytics systems
6.
ESS Jobs, Value Sets & Lookups — Create and manage custom ESS jobs and job scheduling; configure value sets and lookups to support custom reports, flexfields, and transactional validations within Oracle ERP Cloud
7. REST & SOAP API Integration — Use Oracle Fusion REST and SOAP APIs to perform real-time data operations — create, update, and retrieve records across Finance and PPM modules; experience with tools like Postman or SOAP UI for testing and execution
8. Oracle Integration Cloud (OIC) — Familiarity with OIC concepts, integration flows, and adapters is a plus; ability to support and troubleshoot existing OIC integrations connecting Oracle Fusion with third-party systems
9. UI Configurations & Extensibility — Work within Oracle Fusion Sandboxes to configure and test application extensions; use Page Composer and Application Composer for UI-level customizations; basic familiarity with