Overview
Hybrid
Depends on Experience
Full Time
Unable to Provide Sponsorship
Skills
Acceptance Testing
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
Soft Skills
Software Testing
System Integration Testing
Teradata
Test Execution
Test Plans
Test Scenarios
Test Strategy
Testing
Workflow
Job Details
Test Engineer Lead
Schaumburg, IL - on-site 3 days per week
Top 5 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).
- Hands-on experience with at least one large-scale ETL tool migration (e.g., Informatica to dbt or similar).
Top Soft Skills:
- Hands on technical leader
Company / Project Description / Business Driver
Data Center Lift and Shift Project for Insurance Client
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.
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.