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 comprehensive ETL test cases and scenarios
  • Write and optimize advanced SQL queries for data validation, transformation, and troubleshooting
  • Collaborate with development teams to understand business and data transformation requirements
  • Validate large volumes of data across multiple sources and targets using advanced SQL
  • Develop automation scripts in Python for ETL testing and process streamlining
  • Analyze, report, and track defects; recommend solutions
  • Participate in Agile/Scrum processes and provide expertise throughout the test life cycle

Required Skills & Qualifications:

  • 7+ years of hands-on experience in ETL testing or related roles
  • Strong command of advanced SQL (complex joins, window functions, query optimization, data analysis)
  • Proficiency in Python for scripting and automation
  • Experience with ETL tools (e.g., Informatica, Talend, DataStage, SSIS) is a plus
  • QA professionals or Data/ETL developers with hardcore SQL expertise are welcome
  • Ability to troubleshoot, analyze, and validate large datasets
  • Excellent communication and interpersonal skills
  • Bachelor's degree in Computer Science, Information Technology, or related field

Must have:

  • 7+ years of Testing experience
  • Good background in ETL Testing
  • Good background in SQL / Db testing
  • Experienced with AWS services required are S3, Glue, Cloudwatch, Airflow and Athena

Mode: Hybrid (2–3 days/week in office, Downtown Toronto; rest WFH

Job Types: Full-time, Permanent

Pay: $29.11-$42.00 per hour

Application question(s):

  • How many years of hands-on experience do you have in ETL testing or related data validation roles?
  • How would you rate your proficiency in advanced SQL (e.g., complex joins, window functions, query optimization)?
  • Do you have hands-on experience writing Python scripts for automation or data validation?
  • Have you worked with any ETL tools (e.g., Informatica, Talend, SSIS, DataStage)?
  • Have you validated large datasets across multiple sources (e.g., multiple schemas, files, or database types)?
  • Are you comfortable working in a hybrid model (2–3 days per week onsite in Downtown Toronto)?
  • How many years of experience with AWS services required are S3, Glue, Cloudwatch, Airflow and Athena?
  • Do you have valid authorization to work in Canada for this position?

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

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

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

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

  • AWS Data Engineer

    2 weeks ago

    Toronto, Ontario, Canada XChange Software Inc Full time $120,000 - $180,000 per year

    Role:AWSDataEngineerLocation: Toronto, ON (Onsite)Full-timeJob Description:10+ years of experiencePrimary Skills AWS Data Engineer - AWS Glue, Amazon Redshift, S3 ETL Process , SQL, DatabricksExamining the business needs to determine the testing technique by automation testing.Maintenance of present regression suites and test scripts is an important...

  • AWS Data Engineer

    23 hours ago

    Toronto, Ontario, Canada Quantum World Technologies Inc. Full time $80,000 - $120,000 per year

    Role : AWS Data EngineerLocation: Toronto, ONType : ContractMust HaveAWS Glue, Amazon Redshift, S3, ETL Process , SQL, DatabricksJob DescriptionPrimary Skills• Examining the business needs to determine the testing technique by automation testing.• Maintenance of present regression suites and test scripts is an important responsibility of the tester.•...

  • QA Lead

    1 week ago

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

    Overall 10+ Years of Experience Examining the business needs to determine the testing technique by automation testing.Maintenance of present regression suites and test scripts is an important responsibility of the tester.The testers must attend agile meetings for backlog refinement, sprint planning, and daily scrum meetings.Testers to execute regression...

  • Software Test Engineer

    2 weeks ago

    Toronto, Ontario, Canada Itech Enterprises Full time $120,000 - $180,000 per year

    Position: Tester / QALocation: Mississauga, ON (Hybrid)Duration: FTETotal experience required:10 years7 yrs of experience in Automation testingHave worked with  Metadata tools such as Abinitio MHub, Alation, etc (Any metadata tool)Experience with Jira and managing complex requirementClose tie-up with developer for resolving the issuesSelf-motivated and...

  • Rq08204

    8 hours ago

    Toronto, Ontario, Canada Rubicon Path Full time $120,000 - $180,000 per year

    Position OverviewThe Senior Software Developer will be responsible for providing subject matter expertise and hands-on technical leadership across all relevant systems. This includes designing, developing, and deploying end-to-end solutions in both on-prem and cloud environments. The role will focus heavily on PL/SQL development, improvement and maintenance...