Description
Develop, monitor and deploy SSIS packages store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.• Create Tabular Models using DAX queries in SQL Server Analysis Services(SSAS) and deployed it.
• Involve in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS
• Use Visual Studio Online (VSO) and TFS for code check-in, creating, updating tasks etc.
• Develop and maintain multiple Power BI dashboards/reports and content packs.
• Responsible for building, Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Create complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views.
• SQL joins and define roles and privileges to implement business rules and control access to database.
• Create Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Write standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Use Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Experience with Master data management principal.
• Experience with Data Vault Architecture.
• Experience with Enterprise Data warehousing model.