Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
ETL Test Automation Lead
Job
Arrowminds inc
Philadelphia, PA (In Person)
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
72
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Position:
ETL Test Automation Lead Duration:
12Months 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).