ETL/SQL Test Lead

4 weeks ago


Toronto, Canada Tata Consultancy Services Full time

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.


  • ETL/SQL Test Lead

    3 weeks ago


    Toronto, Canada Tata Consultancy Services Full time

    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...

  • ETL/SQL Test Lead

    4 weeks ago


    Toronto, Canada Tata Consultancy Services Full time

    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...

  • ETL/SQL Test Lead

    4 weeks ago


    Toronto, Canada Tata Consultancy Services Full time

    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...


  • Toronto, Canada Tata Consultancy Services Full time

    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...

  • Database Developer

    3 weeks ago


    Toronto, Canada CB Canada Full time

    Database Developer - SQL, ETL On behalf of our client in the Banking Sector, PROCOM is looking for a Database Developer - SQL, ETL. Database Developer - SQL, ETL – Job Description Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs Familiar with a variety of the field's concepts, practices,...

  • Qe Etl Testing

    5 days ago


    Toronto, Canada Atlantis IT group Full time

    **Role: QE ETL and Database (DB) Testing** **Location: Toronto** Min 5+ years of experience into QE in ETL and Database testing Strong skills on SQL and data-based testing Hands on experience in creating Automation Framework and maintenance. **Thanks&Regards** **PAUL**.CH** Apptoza Inc. Phone:6783872910 Ext 2910

  • Qe - Etl Testing

    6 days ago


    Toronto, Canada Atlantis IT group Full time

    **Role:QE ETL and Database (DB) Testing** **Location: Toronto,ON** **Duration: Fulltime** Min 5+ years of experience into QE in ETL and Database testing Strong skills on SQL and data-based testing Hands on experience in creating Automation Framework and maintenance. Thanks & regards, Sofia(Poorvika) **Apptoza Inc.** Phone:678-387-2904 Ext:2904


  • Toronto, Canada E-Solution Full time

    Role: ETL Tester Location: Toronto, Ontario Job description: - Experience in writing automation test cases, creating test scenarios, executing tests scripts and analyzing test results - test strategy and execution. - Writing SQL queries for various scenarios. - Implement and execute automation test suites for integration testing with multiple...

  • Sdet (Etl/SQL/python)

    4 weeks ago


    Toronto, Canada CGI Full time

    We're looking for software engineers with a passion for assuring quality. With this opportunity you'll support building and executing automated tests to verify ETL processes for a client in the Canadian Banking domain with Canada’s largest Information Technology Outsourcing and Management Consulting Company. **Insights you can act on** While technology...


  • Toronto, Canada Atlantis IT group Full time

    Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners,Strong...


  • Toronto, Ontario, Canada Atlantis IT group Full time

    Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners,Strong...

  • ETL Lead

    3 days ago


    Toronto, Canada BetasharpInc Full time

    Position: ETL lead Location: Remote, Canada Duration: Long Term Contract Skills Tech skills: Hadoop, Spark, Pyspark, HiveQL, Diyotta, DataStage Data warehousing Experience must. ETL pipelines using Pyspark must. ELT pipelines using SQL must. Big data tools: PySpark & Hadoop must Snowflake SQL is preferred Bitbucket code management must. CICD knowledge...

  • ETL Lead

    4 days ago


    Toronto, Canada BetasharpInc Full time

    Position: ETL leadLocation: Remote, CanadaDuration: Long Term ContractSkillsTech skills: Hadoop, Spark, Pyspark, HiveQL, Diyotta, DataStageData warehousing Experience must.ETL pipelines using Pyspark must.ELT pipelines using SQL must.Big data tools: PySpark & Hadoop mustSnowflake SQL is preferredBitbucket code management must.CICD knowledge...

  • ETL Lead

    5 days ago


    Toronto, Canada BetasharpInc Full time

    Position: ETL leadLocation: Remote, CanadaDuration: Long Term ContractSkillsTech skills: Hadoop, Spark, Pyspark, HiveQL, Diyotta, DataStageData warehousing Experience must.ETL pipelines using Pyspark must.ELT pipelines using SQL must.Big data tools: PySpark & Hadoop mustSnowflake SQL is preferredBitbucket code management must.CICD knowledge...

  • ETL Lead

    3 days ago


    Toronto, Canada BetasharpInc Full time

    Position: ETL leadLocation: Remote, CanadaDuration: Long Term ContractSkillsTech skills: Hadoop, Spark, Pyspark, HiveQL, Diyotta, DataStageData warehousing Experience must.ETL pipelines using Pyspark must.ELT pipelines using SQL must.Big data tools: PySpark & Hadoop mustSnowflake SQL is preferredBitbucket code management must.CICD knowledge...

  • ETL Developer

    2 weeks ago


    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service TorontoMin. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • Etl QA Tester

    7 days ago


    Toronto, Canada LTIMindtree Full time

    **Role--ETL Tester with Python Knowledge** **Location-Toronto, ON** **Full Time** **Exp SQL and some Unix** - **3+ Years of hands-on experience required into ETL Testing tools**: - **RDBMS systems like Oracle/Teradata/Sql Server/DB2 (Any One)**: - **Writing complex queries using Joins and Sql Server special functions**: - **Mapping Stored Procedures...


  • Toronto, ON, Canada Zortechsolutions Full time

    Role: Data Engineer-SQL, Python, ETL Location: Remote/CANADA Duration: 6+ Months Job Description Key Skills required: We are looking for Senior Data Engineering Candidates based out of the US/Canada. Expertise in SQL, Python and ETL flows is a must have. Medium expertise/working knowledge in Scala is also needed, as our data pipelines are written in...


  • Old Toronto, Canada Zortechsolutions Full time

    Role: Data Engineer-SQL, Python, ETLLocation: Remote/CANADADuration: 6+ MonthsJob DescriptionKey Skills required: We are looking for Senior Data Engineering Candidates based out of the US/Canada. Expertise in SQL, Python and ETL flows is a must have. Medium expertise/working knowledge in Scala is also needed, as our data pipelines are written in both Scala...


  • Old Toronto, Canada Zortechsolutions Full time

    Role: Data Engineer-SQL, Python, ETLLocation: Remote/CANADADuration: 6+ MonthsJob DescriptionKey Skills required: We are looking for Senior Data Engineering Candidates based out of the US/Canada. Expertise in SQL, Python and ETL flows is a must have. Medium expertise/working knowledge in Scala is also needed, as our data pipelines are written in both Scala...