ETL Lead

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

Job summary

Tata Consultancy Services Limited in Canada is seeking a senior data warehouse engineer to lead and mentor a team, manage end-to-end data warehouse systems and drive ETL processes. The role requires knowledge of bank/financial domain, AWS cloud services, and MS SQL/SSIS, with hands-on experience in Redshift, Glue, and related technologies; familiarity with Canadian banking processes is a plus.

Join a globally recognized technology services company and contribute to complex data integration

Qualifications

• Experience with data warehouse architecture and ETL design.
• Knowledge of bank/financial data domains essential.
• Leadership experience to mentor developers.

Responsibilities

• Lead and mentor a team of developers.
• Manage complete data warehouse systems end-to-end.
• Capture requirements and deliver technically sound solutions.
• Balance technical and domain skills for projects.
• Identify and list 5 nice-to-have skills and experiences.

Skills

Data warehouse

ETL processes

Team leadership

Banking domain

AWS Cloud

Tools

SSIS/SSRS

IBM Netezza

MS SQL Server

Sybase

AWS Redshift

AWS Glue

Kafka

EMR

Job description

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service.

It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.

Required skill set

\"Skills and Responsibilities

Key Responsibilities:

• Resource have strong data warehouse technical knowledge. Resource have knowledge in Bank and financial domain (Minimum Good years of experience).
• Resource also required knowledge in ETL process and develop the SSIS packages.
• Ability to lead the team of developers and mentor as needed.
• Ability to understand the requirements and experience in managing complete data warehouse systems.
• Please include skills related to technical as well as domain and non-technical skills and experience as applicable to the position.
• ETL data warehouse MS SSIS/SSRSIBM NetezzaMS SQL server/Sybase databaseAWS Redshift, AWS Glue Please list 5 “NICE TO HAVE” but not mandatory skills and experience for this requirement
• AWS Cloud services (Spark, Redshift and EMR).
• Knowledge in lending systems and functional knowledge on the same.
• Knowledge in MDM systems for customer demographics process.
• Knowledge in retail and commercial deposit system process (Core banking with Canadian banking domain).
• Strong solution Knowledge in AWS Cloud and hands on experience with ETL process (like Kafka message processing, batch interface data injection and other business layer process).

Salary Range - CA$ 100,000 - CA$ 120,000 Per Year

Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.