Automation testing and data pipelines are becoming the backbone of modern, data‑driven enterprises, especially as real‑time processing gains traction. Companies are scrambling for experts who can blend solid ETL validation with robust code and streaming platforms. This contract role in Dallas offers a chance to leverage deep Python, Kafka, and AWS expertise while working on high‑impact automation projects.

Job Summary

We are seeking an experienced Automation SDET to design, develop, and maintain automated test frameworks for ETL processes, data validation, and streaming integrations. The candidate will write Python scripts, configure Kafka consumers/producers, and utilize AWS services to ensure data quality and pipeline reliability. This is a hybrid, contract position requiring on‑site client interviews and local presence in Dallas.

Top 3 Critical Skills Table

Interview Preparation

1. Describe your end‑to‑end experience building an ETL testing framework in Python.
   What the interviewer is looking for: Depth of knowledge in test design, handling of large data sets, and automation best practices.
2. How do you validate data integrity when consuming from a Kafka topic?
   What the interviewer is looking for: Understanding of offset management, schema validation, and idempotent consumption.
3. Explain a challenging bug you uncovered in an AWS‑based data pipeline and how you resolved it.
   What the interviewer is looking for: Problem‑solving skills, familiarity with AWS services (e.g., S3, Lambda, Glue), and debugging techniques.
4. What strategies do you use to keep automated tests maintainable as ETL jobs evolve?
   What the interviewer is looking for: Test modularity, data‑driven testing, and version control practices.
5. Can you walk through the steps to set up a CI/CD pipeline for ETL test suites?
   What the interviewer is looking for: Experience with CI tools (Jenkins, GitLab CI), containerization, and automated reporting.

Resume Optimization

• Automation SDET
• ETL testing
• Data validation
• Python
• Kafka
• AWS services
• Hybrid work model
• Contract
• Dallas, TX
• 9+ years experience

Application Strategy

When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your up‑to‑date resume, and clearly highlights your top relevant skills. Make sure to mention your expertise in Python automation, ETL testing, and Kafka/AWS integrations, and reference any recent projects that showcase these abilities. Emphasize that you are a local Dallas candidate ready for an in‑person interview.

Career Roadmap