What are the responsibilities and job description for the Test Engineer Lead - ZL position at SES?
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.