- Create multidimensional analysis solutions with SQL Server Analysis Services Strong analytical skills to analyze the huge volume of CUBE / Data warehouse Design, Develop, Implement and Maintain SQL Server 2008/2012/2014 database objects and services.
- Experience in Analytics / OLAP Cube Development (Microsoft SSAS and MDX). Analyze, design, build, query, troubleshoot and maintain cubes. knowledge/expertise in SSAS Tabular with DAX language, Proficient in MDX and DAX .
- Strong Expertise in SSAS Multidimensional Cube Development with MDX language, strong expertise with SQL. (Stored procedures, views, debugging).
- Experience in Cube Deployment and Processing the OLAP Cubes .
- Think innovatively to provide solutions for the complex issues. Experience in handling multiple CUBEs with the data .
- Connect, import, shape, and transform data for business intelligence (BI).Strong Expertise in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS as ETL tool on SQL Server/Oracle Databases.
- Knowledge to integrate SSAS with Power BI and developing reports.
- Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements .
- Will be expected to mentor colleagues and be proactive in developing colleague skill sets to have a better understanding of Analysis Services.
- Maintain documentation for all processes implemented .
- Adhere to and suggest improvements to coding standards, best practices, and contribute to the improvement of these best practices .
Education: Graduates/ Post Graduates (MCA/BCA/BE Computer Science/BE IT)
Experience: 6 to 8 Yrs.
