Data Integration Developer

Inclusion without Exception

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.

TCS has been serving the Canadian marketplace for more than 35 years and today is the technology partner of choice for many of the country's leading organizations. As one of the largest IT services providers in Canada and globally, TCS is aiming 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 and values of the Tata Group, TCS is focused on creating long-term value for its clients, investors, employees, and the communities it serves. With a highly skilled workforce supporting customers from coast to coast, TCS has consistently been recognized as a Top Employer by the Top Employers Institute, including a recent top ranking at the country level.

TCS also sponsors 14 of the world's most prestigious marathons and endurance events, including the TCS Toronto Waterfront Marathon, reflecting its commitment to health, sustainability, and community empowerment.

Data Integration Developer

Job Description

Position Overview

We are seeking a skilled Data Integration Developer to design, develop, and maintain robust data pipelines and infrastructure that ensure data quality, traceability, and compliance across enterprise systems.

Key Responsibilities

• Design and implement ETL solutions using industry-standard tools to move and transform data across systems.
• Document and maintain comprehensive data lineage to track data flow from source to destination, ensuring transparency and regulatory compliance.
• Write and optimize complex SQL queries across Oracle, SQL Server, and PostgreSQL.
• Manage database operations using DDL, DML, DQL, and DCL commands.
• Develop automation scripts and tools using Python to streamline data operations and reduce manual effort.
• Manage code repositories using Git and GitHub, including branching, merging, and code review collaboration.
• Work in Linux and Unix environments for deployment, monitoring, and troubleshooting data systems.
• Implement data validation checks and ensure data integrity throughout the pipeline lifecycle.

Required Qualifications

• Proven experience with ETL tools such as Informatica, Talend, Apache Airflow, or similar platforms.
• Strong proficiency in Python for scripting and data processing.
• Hands-on experience with Oracle, SQL Server, and PostgreSQL.
• Solid understanding of data lineage concepts and best practices.
• Experience with Git and GitHub for version control.
• Comfortable working in Unix and Linux environments.
• Knowledge of SQL DDL, DML, DQL, and DCL operations.
• Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.

Preferred Qualifications

• Experience with cloud data platforms such as AWS, Azure, or GCP.
• Knowledge of data quality frameworks.
• Familiarity with Agile methodologies.
• Previous experience in financial services or banking.

Salary Range - CA$ 90,000 - CA$ 110,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.

Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.