SSIS Data Orchestration Engineer

Tata Consultancy Services; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

Tata Consultancy Services Canada Inc. is seeking a skilled data developer to join our team in Canada. The role focuses on building and maintaining data pipelines, with strong emphasis on MS SQL Server, SSIS, and data formats such as XML and CSV.

Collaboration with cross-functional teams and mentoring teammates will be part of the job. Knowledge of banking/financial data processing is beneficial. You will work across on-site teams to deliver reliable data solutions and support the end-to-end data

Qualifications

• At least good years of experience in data development and/or relevant tools.
• Expertise in MS SQL Server and its tools; advanced SQL, stored procedures and functions.
• Hands-on knowledge of DTS or SSIS.

Responsibilities

• Design, test, implement and support data pipelines for applications.
• Review code changes and perform unit testing; support integration testing.
• Mentor junior developers and coordinate with offshore teams.

Skills

Data development

Analytical thinking

Communication

Banking/financial domain knowledge

Tools

MS SQL Server

SQL - Stored Procedures/Functions

SSIS

VB.NET

XML/CSV parsing

GitLab CI/CD

Job description

Tata Consultancy Services Canada Inc. is seeking a skilled data developer to join our team in Canada. The role focuses on building and maintaining data pipelines, with strong emphasis on MS SQL Server, SSIS, and data formats such as XML and CSV.

Collaboration with cross-functional teams and mentoring teammates will be part of the job. Knowledge of banking/financial data processing is beneficial. You will work across on-site teams to deliver reliable data solutions and support the end-to-end data