MS SQL Developer

 

Job description



 



Required Skills: Microsoft SQL server and SSIS



 

> Must Have 3+  years of experience in database development using SQL Server stack 2012 or above.
- Core experience to build complex SQL Queries and implement indexing in MS SQL Database to perform computing on large scale Databases.
- Creation of complex stored procedures involving CTEs, explicit transactions, shredding and creation of XML and exception handling
- Excellent understanding of T-SQL programming and XML shredding.
- Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
- Strong Datawarehouse and ETL Experience. Able to deal with heterogeneous data sources/destinations (Like different RDBS systems, Flat files, spread sheets) to extract/load data.
- Strong understanding of Kimball Data warehousing and Data Modelling concepts
- Experience in Data Base as an analysis, developing procedure, trigger and Function for large scale of Business Applications.
- Ability to Understand larges data structures and using BIML for creation of SISS packages.
- Good Experience in SQL Query performance tuning for large datasets.
- Analytic mindset and good problem-solving skills.
- Excellent verbal and written communication skills.