Intermediate Fullstack Developer (ETL and Web) with SSIS and Node/React experience to work with a major retail client- 30141

Intermediate Fullstack Developer (ETL and Web) with SSIS and Node/React experience to work with a major retail client- 30141

Location: Mississauga - 5 days on site (May be possibility of Hybrid 2-3 Days)

Duration: Until Jan 31, 2026

Hours: 37.5 Hours Per Week

We are seeking a highly motivated and skilled Fullstack Developer for an immediate contract opening. This role offers a unique opportunity to leverage your expertise across data integration and modern web development, contributing to diverse projects and collaborating with multiple teams.

Role Overview:

• The successful candidate will be primarily focused on ETL development (80%) using SSIS and Microsoft SQL Server, with a significant web development component (20%) utilizing React and Node.js. This hands-on role will involve the creation and support of robust ETL processes and web-based applications, alongside active participation in solution design, team recommendations, continuous improvement initiatives, and comprehensive documentation.
• We are looking for an engaged individual with strong communication skills who is proactive in contributing ideas and insights to the team.

Key Responsibilities:

• Design, develop, test, and maintain ETL processes using SSIS (Visual Studio 2019) to extract, transform, and load data from various sources into target systems.
• Write and optimize complex SQL queries and stored procedures for data manipulation and reporting in MS-SQL.
• Develop and maintain web-based applications using React (v18) for the frontend and Node.js (v18) with the Express framework for the backend.
• Provide technical expertise and recommendations for solution design and system architecture.
• Assist in troubleshooting and resolving issues related to ETL pipelines and web applications.
• Champion code quality, best practices, and continuous integration/delivery methodologies.
• Contribute to technical documentation, including design specifications, data flow diagrams, and user guides.
• Collaborate effectively with cross-functional teams and stakeholders.
• Actively participate in problem-solving, decision-making, and fostering a culture of innovation.

Required Skills & Experience:

• 3-5 years of ETL & Database in the following:
• Microsoft SQL Server Integration Services (SSIS):
• Proficiency with VS 2022.
• Ability to develop and debug complex SSIS packages.
• Basic C# scripting skills for SSIS components.
• SQL: Strong ability to develop, optimize, and troubleshoot SQL queries, Expertise in creating and managing stored procedures.
• 3-5 years of Web Development in the following:
• Node.js: Experience with Node.js v20, Proficiency in using the Express framework for backend development.
• React: Experience with React v18, Strong understanding and application of React Hooks, ExpressJS and NestJS