Etl Sql Test Analyst

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:

• Hands- on Years of experience in 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 Resource.

Thank you for your interest in TCS. Candidates that meet the qualification for this position will be contacted within a two-week period. We invite you to continue to apply for other opportunities that match your profile.