ETL Tester

Iris Software Inc.; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

A leading technology service provider in Toronto is seeking an experienced ETL Tester/Data Tester. This role involves designing and executing test cases for ETL validation and requires strong SQL skills. Candidates must have over 8 years of experience in ETL testing and data validation with tools like Informatica or Talend. The position offers a hybrid work model, requiring in-office presence 3 days a week.

Qualifications

• 8+ years of experience in ETL testing, data validation, and data analysis.
• Excellent communication skills to collaborate with cross-functional teams.
• Ability to prioritize work effectively on multiple projects.

Responsibilities

• Design, plan, and execute test cases for ETL validation.
• Verify data accuracy using ETL tools and SQL queries.
• Conduct root cause analysis on testing issues.

Skills

ETL testing

Data validation

Data analysis

Strong SQL skills

Agile/Scrum methodology

Communication skills

Problem-solving

Tools

Informatica

Talend

SSIS

JIRA

HP ALM

Job description

Lead Talent Acquisition | Financial Services | Client relations

Iris's client, the largest bank in Canada, is looking to hire ETL Tester/Data Tester.

Please find below the job details and share your resume if interested at [e-mail].

Job Description

Location: Toronto, ON (3 day/week HYBRID)

Duration: Long term assignment

Key Responsibilities

• Design, plan, and execute test cases, scenarios, and scripts for ETL validation and regression testing.
• Strong SQL required.
• Verify and validate data accuracy, completeness, and consistency using ETL tools and SQL queries.
• Create and maintain test cases, scripts, and documentation in test management tools such as JIRA and HP ALM.
• Collaborate with developers, data analysts, and business stakeholders to understand business and technical requirements for ETL testing.
• Identify, document, and report defects, issues, and risks related to ETL testing.
• Conduct root cause analysis on any issues that arise during testing and provide recommendations for remediation.
• Work in an Agile environment to ensure timely delivery of high-quality ETL testing.

Requirements

• 8+ years of experience in ETL testing, data validation, and data analysis.
• Strong SQL skills and experience working with ETL tools such as Informatica, Talend or SSIS.
• Experience with testing tools such as JIRA and HP ALM.
• Excellent communication skills and ability to collaborate with cross‑functional teams.
• Ability to work on multiple projects and prioritize work effectively.
• Experience in Agile/Scrum software development methodology.
• Ability to work independently and as a team member.
• Strong analytical and problem‑solving skills.

About Iris Software Inc.

With 4,000+ associates and offices in India, the U.S.A. and Canada, Iris Software delivers technology services and solutions that help clients complete fast, far‑reaching digital transformations and achieve their business goals. A strategic partner to Fortune 500 and other top companies in financial services and many other industries, Iris provides a value‑driven approach – a unique blend of highly‑skilled specialists, software engineering expertise, cutting‑edge technology, and flexible engagement models. High customer satisfaction has translated into long‑standing relationships and preferred‑partner status with many of our clients, who rely on our 30+ years of technical and domain expertise to future‑proof their enterprises. Associates of Iris work on mission‑critical applications supported by a workplace culture that has won numerous awards, including Certified Great Place to Work in India; Top 25 GPW in IT & IT‑BPM; Ambition Box Best Place to Work, #3 in IT/ITES; and Top Workplace NJ‑USA.