Description
Writing SQL Queries using joins and Sub queries in MS SQL Server.
SQL development skills to write complex queries involving multiple tables, Joins.
Experience in Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.
Creating & Modifying of tables, fields, constraints in MS SQL Server
Creating / modifying stored procedures in MS SQL Server.
Scheduling / modifying Jobs to automate in MS SQL Server.
Good / Basic knowledge on handling MS Access Database.
Developer with experience on developing reports/dashboards on Microsoft Power BI/Tableau
Extensive experience in writing DAX formulae, data formatting on Power BI desktop
Experience in creating PowerApps and Power Automate to integrate it with Power BI and SharePoint.
Ability to define a data model, create and customize simple visualizations, hierarchies and drill-down
Ability to create and deploy reports/dashboards on Power BI service/Tableau portal, Power BI gateways & Data refresh schedules
Knowledge of Power BI License model. want to switch to data engineering can also apply
.png)