.Net Developer with SSIS

Job Title

Technical Skills / Knowledge Required:

• Minimum of eight years developing web applications in C#, ASP.NET using MVC architecture with at least one year using.NET Core.
• Minimum 8 years of advanced technical skills with creating and modifying SQL procedures, stored procedures, triggers, and database technologies using MS Sql Server.
• Experience in designing and developing SQL Server Integration Services (SSIS) ETL packages.
• Experience in designing and developing REST APIs.
• Experience in implementing enterprise application patterns using Object Oriented Programming.
• Knowledgeable in unit testing of software.
• Working with State government clients is a plus.
• Working with Medicaid and MMIS systems is a plus.
• .NET certification preferred.

Job Summary Essential Duties and Responsibilities:

• Lead the development of software solutions that will meet or exceed business requirements; the development effort includes designing and implementing modules to the system specifications, conducting unit testing, troubleshooting issues and producing detailed proposals to resolve issues.
• May evaluate new coding techniques, tools, modules, and implementation as appropriate.
• Consult on requirements elicitation and definition.
• Perform data analysis and data migration.
• Document data interfaces and data mappings; analyze and interpret data; and conduct data sourcing activities.
• Develop data mapping, data validation, data reports, and support existing applications using SQL Server programming such as stored procedures, functions, triggers, and writing complex queries.
• Produce efficient and optimized queries.
• Perform ETL (Extract, Transform and Load) using SQL Server Integration Services (SSIS) packages.
• Work with developers and supervisors to assure specifications are understood and followed.
• Work with existing systems developed using technologies like ASP.NET C# and use reverse engineering technique to extract business rules and validations.
• Document business rules and requirements, and design and execute Data Quality checks.
• Work with business users and other peers for testing, debugging, remediate defects and providing testing results documentation.

Minimum Requirements:

• Requires a minimum of 8 years of related experience with a Bachelor's degree; or 6 years and a Master's degree; or equivalent experience.
• Ability to perform complex tasks with minimal supervision and guidance.
• Good verbal and written communication skills.