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
Solid 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

📌 Orchestration (SSIS) Developer-6 (Ontario)
🏢 Realign
📍 Ontario