Data Warehouse Lead

Job title: Data Warehouse -DW Engineer

Location: Detroit MI

Duration: 12 months

Job Description

Knowledge in Azure and ADF configuration.
Microsoft SQL server Data Ware house modelling with Very good knowledge in SSIS packages, Stored procedures and SQL
Design, develop, and validate logical data model based on the business metrics and dimensional attributes
Create physical tables based on logical data model design in chosen database
Design, develop, and unit test the data ingestion and transformation jobs for processing the data and loading into the data mart
Design, develop, and unit test data quality jobs for data cleansing
Design, develop, and unit test scheduling jobs to execute the data loading & transformation jobs on agreed frequency
Design system integration test plan, prepare test data for SIT, write test cases, and execute SIT test case plan.

Thanks & Regards

Dinesh Kumar

Giga Giglet – Tech Jobs & Career Updates in the U.S.