ETL Tester Remote

Overview

Remote
On Site
$DOE
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Sql
Data Warehouse
SSIS
ETL
AWS Glue
Azure Data Factory

Job Details

ETL Tester Remote Job Summary

We are looking for an experienced ETL Tester to validate, test, and ensure the accuracy and reliability of data extraction, transformation, and loading processes across data warehouse and analytics platforms. The ideal candidate will have strong SQL skills, experience testing ETL workflows, and the ability to work with cross-functional teams to ensure high-quality data delivery. This is a 100% remote role.

Key Responsibilities

  • Perform functional, integration, system, and regression testing for ETL processes and data pipelines.

  • Analyze business requirements to create detailed test plans, test cases, and test scenarios.

  • Validate data transformations, mappings, and data quality rules across source, staging, and target systems.

  • Execute SQL queries to perform data validation, reconciliation, and back-end testing.

  • Review ETL mappings, workflows, and jobs to understand data movement and transformation logic.

  • Identify defects, log issues, and track them through resolution using defect management tools (Jira, Azure DevOps, etc.).

  • Work closely with ETL developers, data engineers, and business analysts to troubleshoot and resolve data-related issues.

  • Validate performance of ETL jobs and ensure they meet required SLAs.

  • Support automation testing initiatives for ETL processes (if applicable).

  • Provide detailed testing documentation including test evidence, reports, and sign-offs.

Required Skills & Qualifications

  • 3 6+ years of experience as an ETL Tester or Data Warehouse QA Engineer.

  • Strong SQL skills (ability to write complex queries, joins, aggregations, etc.).

  • Hands-on experience testing ETL workflows using tools such as:

    • Informatica

    • Talend

    • DataStage

    • SSIS

    • Azure Data Factory

    • AWS Glue (any ETL tool is acceptable based on requirement)

  • Strong understanding of data warehousing concepts (star schema, dimensions, facts, SCDs).

  • Experience with data validation, reconciliation, and back-end database testing.

  • Familiarity with relational databases (Oracle, SQL Server, Snowflake, PostgreSQL, etc.).

  • Experience using test management and defect-tracking tools (Jira, ALM, TFS, etc.).

  • Ability to work independently in a remote environment.

Preferred Qualifications

  • Experience with automation tools for ETL testing (Python, Selenium, PySpark, or custom frameworks).

  • Knowledge of cloud data platforms (AWS, Azure, Google Cloud Platform, Snowflake).

  • Familiarity with CI/CD pipelines for data or QA processes.

  • Experience with API testing (Postman, RestAssured).

Education

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent work experience).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.