BI & ETL Tester - Hybrid

1 week ago

Toronto, Ontario, Canada Software International Full time $90,000 - $120,000 per year

Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.

We currently have a multiple, re-extendable, long term contract roles as a BI & ETL Tester - Hybrid with our global SAP consulting client, working onsite at large CPG/Entertainment client's office 2-3 days a week in dwontown, Toronto. This is a 6 month contract initially, but will be extended long term.

Role: BI & ETL Tester - Hybrid

Type: Contract

# of Roles: 1

Duration: 9-12 months to start + possible extensions

Location: Toronto, ON - Hybrid, 2-3 days onsite in downtown Toronto

Rate: Open based on expectations as a C2C contractor

Overview

We are seeking a skilled BI & ETL Tester to validate, analyze, and ensure the accuracy, performance, and reliability of data pipelines, BI reports, dashboards, and analytics solutions. The ideal candidate will have strong experience in data validation, SQL, ETL process testing, and working with modern data platforms.

Key Responsibilities

1. ETL / Data Pipeline Testing

  • Validate end-to-end ETL workflows including data extraction, transformation, and loading.
  • Perform source-to-target data validation, record counts, reconciliation, schema checks, and transformation logic checks.
  • Test data ingestion from multiple sources (databases, files, SAP, cloud platforms).
  • Verify scheduling, dependencies, and error-handling processes in ETL jobs.
  • Conduct regression, functional, and sanity testing for data loads.

2. BI / Reporting Testing

  • Validate BI reports and dashboards for accuracy, formatting, filters, drill-downs, KPIs, and aggregations.
  • Compare visual outputs with backend data using SQL queries.
  • Test performance, data refresh cycles, row-level security, and report-level access.

3. SQL & Data Quality Validation

  • Write complex SQL queries to validate business rules, calculations, and data transformations.
  • Identify data issues, anomalies, and integrity gaps.
  • Collaborate with Data Engineers, BI Developers, and Data Analyst to resolve defects.

4. Test Planning & Execution

  • Create detailed test plans, test cases, test scenarios, and acceptance criteria.
  • Perform manual testing and assist in setting up automated testing frameworks (e.g., Python, PyTest, dbt tests).
  • Document defects in tools like JIRA and follow through to closure.
  • Participate in sprint planning, reviews, and Agile ceremonies.

Required Skills & Experience

  • 510+ years of BI/ETL testing or QA experience.
  • Strong SQL skills (joins, window functions, aggregations, CTEs).
  • Experience testing ETL tools such as: Airflow
  • Experience with BI tools:
    • Power BI, SAP BO, etc.
  • Understanding of data warehousing (Star/Snowflake schema, dimensions, facts).
  • Knowledge of cloud data platforms ( GCP is a plus).
  • Familiarity with Agile/Scrum methodology.
  • Experience in defect management and test documentation tools.

Preferred Qualifications

  • Experience with SAP source systems (SAP ECC, S/4HANA, SAP BW, SAP IBP) for data validation.
  • Exposure to big data technologies (BigQuery).
  • Automation experience using Python or SQL-based frameworks.
  • Knowledge of CI/CD pipelines for data testing.
  • Experience with version control (Git).

