Oracle Data Integrator

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • 10-15 lakh
  • 5-10 years
  • Views
  • 25 Apr 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Should have functional knowledge in either of Finance / HR / Purchasing / Procurement / CRM / Inventory and Pricing.

- Should have good communication skills and need to interact with onsite client and offshore teams. Following skills are a must:

- Ability to design and develop interfaces, packages and load plans

- Understanding of ODI administration, maintenance and configuration skills

- Experience in implementations of Hyperion Financial Data Quality Management Enterprise Edition (FDMEE)

- Experience working with multiple source / target systems such as Oracle, Hyperion Financial Management, Hyperion Planning, Oracle Sales Cloud, Progress, JMS Queue, JMS Queue XML, 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.

- Experience in Modeling (logical and Physical) Warehouse and Marts

- Exposure to BI / ETL tools such as Informatica, Datastage, SSIS, Tableau, Qlikview, Spotfire 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, shell scripting, Windows Systems

- Good communication & presentation skills

- Self-motivated, and able to work independently but fully aligned to an enterprise team.

Job Posted By

O.P. Chawla