ONTAMS - Sr Oracle EBS Technical Specialist

Posted 5 Days Ago
Be an Early Applicant
2 Locations
In-Office or Remote
Senior level
Information Technology
The Role
Develops, tests, deploys, and supports Oracle EBS R12 technical components across Procure-to-Pay, Order-to-Cash, inventory, manufacturing, workflow, reporting, and data conversion processes. Creates PL/SQL packages, interfaces, APIs, BI Publisher reports, migration scripts, and custom extensions; tunes SQL and resolves SIT/UAT defects. Supports implementation cutover, production deployment, and hypercare while collaborating with functional consultants, DBAs, and technical leads.
Summary Generated by Built In

Builds, unit-tests and deploys RICEFW components on Oracle EBS R12 across Procure-to-Pay and Order-to-Cash, for a contract-manufacturing and consignment process. Works from functional specs written by the SCM and Finance consultants, writes the technical design, and fixes defects through SIT and UAT under the Technical Lead.

ResponsibilitiesKey responsibilities
  1. Read functional specs (MD050), raise gaps with the functional consultants, and write technical designs (MD070), unit test plans and migration scripts.
  2. Build PL/SQL packages, concurrent programs and request sets for P2P flows: requisition to PO, blanket purchase agreements and releases, ASL, receiving, consigned inventory from supplier (ownership transfer, consumption advice) and AP invoice creation.
  3. Build O2C components: sales order import, pick-release and ship-confirm hooks, component-sale invoicing to contract manufacturers through AR AutoInvoice, and receipts reconciliation.
  4. Build extensions such as the Clear-to-Build engine, shortage alert engine and reschedule publication, using Inventory, PO, WIP and BOM tables and public APIs.
  5. Develop BI Publisher reports (data templates, RTF/Excel layouts, bursting), such as the consolidated contract-manufacturer inventory view and consigned aging.
  6. Build and customise Oracle Workflow (PO approval, notifications) and AME rules where approvals change.
  7. Run data conversions (open POs, BPAs, on-hand and consigned balances, item and supplier masters) through open interfaces and APIs, including mock loads and reconciliation reports.
  8. Package objects with FNDLOAD, XDOLoader and migration scripts, hand them to the DBA for SIT, UAT and production, and support cutover.
  9. Tune slow SQL and PL/SQL (explain plans, trace/TKPROF, indexing, bulk processing).
  10. Fix SIT and UAT defects within agreed turnaround, and provide hypercare support for owned objects.
Qualifications

Required Qualification

  • 6–12 years of Oracle EBS R12 technical development, with at least 2 full-cycle implementations (not only support).
  • Strong SQL and PL/SQL: packages, cursors, bulk collect/FORALL, exception handling, performance tuning.
  • Hands-on build on P2P and O2C tables and APIs: PO_HEADERS/LINES, PO_REQUISITION_, RCV_, AP_INVOICES_, OE_ORDER_HEADERS/LINES, WSH_DELIVERY_, RA_CUSTOMER_TRX_, AR_PAYMENT_SCHEDULES, MTL_ (items, on-hand, transactions).
  • Open interfaces and APIs: Requisition Import, PDOI (PO and BPA import), Receiving Open Interface, AP Invoice Interface, Order Import / OE_ORDER_PUB, AutoInvoice, Inventory transaction interface.
  • Concurrent programs, value sets, request sets, AOL setups (menus, functions, responsibilities, profile options, lookups, DFFs).
  • BI Publisher reports from data templates; Oracle Reports (RDF) knowledge.
  • Oracle Workflow Builder and AME basics.
  • FNDLOAD and code migration practices.
  • Writes clear MD070 technical designs and unit test documents.

Good to Have: 

  • Consigned inventory, Outsourced Manufacturing (JMF) or subcontracting tables.
  • WIP and BOM tables and APIs; ASCP/MSC planning tables.
  • OAF personalisation and extension, Oracle Forms (Form Personalization, CUSTOM.pll).
  • Oracle Alerts, XML Gateway, OBIEE.
  • EBS R12.2 online patching rules for custom code (editioning, ADOP-compliant objects).
  • Semiconductor, high-tech or discrete manufacturing domain.
About UsAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Skills Required

  • 6-12 years of Oracle EBS R12 technical development experience
  • At least two full-cycle Oracle EBS implementations
  • Strong SQL and PL/SQL, including packages, cursors, BULK COLLECT, FORALL, exception handling, and performance tuning
  • Hands-on experience with Oracle EBS Procure-to-Pay and Order-to-Cash tables and APIs
  • Experience with Requisition Import, PDOI, Receiving Open Interface, AP Invoice Interface, Order Import, OE_ORDER_PUB, AutoInvoice, and Inventory Transaction Interface
  • Experience with concurrent programs, value sets, request sets, AOL setups, menus, functions, responsibilities, profile options, lookups, and DFFs
  • BI Publisher reporting using data templates and Oracle Reports RDF
  • Oracle Workflow Builder and AME experience
  • FNDLOAD and code migration experience
  • Ability to write MD070 technical designs and unit test documents
  • Experience with consigned inventory, outsourced manufacturing, or subcontracting tables
  • Experience with WIP, BOM, and ASCP/MSC planning tables and APIs
  • OAF personalization and extension, Oracle Forms personalization, or CUSTOM.pll experience
  • Experience with Oracle Alerts, XML Gateway, or OBIEE
  • Knowledge of Oracle EBS R12.2 online patching, editioning, and ADOP-compliant custom objects
  • Semiconductor, high-tech, or discrete manufacturing domain experience

Zensar Technologies Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Zensar Technologies and has not been reviewed or approved by Zensar Technologies.

  • Retirement Support — A 401(k) with company match and immediate vesting is highlighted, with broad fund options available.
  • Wellbeing & Lifestyle Benefits — Work-life balance, remote/hybrid flexibility, and supportive teams are emphasized as strengths that enhance the overall experience.
  • Parental & Family Support — Inclusive policies such as parental leave and access to EAP and dependent medical coverage are promoted across regions.

Zensar Technologies Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pune, Maharashtra
10,000 Employees
Year Founded: 2001

What We Do

Zensar is a leading experience, engineering, and technology solutions company. We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals. With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity. Zensar’s expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes. Zensar is part of the USD 4.4 billion RPG Group. With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa. Visit us at www.zensar.com

Similar Jobs

Remote or Hybrid
2 Locations
289097 Employees

GitLab Logo GitLab

Customer Success Engineer, India

Cloud • Security • Software • Cybersecurity • Automation
Easy Apply
Remote
India
2500 Employees

Atlassian Logo Atlassian

Android Engineer

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office or Remote
560071, Domlur, Karnataka, IND
11000 Employees

Micron Technology Logo Micron Technology

Engineer, STPG PE

Artificial Intelligence • Hardware • Information Technology • Machine Learning
Remote
Gujarat, IND
45000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account