- 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.