Programmer/Developer-FSDETLOHS2 - Smart IMS. Inc

We are seeking a highly motivated and skilled Full-Stack Developer to join our team and play a crucial role in developing a data submission ETL portal. This portal will serve as a central hub for collecting, transforming, and loading data from various sources into our data warehouse.

Hybrid Position - Hartford. Minimum one day per week onsite- no exceptions. Preferred shift is 7:30-4:00. Must follow State holiday schedule.
Responsibilities:
• Develop, and implement the data submission ETL portal using .NET technologies (e.g., C#, ASP.NET MVC, ASP.NET Core)
• Develop RESTful APIs for data submission and retrieval.
• Integrate with various data sources using appropriate technologies (e.g., APIs, file uploads, data pipelines)
• Design and implement data transformation logic using SQL (e.g., stored procedures, triggers)
• Build user interfaces for data submission, tracking, and reporting using modern web technologies (e.g., HTML, CSS, JavaScript)
• Implement robust error handling and logging mechanisms.
• Write unit and integration tests to ensure code quality and functionality.
• Deploy and maintain the application in a production environment.
• Collaborate closely with data analysts, business stakeholders, and other developers.
Requirements:
• Minimum of 5 years of experience as a Full-Stack Developer
• (SSRS) SQL Server Reporting Services experience necessary.
• Strong proficiency in C#, ASP.NET MVC/Core, and SQL
• Experience with data integration and ETL processes
• Experience with building RESTful APIs
• Strong understanding of web development principles (HTML, CSS, JavaScript)
• Experience with unit testing and test-driven development (TDD)
• Experience with continuous integration and continuous delivery (CI/CD) pipelines
• Ability to work independently and as part of a team
• Problem-solving and critical thinking skills
• Experience with QA methodologies
Preferred:
• (SSIS) SQL Server Integration Services
• (SSAS) SQL Server Analysis Services