ETL Automation QE

Inclusion without Exception

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.

Role Overview:

We are seeking a detail-oriented ETL Automation Quality Engineer to ensure the reliability, accuracy, and efficiency of our data pipelines. This role combines deep technical expertise in ETL processes, automation, and quality engineering to validate data integrity and system performance in a cloud-based environment.

Key Responsibilities

Design, develop, and maintain automated test frameworks for ETL workflows, ensuring data accuracy, consistency, and compliance with business requirements.

Write complex SQL queries to validate data transformations, integrity, and quality across databases and data lakes (e.g., Hadoop, Parquet).

Implement Python scripts to automate testing, monitor pipeline performance, and generate reports on data quality metrics.

Collaborate with engineering teams to integrate automated tests into CI/CD pipelines using GitHub and GitHub Actions.

Manage data storage and retrieval processes in AWS S3, ensuring scalability and security.

Apply QE methodologies (e.g., test planning, risk analysis, defect tracking) to identify and resolve issues in ETL pipelines.

Develop and execute test cases for API integrations (nice to have) and validate end-to-end data workflows.

Document test strategies, results, and recommendations for process improvements.

Work with cross-functional teams to troubleshoot data discrepancies and optimize ETL processes.

Must-Have Qualifications

Expertise in SQL for data validation and complex querying.

Proficiency in Python for scripting and automation.

Hands-on experience with Unix/Linux, cloud platforms (AWS), Hadoop, Parquet, and AWS S3.

Familiarity with GitHub for version control and collaboration.

Proven experience in automated ETL testing frameworks.

Strong communication skills to articulate technical issues and solutions to diverse stakeholders.

Analytical mindset with a focus on quality and attention to detail.

Understanding of QE principles.

Salary Range - CA$ 90,000 - CA$ 110,000 Per Year

TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.

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.

Location

Toronto, ON

Job Function

TECHNOLOGY

Role

Analyst

Job Id

418803

Desired Skills

AWS | Python | ETL Testing