ETL/SQL Test Lead

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 and is reflected in our people stories across our workforce implemented through equitable workplace policies and processes.

About TCS

TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions. Our agile industry units have embedded capabilities to enable rapid responses that provide a competitive edge to our customers. This, coupled with a unique Global Network Delivery Model™ (GNDM™), is recognized as the current benchmark of excellence in technology deployment. We have made significant investments in digital technology, horizontal, and vertical platforms, allowing us to successfully serve our clients for over 50 years.

Skills and Responsibilities:

• ETL/SQL Test Lead experience with Java/Python/PySpark/Cucumber

• Must understand DW concepts and have tested Datawarehouse (Natural Keys, Surrogate Keys, Slowly Changing Dimensions) .

• Impact on Parent and Child tables due to Incremental and History loads.

• ETL Testing (Schema test, Mandatory columns test, Count test, Transformation test, Referential Integrity) along with negative scenarios.

• Working experience with SQL is must specially (Analytical functions, Complex joins, Aggregation functions).

• Must have Experience with Defect and Test cases management tool experience (ALM or JTMF).

• Usual testing concepts

• Defect triaging.

• Understanding of STTM (Source to Target Mapping).

• Automation (ETL)

• Python

• Cucumber

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 accommodations during the recruitment and selection process, please inform Human Resource.

Thank you for your interest in TCS. Candidates that meet the qualification 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.