Should have a total Experience of 5+ years.
SQL Server Analysis Services (SSAS)
Extensive hands-on experience on designing, building and optimizing large scale SSAS databases
Strong relational/dimensional data modelling skills
Strong multi-dimensional expression (MDX) language skills.
Worked on at-least 2 Data Warehousing projects.
SQL Server Integration Services (SSIS)
Proficient in implementing all transformations available on the SSIS toolbox.
Excellent knowledge of using variables and expressions in packages.
Experienced in creating master and child packages, package configurations and logging.
Experienced in SSIS package Auditing.
Experienced in SSIS package deployment and Scheduling
Working experience on Master Data Serveries (MDS) and Data Quality Services (DQS)
SQL Server Reporting Services (SSRS)
Experience of creation and implementation of canned reports in SSRS.