Omni Inclusive - Reston, VA, US

.Net Developer with SSIS

Date Posted: 2024-05-28

Job description

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.

2024-07-06