Informatica ETL tester

HCLTech; Vancouver; On-site; CAD 70,000 - 88,000; Full time

Job summary

HCLTech is seeking an experienced ETL Test Lead in Vancouver to lead data testing initiatives. The role requires expertise in ETL processes and data warehousing, along with advanced SQL skills. You will define testing strategies and mentor a team, ensuring data quality and integrity for the organization.

Qualifications

• 5+ years of experience in ETL testing, with at least 2 years in a lead or senior role.
• Strong expertise in data warehousing concepts, ETL processes, and data modeling.
• Familiarity with automated ETL testing tools preferred.

Responsibilities

• Lead and mentor a team of ETL testers, providing technical guidance.
• Define, develop, and implement comprehensive ETL test strategies.
• Collaborate with ETL developers and data architects to understand requirements.

Skills

Advanced proficiency in SQL

ETL testing

Data warehousing concepts

Data modeling

Analytical skills

Leadership

Problem-solving

Tools

Jira

Azure DevOps

Informatica PowerCenter

QuerySurge

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by HCLTech. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$70,000.00/yr - CA$88,000.00/yr

TEX: 10; REX: 8

SQL: (Advanced proficiency for complex data querying and validation)

Data Warehousing Concepts & Data Modeling

Automated ETL Testing Tools: (e.g., QuerySurge, Informatica Data Validation Option) - Preferred but highly valuable

Cloud Data Platforms: (e.g., Snowflake, AWS Redshift, Azure Synapse) - Preferred but highly valuable

Job Title: ETL Test Lead

Overview: We are seeking an experienced and highly skilled ETL Test Lead to spearhead our data testing initiatives. This role requires a strong background in ETL processes, data warehousing, and comprehensive testing methodologies. The ideal candidate will be responsible for leading a team of ETL testers, defining test strategies, and ensuring the quality and integrity of data across our systems. Responsibilities: Lead and mentor a team of ETL testers, providing technical guidance and support. Define, develop, and implement comprehensive ETL test strategies, plans, and cases. Oversee the execution of various ETL testing types, including data validation, data integrity, transformation logic, performance, and regression testing. Collaborate closely with ETL developers, data architects, business analysts, and other stakeholders to understand data requirements and ensure test coverage. Design and execute complex SQL queries for data validation and comparison between source and target systems. Identify, document, and track defects, working with development teams for resolution. Develop and maintain ETL testing frameworks and automation scripts. Ensure adherence to data quality standards and best practices throughout the data lifecycle. Report on testing progress, risks, and quality metrics to project leadership. Contribute to continuous improvement of ETL testing processes and methodologies.

Required Skills: 5+ years of experience in ETL testing, with at least 2 years in a lead or senior role. Strong expertise in data warehousing concepts, ETL processes, and data modeling. Advanced proficiency in SQL for complex data querying and validation. Experience with ETL tools (e.g., Informatica PowerCenter, Informatica IDMC, Talend, SSIS) and understanding of their testing implications. Solid understanding of various ETL testing methodologies and best practices. Experience with test management tools (e.g., Jira, Azure DevOps, ALM). Excellent analytical, problem-solving, and troubleshooting skills. Strong leadership, communication, and interpersonal skills. Ability to manage multiple priorities and work effectively in a fast-paced environment. Preferred Skills: Experience with automated ETL testing tools (e.g., QuerySurge, Informatica Data Validation Option). Familiarity with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure Synapse). Knowledge of scripting languages (e.g., Python, Shell) for test automation. Understanding of CICD pipelines in a data engineering context. Relevant certifications in data warehousing, ETL, or testing.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at HCLTech by 2x

Get notified about new Software Tester jobs in Vancouver, British Columbia, Canada.

Surrey, British Columbia, Canada 1 week ago

Burnaby, British Columbia, Canada 5 days ago

Software Development Engineer in Test II

Software Development Engineer in Test II

Burnaby, British Columbia, Canada 3 months ago

Surrey, British Columbia, Canada 1 month ago

Burnaby, British Columbia, Canada 1 month ago

Software Development Engineer in Test II

Burnaby, British Columbia, Canada 2 weeks ago

Quality Assurance Engineer II, Amazon Payment Products

Software Development Engineer in Test II

Quality Assurance Engineer II, Amazon Payment Products

Sr. QA Test Engineer (SDET) with SQL & Python

Burnaby, British Columbia, Canada $71,319.00-$93,077.00 2 weeks ago

Sr. Controls Software Engineer, Test & Automation

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.