Apply Now

ETL Tester Architect : Philadelphia, PA : Long-Term Contract

Philadelphia, PA, US • Posted 3 days ago • Updated 13 hours ago

Contract Corp To Corp

Contract W2

Contract Independent

12 Months

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

Summary

Hi,

I''d like you to take a look at a great new position we now have available! Your opinion would be valued with regards to this opening. I really appreciate sending an updated resume & the best number with the best time to reach you.

Role:ETL Tester Architect

Location: Philadelphia, PA

Duration: Long-Term Contract

Key responsibilities

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 candidate must 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 ethical responsibility.

Key Responsibilities

Quality Engineering Leadership Define test strategies, plans, and governance; ensure coverage; drive defect prevention and continuous improvement.
End-to-End ETL & 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, and metrics; 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 complex queries 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)

Thanks & Regards

HAN IT
STAFFING

Chigiri Rohith Reddy

Sr.Technical Recruiter




	100 Wood Ave S, Suite 102, Iselin NJ, 08830

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.

Dice Id: 90838445
Position Id: 8997086
Posted 3 days ago

Contact the job poster

Ruma Kalra

Recruiter @ HAN IT Staffing Inc.

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

ETL Test Automation Lead

Philadelphia, Pennsylvania

•

3d ago

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 tran

Easy Apply

Full-time, Part-time, Contract, Third Party

QA/ Integration Analyst

Exton, Pennsylvania

•

Today

QA/INTEGRATION ANALYST - PHILADELPHIA, PA (REMOTE) We are seeking a hands-on QA/Integration Analyst to support a large-scale Virtual Building Automation System (VBAS) initiative focused on simulation validation, cloud-based data pipelines, and HVAC automation workflows. This role is embedded within a cross-functional delivery team and is responsible for planning, executing, and facilitating integration and acceptance testing across multiple AWS-hosted platforms and operational technology environ

Full-time

Sr. Data Quality Engineer(ETL Tester)

Remote

•

27d ago

Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts, and communicating relevant insights to the team Love to collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs Experience with both traditional and big data streaming Create and maintain complex SQL queries such as; type 2 triggers, various joins, aggregations, groupings, and more Execute ETL jobs using o

Easy Apply

Contract

Depends on Experience

ETL Tester OR Data Quality Engineer

Remote

•

4d ago

ETL Tester/ Data Quality Engineer100% Remote Contract Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts, and communicating relevant insights to the teamLove to collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needsExperience with both traditional and big data streamingCreate and maintain complex SQL queries such as; type 2 triggers, various joins, aggrega

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs