Oracle Data Integrator (ODI) Consultant

  • Full-time

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 MartsStrong 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-EADH4-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.