*Job Title:* Senior Data Warehouse (DW) Consultant *Location: *Cincinnati, OH
*Duration* : 1+ year *Qualifications:* Job Description: Candidate must - - Understand the current EDW which is designed and developed in KALIDO DIW. - Identify all the Source and Target systems to the EDW. - Identify all the transformation logic embedded in the Kalido DIW tool to build the EDW. - Create a process to migrate the current KALIDO DIW to new SQL Server Data marts based on subject areas. - Create a process flow mapping for the migration. - Sketch out the risks involved in the migration. - Create a best practice to implement KALIDO MDM for the Agent Master MDM which is being at Client. Skills and Experience - - Must have at least 6 to 7 years of overall experience in Data Warehousing and Data Modelling concepts. - Must be able to efficiently design database/warehouse using Kalido DIW 9.x. - Must have worked in at least 2 implementations of Kalido DIW 9.x and 1 implementation of Kalido MDM. - Should be expert on Kalido DIW specific objects like CBE, TDs, Query Definitions, Mapped BEs, Virtual Mapping Tables - Should be good in Kalido performance tuning and should have knowledge in Kalido BIM using version 1.3 or higher. - Knowledge in Kalido administration and Finance and Insurance domain is added advantage - Should be able to design and develop ETL Packages using Microsoft SSIS 2008 or in above version (2008 R2/2010/2012/2104). - Should be able to develop complex packages, complex SQLs and Stored Procedures, and deployments using Microsoft SQL Server 2008 or above. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
