SQL Server Analysis Services (SSAS) Jobs in Bangalore (Bengaluru)

The MSBI Developer provides solutions using the most appropriate Microsoft and SQL BI feature and should have a solid understanding of the architecture, features available and limitations of various SQL BI solutions. He/ She will also be playing DBA role and responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.   Responsibilities: Work with a SQL Server\Microsoft stack-based Business Intelligence System Develop SSIS ETL packages based on business requirements Develop Business Intelligence solutions using Multidimensional and Tabular Cube technologies Assist in DBA responsibilities, backups, performance tuning, troubleshooting Identifying opportunities for Automation and implement them through required approval Complex query tuning and schema refinement. Responsible for reviewing requirements, contributing to design components of ongoing and upcoming projects, and effectively estimating development effort Responsible for developing and documenting the systems, processes and logic required to build system to system integrations Responsible for contributing to data modelling/database design efforts Responsible for delivering quality data integration projects Responsible for hands on development using SSIS and ETL tools and processes Lead and recommend viable solution for Azure implementation methodology (as required) Stay up-to-date on techniques and components being used in the industry through research and applies this knowledge to systems being developed Pro-actively identifying changes needed in the environment lifecycle and make recommendations for improvements with the subsequent implementation Monitor ETL applications for performance and improvement opportunities Ensure the quality, consistency and security of company data and data warehouse systems   Requirements: 4 - 7 years SQL Server Development experience required (SQL Server 2014 onwards) Deep understanding of SQL Server Integration Services Knowledge of optimisation techniques for both SSIS and SQL Familiar with Data Warehouse concepts and experience with Star Schema a plus Knowledge of data modelling and designing databases XML, JSON, PowerShell, Rest API experience Good knowledge in Azure implementation Good knowledge in Dashboarding through Power BI or any other equivalent tools. Good knowledge of metadata, and using/managing metadata Experience with SQL Server Analysis services, Tabular and Multidimensional Experience with Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models. Experience with Redgate Backup tools a plus Excellent written and verbal communication Flexible, team player, get-it-done personality Ability to organise and plan work independently Ability to work within an Agile and ITIL framework Ability to multi-task and context-switch effectively between different activities Microsoft certifications a plus Experience with API based integrations a plus (we use various cloud applications as data sources)

Exciting opportunity for any contractor to work with a start-up firm which is into product cum service based industry. We are looking for someone who has got rich experience in below mentioned skills to join us immediately.This role is for 1 month where the person will be working from Client site in Paris to understand the system architecture and documenting them. Contract extension for this role will be purely on the performance of individual. Since the requirement is immediate and critical, we need someone who can join us soon and travel to Paris in December- Hands on experience handling multiple data sources/datasets- experience in data/BI architect role- Expert on SSIS, SSRS, SSAS- Should have knowledge writing MDX queries- Technical document preparation- Should have excellent communication- Process oriented- Strong project management- Should be able to think Out of the Box and provide ideas to have better solutions- Outstanding team player with positive attitude