Perform end-to-end ETL testing, including data validation, transformation logic testing, and data reconciliation
Write and execute complex SQL queries for data validation and analysis
Validate data movement across various data sources, staging layers, and target systems
Analyze and troubleshoot data issues, ensuring data accuracy and integrity
Implement and maintain automated test scripts for ETL and API layers
Contribute to continuous integration and continuous deployment (CI/CD) pipelines to improve testing efficiency
Leverage test automation tools to accelerate execution cycles

Requirements

Hands-on experience in ETL Testing and SQL
Strong understanding of data warehousing concepts, ETL workflows, and data pipelines
Experience with QA methodologies, defect lifecycle, and SDLC/STLC
Proficiency in test automation frameworks/tools (e.g., Python, Selenium, Informatica, or similar)
Experience with performance testing, test data management, and environment management
Familiarity with CI/CD tools such as Jenkins, Azure DevOps, GitLab, etc.
Strong analytical and problem-solving skills
Ability to work collaboratively with cross-functional teams

Benefits

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL testingSQLdata validationdata transformationdata reconciliationtest automationperformance testingtest data managementdata warehousingETL workflows

Soft Skills

analytical skillsproblem-solving skillscollaborationcommunication