Greetings of the Day...!!
We have an excellent requirement for you. Please go through the job description and let me know your level of interest in this position. Feel free to mail me at ************* or Feel free to reach me at (Kris)
Job Title: .Net Developer with SSIS
Location: Lansing, MI
Duration: 24+ Months
Onsite: Hybrid work schedule, resource will have to be onsite.
Pay Rate: $65/hr. on C2C or $60/hr. on 1099
Job Description:
- 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.