This is an URGENT requirement and seek immediate joiners only

v Having 5 years of experience in development and implementation of MSBI (, SSAS), (SQL Server 2012/2014/2016/2017).

v Excellent T-SQL Developer skills including Stored Procedures,Views,User Defined Functions and Triggers.

v Good at writing Complex T-SQL queries Sub-queries and Joins Concepts.

v Good at writing Normalization, De-normalization, Query Optimization and performance tuning of stored procedures, functions.

v Good in SSMS AND BIDS Environment (SQL Server)

v Involved in creating SSIS Packages by using different data Transformations like Derived column, Lookup, Conditional Split, Multi-cast, Merge, Merge Join, OLEDB Command, Audit, SCD.

v Used Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task and Data Flow Task.

v Implementing Logging, checkpoint configuration, package configuration and Deployment.

v Experience in creating Jobs, Alerts, SQL Server Agent and Scheduled SSIS Packages.

v Knowledge in developing Table Reports, Sub Reports,Drill down,Drill through, Cascading Reports using SQL Server Reporting Services (SSRS).

v Designing and Deployment of Reports for the End-User requests using Web-Interface.

v Worked on Data Warehouse concepts like Star Schema, Snow Flake, Dimension & Fact Tables.

v Excellent communication and inter-personal skills and goal oriented.