• Experience in end-to-end DW Design, Development and implementation of at least 3 DW projects.
*Experience in handling complex integrations and provided stand-alone solutions using MSBI stack
• Hands on knowledge in SSIS, SSAS and SSRS using Tabular (Mandatory) and MDX
• SSRS - Reporting using parameters, Sub reports, Drill Down Reports, expressions and report development using Tabular modelling and MDX
• SSIS - Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems.
• SSAS - Working knowledge of SSAS using tabular (mandatory)
• MDS - Working knowledge of MDS
• Must Have - Extensive work on SSRS including reports using MDX queries.
• Good to Have - Knowledge on Report migration, Subscription, Data extract from SAP systems
• Ability to work closely with client to understand requirements and get it done from developers.
• Handle team of MSBI resources located at various geographies and review their work.
• Ability to take ownership of complete release and delivery.
Mandate to have good exposure on Tabular Modelling
Power BI & Sharepoint knowledge
Have worked on Security model implementation used in MSBI"