Oracle Techno Functional
Posted:
18 November 2026 (2 days ago)
Application Deadline:
15 February 2027
Vacancies:
1 Vacancy
Job Summary
**Hiring:**
Oracle Techno Functional
**Experience**
: 7-10 Years
**Location:**
Bangalore and Hyderabad
**Must Have:**
**1. Oracle Database and PL/SQL**
* Strong PL/SQL: packages procedures functions cursors bulk processing exception handling autonomous logging and transactional control.
* Advanced SQL across large multi-table staging and transform models.
* Execution plans indexes and tuning of slow search dashboard and export queries.
* Views used by the application and reports.
* Safe production data correction on financial tables (status repair reprocess idempotent reruns).
**2. Oracle REST Data Services (ORDS)**
* ORDS modules templates and handlers (GET POST DELETE).
* Handlers that call PL/SQL and return JSON collections.
* Pagination filtering and error payloads consumed by a UI.
* Securing ORDS (IDCS or equivalent).
**3. Oracle Integration Cloud (OIC)**
* Integrations with app-driven scheduled and REST triggers.
* Connections to ATP REST SOAP OCI Object Storage and OCI Streaming.
* Mappings orchestration fault handlers and integration-to-integration calls.
* Tracking instances payloads and failed runs and correlating them to database status.
* Long-running ERP jobs: submit poll and update status.
**4. Oracle Visual Builder and Oracle JET**
* VBCS structure: flows pages fragments action chains variables and event handlers.
* Oracle JET and Redwood components (tables forms navigation).
* JavaScript in action chains.
* Service connections from an OpenAPI catalog (ORDS OIC Object Storage Fusion).
* Search edit submit file upload Excel export and conditional UI.
* Role-based navigation and access control.
**5. Oracle Fusion Financials**
* Oracle Fusion Subledger Accounting (XLA) and General Ledger.
* FBDI / journal import file structure zip packaging and UCM upload.
* ESS job submit and status polling.
* Chart of Accounts segments and posted-account confirmation.
* Debit/credit intercompany and journal line descriptions.
* BI Publisher or SOAP report calls used to pull GL results.
**6. Integration and Cloud**
* REST and JSON including nested payloads.
* SOAP for ERP and BI Publisher calls.
* OCI Object Storage (raw archive error processed buckets).
* OCI Streaming.
* Tracing a transaction across UI ORDS PL/SQL and OIC logs.
Oracle Techno Functional
**Experience**
: 7-10 Years
**Location:**
Bangalore and Hyderabad
**Must Have:**
**1. Oracle Database and PL/SQL**
* Strong PL/SQL: packages procedures functions cursors bulk processing exception handling autonomous logging and transactional control.
* Advanced SQL across large multi-table staging and transform models.
* Execution plans indexes and tuning of slow search dashboard and export queries.
* Views used by the application and reports.
* Safe production data correction on financial tables (status repair reprocess idempotent reruns).
**2. Oracle REST Data Services (ORDS)**
* ORDS modules templates and handlers (GET POST DELETE).
* Handlers that call PL/SQL and return JSON collections.
* Pagination filtering and error payloads consumed by a UI.
* Securing ORDS (IDCS or equivalent).
**3. Oracle Integration Cloud (OIC)**
* Integrations with app-driven scheduled and REST triggers.
* Connections to ATP REST SOAP OCI Object Storage and OCI Streaming.
* Mappings orchestration fault handlers and integration-to-integration calls.
* Tracking instances payloads and failed runs and correlating them to database status.
* Long-running ERP jobs: submit poll and update status.
**4. Oracle Visual Builder and Oracle JET**
* VBCS structure: flows pages fragments action chains variables and event handlers.
* Oracle JET and Redwood components (tables forms navigation).
* JavaScript in action chains.
* Service connections from an OpenAPI catalog (ORDS OIC Object Storage Fusion).
* Search edit submit file upload Excel export and conditional UI.
* Role-based navigation and access control.
**5. Oracle Fusion Financials**
* Oracle Fusion Subledger Accounting (XLA) and General Ledger.
* FBDI / journal import file structure zip packaging and UCM upload.
* ESS job submit and status polling.
* Chart of Accounts segments and posted-account confirmation.
* Debit/credit intercompany and journal line descriptions.
* BI Publisher or SOAP report calls used to pull GL results.
**6. Integration and Cloud**
* REST and JSON including nested payloads.
* SOAP for ERP and BI Publisher calls.
* OCI Object Storage (raw archive error processed buckets).
* OCI Streaming.
* Tracing a transaction across UI ORDS PL/SQL and OIC logs.