Orchestration (SSIS) Developer-6

REALIGN LLC

Toronto

On-site

CAD 90,000 - 120,000

Full time

43 hours ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

REALIGN LLC in Toronto, ON is seeking a full-time Orchestration (SSIS) Developer with strong MS SQL Server, SSIS, data development and banking document processing experience. You will design, develop, test, and support complex data pipelines, work with offshore teams, mentor juniors, and contribute to end-to-end workflow integration using GitLab and CI/CD.

The role emphasizes on-site work and collaboration with cross-functional teams to deliver reliable data processing solutions for banking

Qualifications

5+ years of data development experience.
Strong MS SQL Server and SQL expertise.
Hands-on SSIS/DTS experience.
Experience with banking statements, Canadian taxes, and cheque processing.
Ability to coordinate with offshore teams and mentor juniors.

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.

Skills

Data development

MS SQL Server

SQL expertise

Stored Procedures

SSIS/DTS

VB.NET scripting

XML/CSV formats

GitLab & CI/CD

Banking data processing

Communication & teamwork

Tools

GitLab

CI/CD

Job description

Role: Orchestration (SSIS) Developer
Employment: Full Time
Location: Toronto, ON
Work Arrangement: Onsite

Job Type

Full Time

Job Category

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