Platinus Datamart Systems India Private Limited
Location
Hyderabad | India
Job description
Skills Required :- Experience on using ODI version 12c- Experience in writing complex queries, Stored Procedures in PL/SQL.- Should be able to analyse sql scripts and find the logic and convert them into mapping documents and to the ODI executable code- Ability to design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.- Understanding of ODI administration, maintenance and configuration skills.- Should have strong design and development skills.- Experience working with multiple source/target systems such as Oracle, MS SQL Server, flat files, MS access/excel documents.- Should have experience in developing dimensions and fact tables using ODI.- Experience in high data volume environments/ performance tuning in ODI.- Should be able to configure topology for all the technologies.- 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.- Ability to customize knowledge modules as per the requirement. (ref:hirist.tech)
Job tags
Salary