ETL Tester Specialist (Data Quality)

TL;DR

ETL Tester Specialist (Quality Assurance): Ensuring the quality and reliability of data pipelines and applications through comprehensive quality engineering activities with an accent on ETL testing, data validation, and test automation. Focus on writing complex SQL queries for data analysis and contributing to CI/CD pipelines for testing efficiency.

Location: Atlanta, Chicago, and New York

Salary: $68,034–$77,904

Company

hirify.global is a global business and technology transformation partner, helping organizations accelerate their digital and sustainable transition.

What you will do

• Perform end-to-end ETL testing, including data validation, transformation logic, and 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.

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.

Culture & Benefits

• Paid time off including vacation, company-paid holidays, personal days, and sick leave.
• Medical, dental, and vision coverage.
• Retirement savings plans (e.g., 401(k) in the U.S.).
• Life and disability insurance.
• Employee assistance programs.
• Comprehensive, non-negotiable benefits package for all regular, full-time employees.