Etl SQL Test Analyst

2 weeks ago


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


  • Database Developer

    1 month 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,...

  • QA Test Analyst

    1 month ago


    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Typical Day in Role • Develop, Execute test plans, scenarios, scripts or procedures • Test system modifications for areas such as database impacts, software scenarios, or usability • Document software defects, using a bug tracking system, and report defects to software developers • Identify, analyze and document problems with program function,...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Typical Day in Role • Develop, Execute test plans, scenarios, scripts or procedures • Test system modifications for areas such as database impacts, software scenarios, or usability • Document software defects, using a bug tracking system, and report defects to software developers • Identify, analyze and document problems with program function,...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Typical Day in Role • Develop, Execute test plans, scenarios, scripts or procedures • Test system modifications for areas such as database impacts, software scenarios, or usability • Document software defects, using a bug tracking system, and report defects to software developers • Identify, analyze and document problems with program function,...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Typical Day in Role • Develop, Execute test plans, scenarios, scripts or procedures • Test system modifications for areas such as database impacts, software scenarios, or usability • Document software defects, using a bug tracking system, and report defects to software developers • Identify, analyze and document problems with program function,...


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


  • 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 Test Analyst

    4 weeks ago


    Toronto, Canada Synkriom Technology Pvt. Ltd. Full time

    **Minimum 10+ years of Exp is required**: - **Looking for an ETL Testing engineer with Experience in AWS**: - Experience in developing and implementing test strategies for complex initiatives - Experience providing testing oversight over multiple agile team - **Experience in SQL**: - Strong problem-solving skills, troubleshooting and root cause analysis...

  • Etl Tester

    1 month ago


    Toronto, Canada AlphaForce Technology Solutions Full time

    **Position: Business Intelligence Specialist - ETL Tester** **Location: 315 Front Street West, Toronto** **Security Level: CRJMC** Must haves: 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have) 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have) 2+ years Python (Must...

  • Senior Data Analyst

    9 hours ago


    Toronto, ON, Canada Resonaite Full time

    The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis for business users.Location: Mainly remote, team meetings in person - TorontoDuration: 6 months + 6 months extensionResponsibilitiesSupport existing...

  • QA Analyst

    7 days ago


    Toronto, Canada Dawn InfoTek Inc. Full time

    **Dawn InfoTek Inc. **is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated in delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fill the role of **QA Analyst...


  • Toronto, Canada Foilcon Full time

    General ResponsibilitiesDesign, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:-Oracle Golden Gate (knowledge and experience are an asset but not required) for data ingestion and change data capture (currently in final stages of proof of concept)-Azure Data Factory (expert...

  • Senior Data Analyst

    19 hours ago


    Toronto, Canada Resonaite Full time

    The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis for business users.Location: Mainly remote, team meetings in person - TorontoDuration: 6 months + 6 months extensionResponsibilitiesSupport existing...

  • Senior Data Analyst

    1 hour ago


    Toronto, Canada Resonaite Full time

    The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis for business users. Location: Mainly remote, team meetings in person - Toronto Duration: 6 months + 6 months extension Responsibilities Support...

  • ETL QA Tester

    1 week ago


    Old Toronto, Canada Epsilon Solutions Ltd. Full time

    Review requirements with business and data analyst. Analyse the requirements and prepare test scenarios, test cases and test scripts. Participate in daily status meetings to give updates on testing. Identify/Prepare test data for execution. Test execution and report defects. Retesting the defects fixes and closing them. Ability to multi-task & support...

  • ETL QA Tester

    2 weeks ago


    Old Toronto, Canada Epsilon Solutions Ltd. Full time

    Review requirements with business and data analyst. Analyse the requirements and prepare test scenarios, test cases and test scripts. Participate in daily status meetings to give updates on testing. Identify/Prepare test data for execution. Test execution and report defects. Retesting the defects fixes and closing them. Ability to multi-task & support...

  • ETL QA Tester

    2 weeks ago


    Old Toronto, Canada Epsilon Solutions Ltd. Full time

    Review requirements with business and data analyst. Analyse the requirements and prepare test scenarios, test cases and test scripts. Participate in daily status meetings to give updates on testing. Identify/Prepare test data for execution. Test execution and report defects. Retesting the defects fixes and closing them. Ability to multi-task & support...

  • ETL QA Tester

    1 week ago


    Toronto, ON, Canada Epsilon Solutions Ltd. Full time

    Review requirements with business and data analyst. Analyse the requirements and prepare test scenarios, test cases and test scripts. Participate in daily status meetings to give updates on testing. Identify/Prepare test data for execution. Test execution and report defects. Retesting the defects fixes and closing them. Ability to multi-task & support...


  • Toronto, Canada epsilonsolutions Full time

    Role: ETL Tester **Responsibilities**: 1. Review requirements with business and data analyst. 2. Analyse the requirements and prepare test scenarios, test cases and test scripts. 3. Participate in daily status meetings to give updates on testing. 4. Identify/Prepare test data for execution. 5. Test execution and report defects. 6. Retesting the defects...


  • Toronto, Canada epsilonsolutions Full time

    Role: ETL Tester **Responsibilities**: 1. Review requirements with business and data analyst. 2. Analyse the requirements and prepare test scenarios, test cases and test scripts. 3. Participate in daily status meetings to give updates on testing. 4. Identify/Prepare test data for execution. 5. Test execution and report defects. 6. Retesting the defects...