28 Aug
|
AceStack
|
Toronto
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 Key Responsibilities 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 Git
Lab, 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 Required Skills 5+ years of data development experience Advanced MS SQL Server, RDBMS, and SQL skills Solid 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 Git
Lab, 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
📌 Orchestration (SSIS) Developer (Toronto)
🏢 AceStack
📍 Toronto