Orchestration (SSIS) Developer-6

Role: Orchestration (SSIS) Developer

Employment: Full Time

Location: Toronto, ON

Work Arrangement: Onsite

Job Type Full Time

Job Category IT

Job Description We are seeking a Full Time Orchestration (SSIS) Developer with strong experience in MS SQL Server, SSIS, data development, data pipelines, and banking document processing. The ideal candidate will design, develop, test, integrate, and support complex data processing solutions while collaborating with offshore and cross-functional teams

Key Responsibilities Develop and maintain data pipelines using MS SQL Server, SSIS, and related tools

Design and optimize stored procedures, functions, and complex SQL queries

Develop data processing solutions using DTS/SSIS and VB.NET scripting

Work with XML, CSV, fixed-length, and delimited data formats

Design templates for data file preprocessing, parsing, transformation, and aggregation

Analyze complex business requirements and create technical specifications

Support banking document data processing including statements, Canadian taxes, and cheque processing

Perform unit testing, integration testing, QA support, debugging, and root cause analysis

Review code changes and ensure adherence to development standards

Work with GitLab, CI/CD, and related DevOps tools

Coordinate with offshore teams and resolve technical issues

Provide accurate estimates for project timelines, resources, and dependencies

Mentor junior developers and trainees

Assist with solution architecture, standards, and end-to-end workflow integration

Required Skills 5+ years of data development experience

Advanced MS SQL Server, RDBMS, and SQL expertise

Strong Stored Procedures and Functions experience

Hands-on SSIS/DTS experience

Strong VB.NET scripting knowledge

Experience with XML, CSV, fixed-length, and delimited data

Knowledge of GitLab and CI/CD

Strong analytical and problem-solving skills

Experience with banking statements, Canadian taxes, and cheque processing

Strong communication and team collaboration skills

#J-18808-Ljbffr