ETL Tester

2 weeks ago


Toronto, Canada Kumaran Systems Full time

We are seeking a highly motivated and experienced Senior Test Automation Engineer to join our QA team. You will play a critical role in ensuring the quality and reliability of our mission-critical financial transaction processing system. This involves designing, developing, and executing automated tests for ETL processes, database validations, and API integrations, with a focus on ISO 8583 message processing.


Responsibilities:

Test Automation Framework Development:


  • Design, develop, and maintain a robust and scalable test automation framework for ETL testing, database testing, and API testing.
  • Select and implement appropriate automation tools and technologies aligned with industry best practices and team preferences.
  • Integrate automated tests into the CI/CD pipeline for continuous testing and rapid feedback.


ETL Testing:

  • Develop and execute automated tests to validate data extraction, transformation, and loading processes.
  • Verify data integrity, accuracy, and completeness throughout the ETL pipeline.
  • Analyze test results, identify defects, and collaborate with developers to ensure timely resolution.


Database Testing:

  • Design and develop tests that integrate queried data from various databases into downstream validations
  • Implement data quality checks and validation rules to maintain data accuracy and consistency.


API Testing:

  • Develop automated tests for RESTful APIs involved in ATM transaction processing.
  • Validate API request and response payloads, including ISO 8583 message formats.


Preferred Skills:

  • Expertise in an OOP language, preferably Java
  • Strong SQL skills and experience with automated database testing
  • Hands-on experience with API testing tools and techniques (e.g., Postman, RestAssured).
  • Solid understanding of ISO 8583 messaging standard and its application in ATM transaction processing.
  • Experience with CI/CD tools and processes (e.g., Jenkins, GitLab CI).
  • Excellent analytical, problem-solving, and communication skills.
  • Experience working in the banking or financial services industry is a plus.


Education:

  • Bachelor’s degree/University degree or equivalent experience

  • Etl Tester

    7 months ago


    Toronto, Canada Reveille technologies Full time

    Position**:ETL Tester** Location**:Remote Work (Canada)** JD: - Minimum 8+ years of Exp is required - **Looking for an ETL Testing engineer with Experience in AWS (mandatory)**: - Experience in developing and implementing test strategies for complex initiatives - Experience providing testing oversight over multiple agile team - Experience in SQL - Strong...

  • ETL Tester

    9 hours ago


    Toronto, Canada AllianceIT Inc Full time

    Role: ETL Tester (Complex SQL Queries)Location: Toronto, ON (Onsite)Job Description:10+ years of experience in ETL QA with strong SQL Queries.ETL QA Assist with the development of QA software for our testing facility Oversee the production of all software products created by our design and programming team Monitor and review quarterly data based on suppliers...

  • Etl Tester

    3 months ago


    Toronto, Canada Atlantis IT group Full time

    **Job Title: ETL Tester** **Location: Toronto, ON** **Duration: Long Term Contract** - 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 in data analysis, including profiling, auditing, balancing, and reconciliation, in an Information...

  • ETL Tester

    2 weeks ago


    Toronto, Ontario, C6A, Ontario, Canada AllianceIT Inc Full time

    Role: ETL Tester (Complex SQL Queries)Location: Toronto, ON (Onsite)Job Description:10+ years of experience in ETL QA with strong SQL Queries.ETL QA Assist with the development of QA software for our testing facility Oversee the production of all software products created by our design and programming team Monitor and review quarterly data based on suppliers...

  • Etl Tester

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

  • Etl QA Tester

    2 months ago


    Toronto, Canada LTIMindtree Full time

    **Role: ETL Tester** **Location-Toronto, ON (Hybrid)** **Full Time** - **5+ 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 experience**: - Analyzing the Technical and...

  • ETL Automation Tester

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Iris Software Inc. Full time

    Iris's direct client, one of the Top 5 Bank in Canada, is looking to hire a ETL Automation Tester Role for a long term opportunity at Toronto, ON (Hybrid Position). Please respond back with your most recent resume if you would be interested..!Our Client is a Canadian multinational financial services company and the largest bank in Canada by market...

  • Etl Tester 10+year

    7 months ago


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

  • Etl Tester

    7 months ago


    Toronto, Canada Amaze systems Full time

    **Role: ETL Testing** **Location: Toronto** Overview: Seeking an ETL Data Testing Lead with expertise in SAP S/4HANA data migration. The role involves leading a team to ensure accurate and high-quality data migration through effective ETL testing. **Responsibilities**: 1. Lead ETL testing team, providing guidance on strategies and methodologies. 2....


  • Toronto, Canada epsilonsolutions 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, Canada Atlantis IT group Full time

    **Role: QE - ETL Tester** **Location: Toronto, ON - Canada** **Duration - Long Term** **JOB DESCRIPTION: - ** Minimum 8+ Years of experience needed. Strong ETL QE Experience (able to test data flows from source to target through various layers). Strong SQL knowledge (SQL Server is preferable): able to write queries based on mapping logic. Good knowledge...


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

  • ETL Tester

    9 hours ago


    Toronto, Canada Kumaran Systems Full time

    We are seeking a highly motivated and experienced Senior Test Automation Engineer to join our QA team. You will play a critical role in ensuring the quality and reliability of our mission-critical financial transaction processing system. This involves designing, developing, and executing automated tests for ETL processes, database validations, and API...

  • ETL Tester

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Kumaran Systems Full time

    We are seeking a highly motivated and experienced Senior Test Automation Engineer to join our QA team. You will play a critical role in ensuring the quality and reliability of our mission-critical financial transaction processing system. This involves designing, developing, and executing automated tests for ETL processes, database validations, and API...

  • Etl QA/ Tester

    4 weeks ago


    Toronto, Canada Alchemy Software Solutions LLC Full time

    **Must Have: ETL, Complex SQL Queries and Test Data Automation** 10+ years of experience in ETL QA with strong SQL Queries. - ETL QA Assist with the development of QA software for our testing facility Oversee the production of all software products created by our design and programming team Monitor and review quarterly data based on suppliers reports...

  • QA Etl Tester

    3 months ago


    Toronto, Canada AstraNorth Full time

    **Skills Required**: - Strong SQL, DB/ETL testing, Linux, and Python are mandatory. - Preferably to have data visualization tools expereince, e.g. Kibana or Tableau, and machine learning / AI experience. **Job Types**: Full-time, Permanent, Fixed term contract Schedule: - 8 hour shift - Monday to Friday Ability to commute/relocate: - Toronto, ON:...

  • Api Automation Tester

    6 months ago


    Toronto, Canada Wipro Limited Full time

    Overview: **About Wipro** Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging...

  • Api Automation Tester

    6 months ago


    Toronto, Canada Wipro Limited Full time

    Toronto, Canada - Tech Hiring - 3060823 **Job Description**: **About Wipro** Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. We leverage our holistic portfolio of capabilities in consulting,...


  • Toronto, Canada Iris Software Inc. Full time

    Alongside one of Canada's Top 5 Banks, Iris Software Inc. is seeking a seasoned ETL Automation Tester to assume a long-term contract in Toronto, ON. The selected professional will be part of a hybrid team and will work on mission-critical applications.The ideal candidate should have over 9 years of experience in automation testing and at least 6 years of ETL...