Orchestration (SSIS) Developer

Role: Orchestration (SSIS) Developer



Employment: Full Time



Location: Toronto, ON



Work Arrangement: Onsite 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 solutions while collaborating with onshore and offshore teams

• Develop and maintain data solutions using MS SQL Server, SSIS, and related tools
• Design stored procedures, functions, data pipelines, and data processing workflows
• Develop VB.NET scripts and advanced data processing solutions
• Work with XML, CSV, fixed-length, and delimited data formats
• Build templates for data file preprocessing, parsing, and transformation
• Support GitLab, CI/CD, and artifact management processes
• Analyze complex business requirements and create technical specifications
• Estimate timelines, resources, and dependencies for SQL projects
• Perform code reviews, unit testing, integration testing, and debugging
• Support QA and troubleshoot end-to-end application flows
• Conduct root cause analysis and resolve production issues
• Collaborate with offshore teams and other technology teams
• Mentor junior developers and support technical standards and architecture
• Support banking document processing, statements, Canadian tax, and cheque processing solutions

• 5+ years of data development experience
• Advanced MS SQL Server, RDBMS, and SQL skills
• Strong Stored Procedures and Functions experience
• Hands-on DTS/SSIS experience
• Strong VB.NET scripting knowledge
• Experience with XML, CSV, fixed-length, and delimited data formats
• Knowledge of GitLab, CI/CD, and artifact management
• Strong data sorting, bundling, aggregation, and transformation skills
• Banking and financial domain experience preferred
• Strong analytical, problem-solving, and communication skills