Oracle Data Integrator (ODI) Developer
- Zensar
- 5 - 10 years
- Kolkata
- 2 days ago
- Email to a friend
- Report this job
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
- 5+ Yrs. in-depth hands-on experience in developing ETL/ELT interfaces in Oracle Data Integrator (ODI) 11g.
- Develop medium to complex ODI interfaces and using various transformation packages and knowledge modules.
- Ability to diagnose and debug data reconciliation issues and identify fix.
- Migrate and deploy Code to multiple environments.
- Create Load-Plans and schedule the same.
- Performance tuning and optimization of ODI interfaces.
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM.
- Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc..
- Working knowledge of out-of-box OBIA ODI ETL packages/interfaces and KMs is preferable.
- Understanding of ETL concepts, ETL loading strategy, Data reconciliation, ETL Error Handling , Error logging mechanism, standards and Best practices
- Implementation understanding of slowly changing dimensions, late arriving facts, late arriving dimensions, revisions to history, surrogate keys, helper tables, etc.
- Should have strong Hands on ODI Tool and able to design reusable components
- Understanding of Performance Tuning methods, Partitioning and Optimization in ODI
- Experienced in writing and presenting High level ETL design that includes source & target mapping, validations, look ups and business rules
- Should have Experience in deployment strategy, checklist, scheduling and automating the job runs
- Knowledge on shell scripting will be added Advantage
- Very Good knowledge of SQL
- 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 & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: ETL DeveloperEmployement Type: Full timeContact Details:
Company: ZensarLocation(s): Kolkata+ View Contact
Keyskills: Performance tuning Technology consulting Shell scripting Reconciliation Agile Oracle data integrator business rules Scheduling Oracle SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in