Oracle Techno Functional (Bengaluru)

Oracle Techno Functional (Bengaluru)

18 Nov
|
Teamware Solutions
|
Bengaluru

18 Nov

Teamware Solutions

Bengaluru

About the Company

Greetings from Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd

Teamware Solutions (a division of Quantum Leap Consulting Pvt. Ltd.) is a 20+ year industry leader providing IT staffing and consulting services, supporting 4000+ professionals across India, the USA, the Middle East, and APAC for leading GCC clients.

About the Role

We are hiringan Oracle Techno-Functional

- Location: Bangalore
- Work Model: Hybrid
- Experience: 7–10 years.
- Notice Period: Immediate - 15 days

Senior Oracle VBCS Developer – PL/SQL, ORDS & OIC

Technical Skill Set

Layer- Technology

User interface- Oracle Visual Builder (VBCS), Oracle JET, Redwood

Database- PL/SQL on Oracle Autonomous Database (ATP)

API- Oracle REST Data Services (ORDS)

Integration- Oracle Integration Cloud (OIC)

Cloud- OCI Streaming and OCI Object Storage

ERP- Oracle Fusion General Ledger and Subledger Accounting (XLA)

MUST-HAVE

1. Oracle database and PL/SQL

• Robust 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

GOOD TO HAVE

Helpful background.

1. Cruise industry accounting

Not required at hire. Voyage, revenue, non-revenue, correction, and posting steps are in the codebase and can be learned on the job.

• Cruise revenue and non-revenue accounting

• Voyage and batch status lifecycle (raw validated, transformed, ready for import, import success or error, final accounted)

• Corrective entries: change, void, manual create, and mass create

• Mass allocation across sailings

• Validation, transformation, and aggregation rules

• GL account derivation from cross-reference lookups and column mappings

• Source payloads: reservation system, Hybris reclass, and air-ticket components

• Amount reconciliation: passenger vs components, debit vs credit, subledger vs GL

2. Other

• Oracle ATP at a developer level (credentials, grants, DBMS_CLOUD, scheduler jobs)

• Fusion HCM roles or IDCS for application security

• SheetJS or equivalent Excel generation and CSV export

• High-volume financial batch processing and audit requirements

• Oracle Visual Builder 24.10 / 25.10 or Oracle JET 18

• Jira, Confluence, and Git

Please let me know if you are interested in this position and send me your resume to [HIDDEN TEXT]

📌 Oracle Techno Functional (Bengaluru)
🏢 Teamware Solutions
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: oracle techno functional (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: oracle techno functional (bengaluru) / bengaluru