Required Key Skills:
Oracle Data Integrator Developers with Minimum 2 years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.
Strong design and development skills.
Ability to design and develop Interfaces, Packages and Load plans.
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.
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 Standalone and Java EE agents.
Exposure to CDC / Journalizing implementations and customizing knowledge modules.
Good to have exposure on Oracle BIApps 11g (220.127.116.11.1) , configurations and deployments.
Experience in Modeling (logical and Physical) Warehouse and Marts
Exposure to BI/ETL tools such as OBIEE/Informatica ,Tableau, Qlikview would be an added advantage
Strong database design and relational and dimensional data modeling skills (e.g. Oracle, Teradata, MySQL etc.).
Experience in writing complex queries, Stored Procedures preferably in PL/SQL.
Experience with UNIX Operating System, Windows Systems.
Good communication & presentation skills.