|Reference #||19-00467||Title||Data Warehouse Consultant|
|Start Date / End Date||29-07-2019 --- 29-01-2020|
Role and Responsibilities:
" Should work with multiple business groups to gather business requirements on analytics.
" Should work with DBA's and data architects to select correct data sources, follow established data integration standards and develop enterprise class data models, data transformation, data integration, and data warehouse/datamart solutions.
" Should develop accurate documentations on solution architecture and components.
" Should be able to provide production support on weekdays and occasionally on weekends.
Qualifications and Education Requirements
" Bachelor's Degree preferred.
Required Skills & Experience:
" Ability to interpret, analyze and implement business analytics requirements accurately.
" Advanced data modeling in data warehouse and datamarts.
" Advanced SQL skills, and ability to design and develop physical data model, optimal data structures, and data procedures on Microsoft SQL Server.
" Should independently work on tasks like database backup/restore, database security, and SQL Jobs setup.
" Must have strong background on data transformation and integration routines using Microsoft SSIS, and Stored Procedures.
" Ability to develop, maintain and administer reports on Microsoft SSRS
" Ability to troubleshoot and resolve issues on data integration, data warehouse/datamart and
" Python programming experience
" General understanding on web tier concepts like http/https, query string, and REST API.
" Certifications on Microsoft SQL Data warehouse