Current jobs related to BI & ETL Tester - Toronto, Ontario - Software International

  • etl tester

    1 week ago

    Toronto, Ontario, Canada Perinial Softech Pvt ltd Full time

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

  • ETL Lead

    7 days ago

    Toronto, Ontario, Canada Galent Full time

    Position:Talend Developer & Talend LeadLocation:TorontoMode of Work : Hybrid (4 days a week)Role Overview:We are seeking a highly skilled Talend Lead Developer to design, implement, and optimize ETL workflows that support our enterprise data integration needs. The ideal candidate will lead data engineering initiatives, ensure data quality, and collaborate...

  • ETL Talend Developer

    7 days ago

    Toronto, Ontario, Canada Galent Full time

    Role Overview:We are seeking a highly skilled Talend Developer to design, implement, and optimize ETL workflows that support our enterprise data integration needs. The ideal candidate will lead data engineering initiatives, ensure data quality, and collaborate with cross-functional teams to deliver scalable and reliable solutions.Key ResponsibilitiesETL...

  • Junior Tester

    6 days ago

    Toronto, Ontario, Canada Wirehead Full time

    Role: Junior QA TesterClient:Ontario GovernmentJob Type:ContractTerm:3 MonthsWorkplace Type:Hybrid / OnsitePay Rate:$ $35.00Start date:2-3 weeksLocation:Toronto, ONLanguage:EnglishClearance:N/AATS ID #: 10168Requirements: What you'll needSkills, Knowledge, Experience, and Qualifications:Technical Skills - 50%Solid Relational Database and SQL knowledge,...

  • ETL Talend Developer/Talend Lead

    7 days ago

    Toronto, Ontario, Canada Galent Full time

    Position:ETL Talend Developer/Talend LeadLocation:Toronto, ON Hybrid (4 days a week)Role Overview:We are seeking a highly skilled Talend Lead Developer to design, implement, and optimize ETL workflows that support our enterprise data integration needs. The ideal candidate will lead data engineering initiatives, ensure data quality, and collaborate with...

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada Source Code Full time

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

  • Senior Oracle ETL Developer

    1 week ago

    Toronto, Ontario, Canada Bevertec Full time

    Must Have:7 +years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing.5+ years experience in Azure Databricks, Delta Lake, Azure Storage,...

  • Salesforce QA Tester

    7 days ago

    Toronto, Ontario, Canada Compest Solutions Inc Full time

    Job title: Salesforce QA TesterClient: BankLocation: Toronto, ONPosition Type- ContractMight be in person interview so candidate should be ready for itPlease reply with your expected Contract rate range--Job Description/ ResponsibilitiesAutomation Engineer and Salesforce QA TesterCore Java, Selenium, Salesforce, ETL, SQL, User Acceptance Testing, Regression...

  • Power BI Data Engineer

    1 week ago

    Toronto, Ontario, Canada HSO Full time

    Become a Key Player as a Power BI Data Engineer at HSOAt HSO, we are committed to driving digital transformation through innovative data solutions. As aPower BI Data Engineer, you will play a pivotal role in helping our clients harness the power of their data to make informed business decisions. Your expertise in Power BI and data engineering will empower...

  • RQ10067 - Software Developer - ETL - Senior

    6 hours ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Responsibilities/Assignment Deliverables – Senior ETL DeveloperDesigns, develops, and maintains database back end and ETL applications for Data Warehouse and Business Intelligence solutions. Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-qualityÂ...

BI & ETL Tester

2 weeks ago

Toronto, Ontario, Canada Software International Full time


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.