Etl SQL Test Analyst - Toronto, Canada - Tata Consultancy Services

Tata Consultancy Services

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

About TCS

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.

Required Skills:

Relevant of ETL/SQL Testing with Python/ PySpark /Cucumber
Must understand DW concepts and have tested a 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)10. Python11. 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 Resources.