ONTAMS - Technical Consultant Oracle EBS Cloud RICEF And Reporting

Zensar Technologies; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Zensar Technologies in Pune is seeking a skilled Oracle BI/ETL developer to resolve incidents and build reports using BI Publisher, OTBI, and Oracle Reports. You will work on SQL/PLSQL objects and support EBS customisations, data conversions, and data loads under guidance.

The role requires 4–6 years hands-on experience, strong SQL/PL/BI Publisher skills, and understanding of Oracle applications data models (Financials, SCM). Afternoon shift availability is required.

Qualifications

• 4 to 6 years hands on experience.
• Strong SQL, PL/SQL and BI Publisher; experience with Oracle EBS technical objects and/or Fusion Cloud reporting (BIP/OTBI).
• Understanding of Oracle application data models (Financials, SCM).
• Willing to work the afternoon shift.

Responsibilities

• Resolve technical incidents involving custom reports, interfaces, extensions and data fixes.
• Develop and modify reports using BI Publisher, OTBI and Oracle Reports; build SQL and PL/SQL objects.
• Support EBS customisations (PL/SQL packages, concurrent programs, workflow, Forms/OAF where applicable).
• Support data conversions and FBDI/HDL loads and data-correction scripts with proper approvals.
• Perform unit testing, code reviews (F1), migration and documentation.
• Junior (G0) positions: work under senior guidance on report changes, data analysis and monitoring tasks.

Skills

SQL

PL/SQL

BI Publisher

Oracle EBS

OTBI

Python scripting

Education

BE/B.Tech

MCA

MSc

Tools

OIC

VBCS

Job description

Job Description:

Key Responsibilities

• Resolve technical incidents involving custom reports, interfaces, extensions and data fixes.


• Develop and modify reports using BI Publisher, OTBI and Oracle Reports; build SQL and PL/SQL objects.


• Support EBS customisations (PL/SQL packages, concurrent programs, workflow, Forms/OAF where applicable).


• Support data conversions and FBDI/HDL loads and data-correction scripts with proper approvals.


• Perform unit testing, code reviews (F1), migration and documentation.


• Junior (G0) positions: work under senior guidance on report changes, data analysis and monitoring tasks.

Required Skills & Experience

• 4 to 6 years hands on experience


• Strong SQL, PL/SQL and BI Publisher; experience with Oracle EBS technical objects and/or Fusion Cloud reporting (BIP/OTBI).


• Understanding of Oracle application data models (Financials, SCM).


• Willing to work the afternoon shift.

Preferred / Good to Have

• Oracle SQL / PL/SQL certification.


• Exposure to OIC, VBCS or Python scripting.

Education

B.E. / B.Tech / MCA / M.Sc or an equivalent degree

At 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.