Oracle Data Integrator (ODI) Consultant

Company DescriptionSonSoft 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 DescriptionOracle 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 ODIAdministration 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 advantageQualificationsBachelor’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 emailor resume.SummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services