ETL Tester

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

Location: Toronto, CA

Posted Date: 6/16/2025