Data Integration Engineer - ETL Pipelines, Python & SQL

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 Integration Developer to design, develop, and maintain robust data pipelines and infrastructure across our enterprise systems.

This role emphasizes data quality, traceability, and regulatory compliance within modern data architectures. You will work with ETL tools (Informatica, Talend, Apache Airflow), Python scripting, and multiple SQL databases (Oracle, SQL Server, PostgreSQL) in Unix/Linux environments to deliver scalable data

Qualifications

• Experience designing and implementing ETL pipelines across enterprise systems.
• Strong Python scripting for data processing and automation.
• Hands-on work with multiple SQL databases (Oracle, SQL Server, PostgreSQL) and data quality checks.

Responsibilities

• Design and implement ETL solutions to move and transform data across systems.
• Document and maintain data lineage for transparency and regulatory compliance.
• Write and optimize complex SQL queries and manage database operations.
• Develop automation scripts to streamline data operations and reduce manual effort.
• Manage code with Git/GitHub, including branching and code reviews.
• Navigate Linux/Unix environments for deployment and troubleshooting data systems.
• Ensure data validation and integrity throughout pipeline lifecycles.
• Collaborate with data engineering and analytics teams on data quality and governance.

Skills

Python

SQL

ETL design

Data lineage

Unix/Linux

Git/GitHub

Data quality

Tools

Informatica

Talend

Apache Airflow

Oracle

SQL Server

PostgreSQL

Job description

Tata Consultancy Services Canada Inc. is seeking a skilled Data Integration Developer to design, develop, and maintain robust data pipelines and infrastructure across our enterprise systems.

This role emphasizes data quality, traceability, and regulatory compliance within modern data architectures. You will work with ETL tools (Informatica, Talend, Apache Airflow), Python scripting, and multiple SQL databases (Oracle, SQL Server, PostgreSQL) in Unix/Linux environments to deliver scalable data