Category : T-SQL (Transact Structures Query Language) From :Bangalore Profile Type : Individual Member Since : December 30, 2019
0 Likes24 Views
Over 8 years of IT experience in Database Design, Development, Implementation and Support using various Databasetechnologies(SQL Server 2008/2012, 2016 T - SQL, Azure Big Data) in both OLTP, OLAP and data warehousing environments
Expertise in SQL Server and T-SQL (DDL, DML and DCL) in constructing Tables, Joins, Indexedviews, Indexes, Complex Storedprocedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules
Strong technical knowledge in SQL Server BIsuite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools
Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
Experience managing Big Data platform deployed in Azure Cloud
Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
Experience in Monitoring and Tuning SQL Server Performance
Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools
Expert in creating, debugging, configuring, and deploying ETL packages designed MS SQL Server Integration Services (SSIS)
Experience in configuration of report server and report manager for job scheduling, giving permissions to different level of users in SQLServer Reporting Services (SSRS)
Experience in creating OLAP Data marts using SQL Server Analysis Server (SSAS)
Experience in developing cubes using Partitions, KPI?s, and Perspectives, slow moving dimensions.
Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Servicesusing multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
Responsible for creating Requirements Documentation for various projects
Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease
Experience in writing code in R for data loads, extracts, statistical analysis
Looking to Hire?
Find best service providers near you on Rockerstop.