Send me more jobs like this

Keywords / Skills : SSIS

6 - 8 years
Posted: 2019-07-21

Industry
ITES/BPO
Function
IT
Role
S/W Installation/ Maintenance Engg
Posted On
21st Jul 2019
Job Ref code
123197
Job Description
Job Description :

Job Description:
 Professional with around 6 + years of total IT experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2005/2008/2012.
 Expertise in writing T-SQL Queries, Dynamic queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
 Experience in Microsoft Visual C# in script component of SSIS.
 Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
 Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
 Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
 Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
 Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
 Experience in creating configuration files to deploy the SSIS packages across all environments.
 Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
 Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
 Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
 Good ability to quickly grasp and master new concepts and technologies
Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you