Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Oracle Data Integrator (ODI) Developer @ Zensar

Home > DBA / Data warehousing

 Oracle Data Integrator (ODI) Developer

Job Description

ODI Developer
5+ YRS
PUNE/HYDERABAD/BANGALORE
Looking for a workplace where people realize their full potential, are recognized for the impact they make, and enjoy the company of the peers they work with? Welcome to Zensar! Read on for more details on the role and about us.
Whats this role about?
As an ODI Developer need to work with the business to develop new ETL mappings and support the existing ETL mappings for enhancements. as per business requirements.
Heres how youll contribute:
Support and help maintain the existing ODI environment coordinating with other team members and business users.
Skills required to contribute:
5+ years of Experience as ODI Developer
  1. 5+ Yrs. in-depth hands-on experience in developing ETL/ELT interfaces in Oracle Data Integrator (ODI) 11g.
  2. Develop medium to complex ODI interfaces and using various transformation packages and knowledge modules.
  3. Ability to diagnose and debug data reconciliation issues and identify fix.
  4. Migrate and deploy Code to multiple environments.
  5. Create Load-Plans and schedule the same.
  6. Performance tuning and optimization of ODI interfaces.
  7. Must be well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM.
  8. Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc..
  9. Working knowledge of out-of-box OBIA ODI ETL packages/interfaces and KMs is preferable.
  10. Understanding of ETL concepts, ETL loading strategy, Data reconciliation, ETL Error Handling , Error logging mechanism, standards and Best practices
  11. Implementation understanding of slowly changing dimensions, late arriving facts, late arriving dimensions, revisions to history, surrogate keys, helper tables, etc.
  12. Should have strong Hands on ODI Tool and able to design reusable components
  13. Understanding of Performance Tuning methods, Partitioning and Optimization in ODI
  14. Experienced in writing and presenting High level ETL design that includes source & target mapping, validations, look ups and business rules
  15. Should have Experience in deployment strategy, checklist, scheduling and automating the job runs
  16. Knowledge on shell scripting will be added Advantage
  17. Very Good knowledge of SQL
  18. Working knowledge of OAC/ OBI would be an advantage
Advantage Zensar


Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:
  • Putting people first
  • Client-centricity
  • Collaboration
Grow. Own. Achieve. Learn. with Zensar

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: ETL Developer
Employement Type: Full time

Contact Details:

Company: Zensar
Location(s): Kolkata

+ View Contact

Keyskills:   Performance tuning Technology consulting Shell scripting Reconciliation Agile Oracle data integrator business rules Scheduling Oracle SQL

 Job seems aged, it may have been expired!
 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Data Architect

  • Accenture
  • 15 - 20 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 15 - 20 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 5 - 10 years
  • Bengaluru
  • 3 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 12 - 17 years
  • Pune
  • 3 days ago
₹ Not Disclosed

Zensar

Zensar Technologies Limited Zensar Technologies is among the top 25 software and BPO services providers in India. It is an RPG Group company. Headquartered in India, Zensar Technologies has marketing presence in US, Europe and Asia Pacific regions. The company has operations and a customer bas...

IndigoJobs.in © 2026

For enquiries: contact(at)indigojobs.in

We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in