Test Automation QE - ETL and API Job at Acestack, Ontario, CA

  • Acestack
  • Ontario, CA

Job Description

Test Automation QE - ETL and API

Job Type: Full Time

Location: Toronto, ON

Work Model: Onsite / 4 Days

Primary Skills: ETL Test Automation, SQL & Python, AWS S3 & Hadoop

Job Description

We are seeking a skilled Test Automation QE - ETL and API professional to design and develop comprehensive automated testing solutions for ETL processes and APIs. The role focuses on ensuring data accuracy, pipeline reliability, and overall system quality through advanced SQL validation, Python automation, cloud data operations, and Quality Engineering practices.

Key Responsibilities
  • Design and develop automated testing frameworks for ETL processes and APIs.
  • Write complex SQL queries for data transformation validation, profiling, reconciliation, and root cause analysis.
  • Develop Python scripts and utilities for test automation, data validation, and reporting.
  • Work with AWS S3, Hadoop ecosystems, and Parquet files to validate and optimize data pipelines.
  • Manage code repositories using GitHub and follow CI/CD best practices.
  • Apply Quality Engineering principles to identify risks early and implement preventative quality measures.
  • Document test results, communicate findings, and provide recommendations for improving data quality.
  • Collaborate with both technical and non-technical stakeholders throughout the testing lifecycle.
Required Skills & Qualifications
  • Advanced proficiency in SQL, including complex queries, stored procedures, and data validation.
  • Strong Python programming skills for automation and data processing.
  • Hands-on experience with Unix/Linux command-line operations and shell scripting.
  • Experience with AWS S3 and cloud-based data management.
  • Working knowledge of Hadoop and Big Data technologies.
  • Experience with ETL testing, data validation, and data quality analysis.
  • Familiarity with GitHub, CI/CD practices, and software testing methodologies.
Preferred Skills
  • Experience working with Parquet and large-scale data pipelines.
  • Knowledge of API automation and validation.
  • Strong analytical, troubleshooting, and communication skills.
  • Experience applying QE practices within data engineering environments.

Job Tags

Full time

Similar Jobs

Planet Fitness

Overnight Custodian Job at Planet Fitness

Job Summary The Member Services Representative will be responsible for creating a positive member experience by providing a superior level of customer service to Planet Fitness members, prospective members and guests. Essential Duties and Responsibilities...

Cardinal Health

Specialty Pharmacy Staff Pharmacist Job at Cardinal Health

 ...manages the Specialty Pharmacy located within Fort Sanders Regional Medical Center. We are currently hiring for a full time Pharmacist to work Monday - Friday, 8:30am - 5:00pm. The Pharmacist adjusts and dispenses medication to patients and drives the compliant and... 

PruittHealth

Receptionist AL PRN Weekend Job at PruittHealth

 ...Preferred qualifications) Prefer two (2) years of experience in a payroll, insurance and/or clerical position. Courses in payroll, bookkeeping, office procedures, and other related subjects. Family Makes Us Stronger. Our family, your family, one family. Committed to... 

Ernst & Young

Forensics - Insurance and Federal Claims Services - Insurance Adjuster - Manager Job at Ernst & Young

 ...help to build a better working world. EY's Forensics Insurance and Federal Claims Services practice specializes in helping clients achieve...  ...claims professional with a background in commercial claims adjusting to join our practice as a Manager. This role is ideal for... 

Phoenix Events

Customer Engagement Rep Job at Phoenix Events

 ...Collaborate with a lively and dedicated team Technologies: ~ Support More: We offer a paid internship opportunity for students and recent graduates to enhance your resume and gain valuable real-world experience. As a Customer Engagement Representative, you...