Tagcor

Required Skills

.Net Developer

Work Authorization

Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit

Preferred Employment

Corp-Corp

Employment Type

Consulting/Contract

education qualification

UG :- - Not Required
PG :- - Not Required

Other Information

No of position :- ( 1 )
Post :- 9th Jul 2021

JOB DETAIL

Experience with and deep knowledge of Visual Studio 2012 and later, SQL Server

Integrations Services (SSIS), SQL Server Data Tools (SSDT), and SQL Server Management

Studio (SSMS).

 Experience with performance profiling and optimization of SSIS, SQL Server queries,

stored procedures, triggers, and functions.

 Perform data cleansing/scrubbing and transformation of data to ensure data quality.

 Develop SSIS packages to extract, transform and load data to enterprise-level data

warehouses and data mart databases.

 Use various containers, tasks, transformations, connection managers, script task to

develop SSIS packages.

 Gather requirements working with business analyst, developers, database architect and

business users.

 Developed complex and extended stored procedures and user defined functions in SQL

Server.

 Optimize existing SSIS packages with options like delay validations, buffer sizes, parallel

processing and maximum concurrent executions etc.

 Experience deploying SSIS packages into various environments (development, test, and

production).

 Experience with the import and export of data between various sources and destinations

using SSIS, BCP and Bulk Insert.

 Experience with Sybase ODBC connectivity, queries, stored procedures, and triggers

desired but not required.

 Experience with all areas of .NET development including server-side, client-side, data

retrieval, and management.

 Good communication skills.

 Analytical and problem-solving skills.

 Develop technical changes / enhancements based on specifications provided.

 Research, test, and recommend how to properly adopt new technologies.

 Ensure that all development projects adhere to strict development guidelines including

testing, acceptance and rollout by implementing change management controls.

 Design conceptual, logical, and physical databases for use with SSIS.

 Participated in designing and implementing logical data models for data warehouse.

 Experience with Azure DevOps desired.

 Bachelor of Science degree in Computer Science preferred. A comparable degree and/or

experience is acceptable.

 Minimum three years of development using .NET (C# and SQL), Microsoft SQL Server,

TSQL, SSIS, Stored Procedures, database functions required.