MSBI - Lead

Technical & Behavioral Competencies

• Have minimum of 8 years of strong experience in Microsoft Technology (Microsoft Business Intelligence) MSBI like SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022
• In-depth Technical Knowledge on Microsoft Business Intelligence (MSBI) Tools like SQL Server 2005/2008/2012 Integration Services and Reporting Services
• Should have Knowledge on creating Package Configuration, Logging, and Error Handling for the SSIS Packages.
• Having knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• Experience in Deployment of ETL Packages in different environments and worked for preparing the deployment documentation for the DBA team.
• Experience in creating relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and (Multidimensional) MDX queries.
• Experience in extracting the data using SSIS from OLTP to OLAP.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and restore Database backup.
• Experience in creating like Drill-Down, Drill-Through, Sub Reports, Parameterized reports and subscriptions in SSRS. Configuring the Report security in the Report configuration manager
• Should have at least 3 years of excellent hands on experience on SailPoint, in design and developing functionalities like Lifecycle Management, Multiplexed and Direct Reconciliation, Workflow Management & Compliance Management
• Knowledge on Power BI, SAP BO Reporting & Tableau will be an added advantagePreferred to have