Sonsoft Inc
Oracle Data Integrator (ODI) Consultant
About the job
Job Description
• 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
Qualifications
• 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.
Additional Information
** 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.