Oracle Data Integrator (ODI) Consultant
SonsoftInc
Posted: December 21, 2016
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
We are seeking an experienced Oracle Data Integrator (ODI) consultant with a strong background in implementing Batch/Real-time Integrations using Oracle 11g. The ideal candidate should have a proven track record of customizing knowledge modules and designing and developing interfaces for various applications.
Required Skills
Job Description
SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
• Oracle Data Integrator (ODI) consultant with overall experience of 4 years and 3+ years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.
• Ability to customize knowledge modules as per the requirement.
• Should have strong design and development skills.
• Ability to design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.
• Understanding of ODI/ODQ administration, maintenance and configuration skills.
• Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents..
• Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs..
• Should have experience in developing dimensions and fact tables using ODI.
• Experience in high data volume environments/ performance tuning in ODI.
• Good to have exposure on ODI Administration and Load Balancing.
• Should be able to configure topology for all the technologies.
• Should be able to configure Standalone and Java EE agents.
• Exposure to CDC / Journalizing implementations and customizing knowledge modules.
• Experience in Modelling (logical and Physical) Warehouse and Marts
Strong database design, relational and dimensional data modelling.
• Experience in writing complex queries, Stored Procedures in PL/SQL.
• Experience with UNIX Operating System, Windows Systems.
• Experience on ODI version 12c would be an added advantage
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience within the Information Technologies.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
• This is a Full-Time Permanent job opportunity for you.
• Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
• No OPT-EAD, TN Visa & H1B Consultants please.
• Please mention your Visa Status in your email or resume.