Data Warehousing in Columbus, Ohio For Sale

Salary period: Annual
Job Title: Senior DW Consultant
Duration: 6+months
Location:Cincinnati, OH, US
Max Hourly Rate: USD $60 on w2
Qualifications:
**Need locals with in-person interview available.
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 xxxx or in above version (xxxx R2/xxxx/xxxx/xxxx).
- Should be able to develop complex packages, complex SQLs and Stored Procedures, and deployments using Microsoft SQL Server xxxx or above.
Thanks
Mike Stempler
Comtech Global Inc
Certified MBE Firm
P: ext xxxx
Direct:
F:
E:
U: