Software Developer
Location : Bengaluru, India, India,
Experience : 4.1 Year
Rate: $11 / Hourly
Availability : 2 Week
Work From : Any
Category : Information Technology & Services
Professional summary:
MSBI Developer with 4.1+ years of experience in information Technology, with specializing in Database Design, Programming, Development using MSSQL, T-SQL (DDL and DML), SSIS.
Experience in Software Development of analysing problems, developing and simplifying procedures and finding innovative solutions.
Experience with SQL Server and T-SQL in constructing Triggers, Tables, User Functions, Views, Indexes, CTE, Relational database models, Performance tuning.
Experience in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
Experienced in creating and using Stored Procedures, Views, Synonyms and User Defined Functions.
Created basic reports using SSRS based on client requirements.
Involved in creating Sub-Queries, correlated sub queries and joins for complex queries involving multiple tables.
Strong Knowledge in SQL Commands like Data Definition language (DDL), Data Manipulation language (DML), Data Query language (DQL), Data Control language (DCL), Transaction control language (TCL).
Good experience in using Temp Table, Table Variable and Common Table Expression.
Involved in creating Indexes, Indexed Views and creating effective Functions and appropriate to assist efficient data manipulation and data consistency.
Experience with SQL Server and T-SQL in constructing Triggers, Tables, User Functions, Views, Indexes, CTE, Relational database models.
Well experience in Data Extraction, Transforming and Loading (ETL) using tool SQL Server Integration Services (SSIS) and Various Transformations like ‘Merge, Merge join, Union all, derived column, Lookup, Conditional split.
Good Experience in using containers like for each loop container and for loop Container and Sequence Containers to read multiple source files.
Expert in using Execute SQL Task, Execute Package Task, File System Task and Send Email Task.
Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Excel, CSV, Flat files using connectors, tasks and transformations provided by SSIS.
Expert in deploying the SSIS package into SSISDB and scheduling through SQL Server Agent.
Good exposure into Logging, Check points, Breakpoints, and data viewers in SSIS.