Jobs via Dice
Test Engineer Lead - ETL and Analytics platforms
Jobs via Dice, Schaumburg, Illinois, us, 60159
Test Engineer Lead - ETL and Analytics platforms
Apply via Dice today!
Job Details Type: W2 With Benefits - No C2C
Location: Hybrid - 3 Days per week on site
Project: Data Center Lift and Shift for an insurance client.
Top Technical Skills
8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
Hands‑on experience in at least one large‑scale data migration or modernization program, ideally involving migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake) and large‑scale ETL tool migration (e.g., Informatica to dbt or similar).
Key Responsibilities
Define the test strategy, scope, objectives, entry/exit criteria, and quality gates across all phases (unit, system, SIT, UAT, performance, regression, cutover).
Develop and maintain Test Plans and Test Approach documents aligned with program milestones.
Standardize test processes, templates, and metrics (defect density, pass rates, coverage).
Collaborate with architects, data engineers, and business SMEs to understand systems, data models, and business rules.
Design and execute test scenarios, cases, and data requirements for migration and re-platforming.
Implement data validation and reconciliation (row counts, aggregates, schema checks, business rules).
Lead testing of Databricks pipelines, jobs, notebooks, workflows and dbt models/tests.
Validate CDC and incremental load logic to ensure consistency and accuracy.
Coordinate performance and load testing for Databricks and Snowflake.
Manage test environments (Dev, QA, UAT, Pre-Prod) in Azure and Snowflake.
Oversee test data management (anonymization, subsetting, refresh strategies).
Align test execution with CI/CD pipelines for automated build and deployment workflows.
Basic Qualifications
8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
Hands‑on experience in at least one large‑scale data migration or modernization program, ideally involving migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake) and large‑scale ETL tool migration (e.g., Informatica to dbt or similar).
Ability to travel 50% when required.
Benefits SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical, dental, vision, life insurance, LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.
Contact Please contact me to discuss the details of this position further.
Please forward resume directly to for immediate consideration - rstarinieri at sesc.com.
I look forward to speaking with you soon!
Robin Starinieri
Director of Recruiting
Systems Engineering Services
#J-18808-Ljbffr
Job Details Type: W2 With Benefits - No C2C
Location: Hybrid - 3 Days per week on site
Project: Data Center Lift and Shift for an insurance client.
Top Technical Skills
8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
Hands‑on experience in at least one large‑scale data migration or modernization program, ideally involving migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake) and large‑scale ETL tool migration (e.g., Informatica to dbt or similar).
Key Responsibilities
Define the test strategy, scope, objectives, entry/exit criteria, and quality gates across all phases (unit, system, SIT, UAT, performance, regression, cutover).
Develop and maintain Test Plans and Test Approach documents aligned with program milestones.
Standardize test processes, templates, and metrics (defect density, pass rates, coverage).
Collaborate with architects, data engineers, and business SMEs to understand systems, data models, and business rules.
Design and execute test scenarios, cases, and data requirements for migration and re-platforming.
Implement data validation and reconciliation (row counts, aggregates, schema checks, business rules).
Lead testing of Databricks pipelines, jobs, notebooks, workflows and dbt models/tests.
Validate CDC and incremental load logic to ensure consistency and accuracy.
Coordinate performance and load testing for Databricks and Snowflake.
Manage test environments (Dev, QA, UAT, Pre-Prod) in Azure and Snowflake.
Oversee test data management (anonymization, subsetting, refresh strategies).
Align test execution with CI/CD pipelines for automated build and deployment workflows.
Basic Qualifications
8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
Hands‑on experience in at least one large‑scale data migration or modernization program, ideally involving migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake) and large‑scale ETL tool migration (e.g., Informatica to dbt or similar).
Ability to travel 50% when required.
Benefits SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical, dental, vision, life insurance, LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.
Contact Please contact me to discuss the details of this position further.
Please forward resume directly to for immediate consideration - rstarinieri at sesc.com.
I look forward to speaking with you soon!
Robin Starinieri
Director of Recruiting
Systems Engineering Services
#J-18808-Ljbffr