Role 1: Lead BI Data Warehouse -Top Priority
Location: Detroit MI
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
Comments
Post a Comment
Thanks