Job ID: MI-88886 (99190713)10A
SSIS/.NET Developer with SSDT, SSMS, data cleansing/scrubbing, DW, data mart, Sybase ODBC, Azure DevOps, C#, SQL, TSQL experience
Location: Lansing MI (DTMB DOC)
Duration: 24-60 months
Postions: 1 (1/1)
Remote or On-site? Hybrid work schedule, resource will have to be onsite.
SSIS/.NET Developer
• 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.
Top Skills & Years of Experience:
• 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.
Additional Info:
The Department of Corrections has been replacing critical legacy applications for the past couple years. DOC partnered with a vendor that specializes in SaaS solutions. DOC is happy with the vendor and the progress, but the SOMI still has a lot of work associated with this migration. The internal staff needs assistance, so the SOMI is looking to hire someone for a long-term contract. This person will be looking at the data, running queries and staging migration data in a SQL Server environment so the SaaS vendor can access the data. This is a great opportunity for someone that likes cleaning up data, testing the data, has some .NET skills and is willing to possibly make coding changes to resize images as one example.
MI_E-RTR (2)