Very strong on database concepts, data modelling, stored procedures, complex query writing, performance optimization of SQL queries.
Strong experience in T-SQL, SSIS, SSAS, SSRS
◦ Azure Data Factory
◦ Azure Data Lake Store
◦ Azure Data Lake Analytics (Good to have, not mandatory)
◦ Azure SQL DB
◦ Azure SQL DW
◦ Azure Analysis Services, DAX
◦ Azure Data Bricks with Python/Scala
Experience in building end to end solution using Azure data analytics platform.
Experience in building generic framework solution which can be reused for upcoming similar use cases.
Experience in building Azure data analytics solutions with DevOps (CI/CD) approach.
Experience in using TFS, Azure Repos.
Mentor peers to gain expertise on Azure data platform solutions skills.
Experience in developing, maintaining, publishing, and supporting dashboards using Power BI.
Strong experience in publishing dashboards to Power BI service, using Power BI gateways, Power BI Report Server & Power BI Embedded