.Net Developer with SSIS

echnical 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 Bachelors degree; or 6 years and a Masters degree; or equivalent experience.
• Ability to perform complex tasks with minimal supervision and guidance.

Good verbal and written communication skills.