Experience on SQL Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
Good experience on data analysis, multidimensional modeling, OLAP cubes and MDX queries
Should have good SQL Server development skills. Hands on in T-SQL, writing complex stored procedures and functions
Minimum 5+ years of strong experience in MSBI with SSIS, SSRS and SSAS.
SSIS: Managing and development of SSIS, transformation techniques.
SSRS: Report with MDX queries.
For the integration of SSRS with Sharepoint.
SSAS: OLAP, performance tuning, data mining, MDX query, designing, OLAP, backup, KPI designing.
Handson knowledge on TSQL, OLTP, stockCS, triggers
US work authorization is MUST