Location: Chennai
- 3 + years of experience on BI technologies such as Power BI, MSBI (SSIS, SSRS, SSAS) SQL server, SQL queries – DDL & DML
- Should be familiar with end to end setup for an On-Premise and Cloud deployment of Power BI
- Understanding of the infrastructure requirements of setting up Power BI from scratch
- Hands-on dashboard design on Power BI desktop, must have done report creation using virtualization on Power BI.
- Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop
- Excellent experience in generating reports using SSRS.
- Experience in designing and developing various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS packages
- Must have excellent experience in MS SQL Server – writing queries, joints, stored procedure, functions etc
- Should have experience in writing MDX queries, Cube Development.
- Should have experience in writing DAX.
- Should have experience in Scope Scripting Language and Microsoft Cosmos
- Should have worked in creating complicated calculated measures.
- Should have understanding on TSQL, Data Warehouse concepts.
- Should possess good verbal & written communication