Data Tester (Big Data QE)

Role: Data Tester (Big Data QE)
Location: Waterloo, ON - Hybrid
Contract Role

Role Description
We are seeking a motivated Big Data QE / Data Tester with experience in data testing and a passion for the Property & Casualty (P&C) Insurance domain. The ideal candidate will be responsible for supporting data testing initiatives, validating data quality, and ensuring solutions meet design specifications, standards, and business requirements within an Agile environment.

Key Responsibilities
Develop and execute test strategies aligned with design specifications, standards, and user requirements.
Perform ETL and database testing, data migration testing, and report validation.
Write and execute complex SQL queries for data analysis and validation.
Execute and validate queries in GCP BigQuery.
Design and execute test cases in a Big Data environment.
Analyze data and validate data quality across various data sources.
Collaborate with Agile teams to test components iteratively throughout the development lifecycle.

Required Skills
6–8 years of experience in ETL Testing, SQL, Big Data, and Python.

Hands-on experience with:
- ETL and Database Testing
- Data Migration Testing
- Report Validation

Strong knowledge of GCP BigQuery.
Experience with PySpark and/or Python.
Expert-level SQL skills, including writing and understanding complex queries.

Advanced knowledge of Big Data technologies, including:
- Hadoop
- Hive
- Impala
- HBase
- Pentaho

Experience working in Agile project environments.

Preferred Skills
Exposure to the Property & Casualty (P&C) Insurance domain, specifically Property and Auto Insurance.
Knowledge of Guidewire.