Oracle Data Integrator (ODI) Consultant

Location: Baltimore, MD, us

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

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:-

1. This is a Full-Time Permanent job opportunity for you.
2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
3. No OPT-EAD, TN Visa & H1B Consultants please.
   
4. Please mention your Visa Status in your email or resume.