ETL Test Automation Lead

Position: ETL Test Automation Lead

Duration: 12 Months

Location: Onsite - Philadelphia, PA

JD:

We are seeking an experienced ETL Test Automation Lead with deep expertise in end-to-end testing across ETL pipelines, Data Warehouses/Data Lakes, and BI reporting platforms. The role requires close collaboration with business stakeholders, ETL developers,data architects, and QA teams to ensure complete data lineage from source ? ETL ? Data Warehouse/Data Lake ? Reporting, validating accuracy of transformations, data quality, and reporting logic. Because many reporting definitions are undocumented, the candidatemust work professionally with SMEs to identify missing logic, capture business rules, assess report criticality, and prioritize testing using risk-based methods. Success demands strong technical skills, communication, subject matter understanding, and ethicalresponsibility.

Key Responsibilities

Quality Engineering Leadership Define test strategies, plans, and governance; ensure coverage; drive defect prevention and continuous improvement. End-to-EndETL & Pipeline Testing Validate lineage across all layers; verify transformations, mappings, and aggregations; reconcile source vs. target data with advanced SQL. Reporting Logic Discovery Partner with SMEs to capture undocumented rules, KPI definitions, andmetrics; translate into testable criteria.BI/Reporting Validation Validate KPIs, formulas, filters, drill-downs, and visuals; ensure alignment between warehouse data and report outputs.

Risk-Based Testing Assess report criticality and business impact; prioritize testing for high-risk/high-value reports. SQL-Based Validation Write complexqueries for reconciliation, transformation checks, and exception analysis; provide root-cause findings.Test Planning & Execution Develop test plans, cases, scripts, regression suites; support UAT; maintain structured QA documentation.

Required Skills

10+ years in ETL/Data Warehouse testing & QA leadership.

Advanced SQL (joins, analytics, aggregations).

Hands-on with Data Warehouse/Data Lake (Oracle, Snowflake, Hadoop, Redshift).Python for automation (pandas, PySpark; csv/json/parquet validation).

BI tools OAC, Power BI, Tableau, OBIEE.

Preferred Skills

Domain experience in insurance, claims, or financial data.

Familiarity with ETL tools (Informatica, DataStage, ADF, Talend, SSIS, Query surge, python frameworks).