5 – 8 years hands on experience with SQL development with various database and data warehouses, especially 2 years with Azure environment.
Experience with writing SQL scripts using T-SQL, U-SQL constructs, development of schema, tables, stored procedures, views and functions.
Many years of experience with ETL using SSIS, Azure data factory. Experience developing, architecting, and deploying data warehouses with Microsoft SQL Server Advanced Design/develop data models to store and visualize the data Highly experience with developing SSAS/Azure Analysis Services (AAS) tabular models, performance tuning. (5 years).
Familiar with SQL user access, security and performance. Experience with SQL data base migration, upgrade projects.
Capable of troubleshooting issues, providing production support, optimizing the SQL.
Familiar with SSAS, AAS, JSON, XML, Azure data lake, Azure storage and SSRS.
Experience with SQL data base migration, upgrade projects.