Job description
Location- Bangalore
Experience: 4-7 years
Notice Period- Immediate joiners required ( 15 Days)
Qualification: Graduate
CTC: 10-11 LPA
WFM/Onsite/Hybrid : Onsite
Job Requirements:
Mandatory
- MS SQL server (Tables, views, stored procedures,functions, triggers, cursors, SQL agent)
- SSIS
- SSRS
- SSAS (Multi dimensional & Tabular)
- Power BI (DAX, data modelling, using OLAP cubes,datasets)
Good to have
- Advanced Excel
- Power query & automate
Description:
- Experience in the Microsoft suite of tools (SSIS, SSAS, SSRS, MS SQL Server,Power BI) is a must.
- Manage SQL Server databases through multiple product lifecycle environments,from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance,availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Expert in Building Power BI dashboards and doing adhoc reporting Experience in DAX and Building Tabular reporting is must Responsibilities
- Hands on Power BI development experience with high end visualization and experience on advanced visualization tool.
- Must be experienced in designing, architecting, development and deployment using Power BI.
- Must be well experienced in development of Power BI reports, dashboards,building semantic data models for adhoc reports, Custom visual generation using Microsoft.
- Should be well versed with all BI and DWH concepts and architecture.
- Should have worked on SSIS Package creation, SSIS package deployment, error handling in ssis package, Package configuration, ssis Package logging and job creation in SQL Server.
- Professional business intelligence development experience using Power BI,Power BI Embedded.
- Design and Architect compelling Power BI data visualizations.
- Develop concepts of reports, analytics and visualizations development, using DAX, SQL, tuning, data models and semantic models.
- Communicate effectively with both business, technical stakeholders as well as leadership