· Expert knowledge of Microsoft Business Intelligence stack including SSIS, SSRS and SSAS/Power BI.
· Experience with SSIS ETL tools including building and optimizing big data pipelines and data sets
· Experience in the building end to end data warehouse and BI projects.
· Experience using CSV, XML, JSON, EDI, or other data schema formats
· Experience in the Azure Data Engineering environment using Databricks, Datalake, Delta Lake, Azure Storage, etc.
· Experience with Spark API and Python
· Ability to write efficient SQL statements and optimization.
Must have -
- MSBI (SSIS, SSRS, SSAS, Power BI)
- TSQL and DAX
- Azure SQL, ADF
Prefer to have