Job Title

Inclusion without ExceptionTata 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.About TCSTCS is an IT services, consulting, and business solutions organization that has been partnering with many of the worlds largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS operates in 55 countries and employs over 607,000 highly skilled individuals, including more than 10,000 in Canada. The company generated consolidated revenues of US $30 billion in the fiscal year ended March 31, 2025, and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned it a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4Good Emerging Index.Must Have Skills: Experience in writing complex SQL queries, Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered. Should have experience testing multiple test phases in medium to large projects. Understanding of information governance principles and how they could apply in a testing capacity. Should have adequate experience and clear understanding of data warehouse and data mart testing. Identification and Test Data Preparation Techniques. Ability to transform complex Business logic into SQL or PL/SQL queries. Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Creating requirements traceability matrix (RTM) Proficiency with Test Case Preparation and Execution. QA Automation Test tools expertise using Python. Extensive exposure to ETL testing with high-level of SQL skills is required. Should have exposure to large data sets and understand Data Quality Framework. Experience with Cloud Snowflake and AWS(S3) including PostgreSQL DB, SQL Database, Hadoop Data Lake, and Mongo DB Must have experience in using ETL Tool informatica Power Center & BDM Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores) Experience with data integration, data cleansing, and data analytics Experience with data modeling and design principles for data marts and data warehouses Excellent problem solving and analytical skills, able to handle challenging situations and act appropriately. 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. 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.