Test Engineer Lead - ETL and Analytics platforms

  • Schaumburg, IL
  • Posted 18 hours ago | Updated 18 hours ago

Overview

Remote
Hybrid
Depends on Experience
Full Time
No Travel Required
Unable to Provide Sponsorship

Skills

Acceptance Testing
Amazon SES
Analytics
Business Rules
Change Data Capture
Cloud Computing
Collaboration
Continuous Delivery
Continuous Integration
Data Management
Data Migration
Data Validation
Data Warehouse
Databricks
Extract
Transform
Load
FOCUS
Informatica
Insurance
Load Testing
MPP
Management
Microsoft Azure
Migration
Netezza
PASS
Quality Assurance
Regression Analysis
Snow Flake Schema
Software Testing
System Integration Testing
Teradata
Test Execution
Test Plans
Test Scenarios
Test Strategy
Testing
Workflow

Job Details

Test Engineer Lead

Type: W2 With Benefits - No C2C

Location: Hybrid - 3 Days per week on-site

Top 5 Technical Skills:

  1. 8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
  2. 3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
  3. Hands-on experience in at least one large-scale data migration or modernization program, ideally involving:
  4. Migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake).
  5. Hands-on experience with at least one large-scale ETL tool migration (e.g., Informatica to dbt or similar).

Data Center Lift and Shift Project for Insurance Client

Job Description:

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).

  • Hands-on experience with at least one 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 LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.

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


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.

About SES