P

·        Having 3.1 years of experience in Microsoft technologies such as MS SQL Server and Microsoft Business Intelligence tools SSIS Developer.

·        Extensive experience with SQL Server in constructing Tables and maintaining theproper data types and creating Identity, Constraints on a table.

·        Strong Experience in writing complex SQL queries using Joinsand SET Operators like UNION & UNION ALL to retrieve data from the table. 

·        Strong Experience in writing  SQL queries using System Functions, Sub queries and CTE’s to retrieve data from the database. 

·        Extensive experience with SQL Server and T-SQL in constructing StoredProcedures, User Defined Functions and Views & Triggers.

·        Strong experience in creating Temp Tables, Table Variables.

·        Good Knowledge in creating Indexes on tables.

·        Good at installing SQL Server installations.

·        Knowledge to create database Backup and Restore.

·        Analyze the source and creating packages to move the data from source to destination.

·        Creating packages for implementing ETL by using various control flow items like Data Flow Task, Foreach Loop Container, Execute SQL Task, Send Mail Task and File System Task etc. And Data Flow transformations like conditional split, Multicast, Derived column, Lookup, Sort, Union All, Merge, Row Count Etc.

·        Having Knowledge on Package debugging using check points and break points.

·        Generate package configuration, preparing unit test cases and generating the scripts for ETL and SQL for the QA/UAT/PROD development.