ETL Tester

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

Job summary

Tata Consultancy Services Canada Inc. is seeking a data ETL tester to analyze requirements, design test cases, and validate data pipelines and ETL processes across multiple data sources.

The role requires strong SQL skills for data comparisons and hands-on experience with HP ALM and JIRA to track test activities and issues. Ontario-based opportunity with a competitive salary and growth potential.

Qualifications

• Years of experience in testing application and data pipelines ETLs.
• Experience in writing SQL to compare reference and result datasets.
• Familiarity with HP ALM and JIRA.

Responsibilities

• Analyze requirements and prepare test cases for data integration and ETL processes.
• Test data ingestion and transformation, compare datasets for accuracy.
• Validate ETL job flow completion against reference data.

Skills

ETL testing

SQL data comparisons

Data analysis

Test case development

Requirements analysis

Tools

HP ALM

JIRA

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.

Role Description

• years of experience in testing application and data pipelines ETLs.
• Analyze requirements, prepare test case for data integration, ingestion, complex transformation process, prepare test data analyze test data for ETL testing.
• Understand the ETL mapping and test successful completion of the job or job flow by comparing the reference data set with the result data set.
• Good experience in analyzing and comparing various forms data sets on flat files, database tables, etc.
• Experience in writing SQL in database to perform data comparison, Experience in HP ALM JIRA

Salary Range - CA$ 90,000 - CA$ 100,000 Per annum

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.