Contractor
Posted 26 days ago
Job description
- 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.
- 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.
Most Popular Jobs Similar to Sql Ssis Developer
sql ssrs ssis developer
ssis developer
sql ssrs developer
ssis etl developer
sql developer
ms sql developer
sql application developer
sql server developer
t sql developer
sql engineer
Other Helpful Pages Related To .Net Developer with SSIS
Wpf Developer Salaries
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL SSIS Developer?
A: To succeed as a SQL SSIS Developer, key technical skills include proficiency in SQL Server, SSIS (SQL Server Integration Services), and data modeling, as well as experience with data warehousing, ETL (Extract, Transform, Load) processes, and data quality management. Soft skills such as strong problem-solving abilities, effective communication, and collaboration with cross-functional teams are also crucial, as they enable developers to troubleshoot complex data issues and convey technical insights to stakeholders. By combining these technical and soft skills, SQL SSIS Developers can design, implement, and maintain efficient data integration solutions that drive business value and support data-driven decision-making.
Q: What is the career path for a SQL SSIS Developer?
A: A SQL SSIS Developer's career path typically begins as a Junior Developer, where they focus on designing, implementing, and maintaining ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). As they gain experience, they progress to a Mid-Level Developer role, taking on more complex projects, mentoring junior team members, and contributing to the development of SSIS best practices. Ultimately, Senior Developers lead teams, architect large-scale SSIS solutions, and drive innovation in data integration and analytics, with opportunities to transition into leadership, data architecture, or business intelligence roles.
