Individual with strong technical background in SQL Server, BI, Data Analysis and strong knowledge of Data Warehousing Concepts.
- Should be able write complex and efficient -SQL queries.
- Should be able design & Implement end-end data pipelines using cosmos and ADF.
- Problem analysis and troubleshooting complex & “large volume of dataset’s” data issues.
Skills Required:
- Proven experience in SQL Server writing complex T-SQL queries, Performance tuning.
- Proven experience in Data Analysis dealing with large volume of datasets.
- Proven experience in Design & Implementation of end-end data pipelines.
- Should have strong knowledge of Data Warehousing concepts.
- Should have very good experience in BI tools (but not limited to)
- ETL tools like SSIS
- Reporting tools like Power BI,
- Analytical tools like SSAS – Tabular and multi-Dimensional Cubes and MDX queries.
- Cosmos and scope scripts
- Good to have knowledge of Microsoft Big Data Technologies.
- Good to have knowledge of Azure Data Factory and C#
- Excellent communication skills – direct communication with Client