MT - Database

Are you the one we are looking for?

We are inviting applications for the role of MT, SQL Developer

The SQL & business intelligence Developer is responsible for the aggregating data from multiple data Warehouses and database Management System (BDMS), and designing enterprise level-level solution using databases languages such as (SQL) and BI tools such as (Tableau or Power BI) etc. Addition responsibility includes

Responsibilities
• Writing T-SQL Queries using joins and Sub queries in MS SQL Server.
• T-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.
• Knowledge of SQL Server Analysis Services (SSAS Integration Services (SSIS) and Reporting Service (SSRS)
• 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

Qualifications we seek in you

Minimum qualifications
• B.Tech/MBA/MSc/MCA
• Must have knowledge on SQL Azure cloud and data factory

Preferred qualifications
• ETL experience in Alteryx/SSIS