Soft Skills

  • Strong analytical and problem-solving abilities.
  • Excellent communication with business and technical teams.
  • Ability to work independently and manage multiple assignments.
  • Detail-oriented with a focus on data accuracy and quality.

  • BI & ETL Tester

    1 week ago

    Toronto, Ontario, Canada Software International Full time $80,000 - $120,000 per year

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.We currently have a multiple, re-extendable, long term contract roles as a BI & ETL Tester - Hybrid with our global SAP consulting client, working onsite at large...

  • ETL Tester

    1 week ago

    Toronto, Ontario, Canada Iris Software Inc. Full time $90,000 - $120,000 per year

    Iris's client, the largest bank in the Canada is looking to hireETL Tester/Data TesterPlease find below the job details and share your resume if interested atJob Description:Title: Sr. ETL Tester/Data TesterLocation: Toronto, ON (3day/week HYBRID)Duration: Long term assignmentTitle: Data Tester/ETL TesterKey Responsibilities:Design, plan, and execute test...

  • ETL Tester

    1 week ago

    Toronto, Ontario, Canada Perinial Softech Pvt ltd Full time $80,000 - $120,000 per year

    Job Title: ETL Tester (Advanced SQL & Python)Location: Downtown Toronto (Hybrid: 2–3 days/week in office)Experience: 3–8 yearsJob Description:We are seeking a skilled ETL Tester with substantial hands-on experience in advanced SQL and Python. This role is open to candidates with either a Quality Assurance (QA) or Developer background, provided you can...

  • etl tester

    19 hours ago

    Toronto, Ontario, Canada Perinial Softech Pvt ltd Full time US$60,000 - US$84,000 per year

    Job Description:We are seeking a skilled ETL Tester with substantial hands-on experience in advanced SQL and Python. This role is open to candidates with either a Quality Assurance (QA) or Developer background, provided you can demonstrate core expertise in complex SQL operations on ETL platforms.Key Responsibilities:Design, develop, and execute...

  • DATA TESTER with ETL

    6 days ago

    Toronto, Ontario, Canada Iris Software Inc. Full time $90,000 - $120,000 per year

    Hi ,I hope you're doing well.We have a great opportunity with one of IRIS's clients in Toronto Ontario is looking for theSr ETL Data Tester with banking client. Please Share your Resume if you are interestedHybrid , 3 daysSkillsSQLETLShould be able to write Complex SQL QueriesData TestingAgile is good to haveAutomation is with Python is also Good to have not...

  • Senior Java/ ETL Software Developer

    6 days ago

    Toronto, Ontario, Canada Source Code Full time $80,000 - $120,000 per year

    Senior Java/ ETL Software Developer (Java, Informatica, ETL, SQL, PL/SQL,and Power BI)Toronto, Ontario - Hybrid, 3 days onsite - 87 Sir William Hearst Ave Toronto, ON M3M 0B4Contract, 9 months (with possibly of extension) Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training,...

  • ETL Developer

    22 hours ago

    Toronto, Ontario, Canada Spait Infotech Private Limited Full time

    Job Title: ETL DeveloperJob SummaryThe ETL Developer is responsible for designing, developing, and maintaining data integration solutions that enable the extraction, transformation, and loading of data from various sources into data warehouses, data lakes, or other storage systems. This role ensures data quality, consistency, and availability to support...

  • ETL Developer

    9 hours ago

    Toronto, Ontario, Canada Source Code Full time $90,000 - $120,000 per year

    ETL Developer (Microsoft Azure/Databricks/ Power BI/ Selenium/ JMeter)Location Hybrid - Candidate MUST work 3 days onsite and 2 days remote5700 Yonge Street, 10th Floor Toronto, Ontario, Finch Subway StationHealth Services Cluster, Ministry of Public and Business Service Delivery and ProcurementContract, 9 months to startSubmission Deadline , 9:00...

  • Power BI Developer

    6 days ago

    Toronto, Ontario, Canada Compest Solutions Inc Full time $110,000 - $120,000 per year

    Job title: Powe BI DeveloperClient: BankLocation: Toronto, ON (onsite) 4 day hybridPosition Type- SalaryT4Please reply with your expected Salary range--Key ResponsibilitiesDashboard & Report Development: Build interactive, visually compelling dashboards and reports tailored to business needs using Power BI Desktop and Service.Data Integration: Connect and...

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada fc71e8c5-deda-48e9-b38c-23c0611c543b Full time $70,000 - $120,000 per year

    ResponsibilitiesDesign, develop, and optimize scalable ETL workflows to extract data from various sources such as relational databases, cloud storage (AWS, Azure Data Lake), and APIs (RESTful API).Transform raw data into structured formats suitable for analysis and reporting, ensuring accuracy and consistency.Maintain and enhance existing ETL pipelines using...