DontApply.Club
Login Register

SQL Developer (SSIS/Orchestration)

Tekshapers Inc — Canada · Posted ~8 hours ago

Senior Full-time

Skills

MS SQL Server SSIS DTS VB.NET Stored Procedures Functions RDBMS SQL Data Formats (XML, CSV, Fixed-length) GitLab CI/CD Banking Domain Knowledge Canadian Taxes Cheque Processing XML CSV

🔓 Log in to save this job, tailor your resume & track your apply process — 7 days free, no card needed.

Log in to add to target list

Summary ✨ AI‑Generated

We are looking for an experienced SQL Developer with deep expertise in MS SQL Server and SSIS to build and maintain data orchestration pipelines for a leading financial institution. You will work with complex data formats, stored procedures, and VB.NET scripting, ensuring accurate processing of banking documents including Canadian tax statements and cheque processing. The role requires strong analytical skills and the ability to estimate project timelines in a collaborative team environment in Toronto.

Highlights

Full-time position in Toronto, working with MS SQL Server and SSIS for banking and financial data processing, 5+ years experience required, exposure to Canadian taxes and cheque processing, modern CI/CD with GitLab, opportunity to work on critical financial data pipelines.

Description

Orchestration (SSIS) Developer Full Time Toronto, ON "Skills and Responsibilities: • At least 5 years of experience in data development andor relevant tools • Expertise in MS SQL Server and its tools Advanced level knowledge on RDBMS and SQL. Proficient with Stored Procedures, Functions. • Hands-on knowledge on DTS or SSIS. • I worked on VB.NET scripting and have good knowledge on advanced concepts. • Proficient with various data formats (XML, csv, fixed-length record, delimited) Working knowledge of GitLab, CICD and antifactory • Understanding of Sorting, bundling and data aggregation Ability to provide accurate time, resource, and dependency estimates for MS SQL projects based on the business requirements. • Knowledge of Banking document development lifecycle (data processing) • Strong analytical, problem-solving and communication skills Banking and Financial Domain knowledge (Statements, Canadian Taxes, Cheque Processing) • Ability to work individually with other teams integrating the components into the workflow. Work with offshore counterpart and team and resolve any issues • Analyzing highly complex business requirements generate technical specifications to create data pipelines for applications Create templates for data file pre-processing, parsing and transforming. • The best leverage industry and client practices to design, test, implement and support solution Review code changes for applications Perform unit testing of the application Support integration testing and quality assurance Debug end to end application flow for any errors and perform causal analysis. • Mentor less experienced developers Trainees Have Daily sync-up call with offshore team and resolving any issues and supporting them Assist with creating standards and architecting new client solutions Work with other teams in integrating the components and running end to end flow