ALTA IT Services, LLC · 5 hours ago
Senior ETL SQL Automation SDET
ALTA IT Services, LLC is seeking a Senior ETL SQL Automation SDET to support enterprise systems for a major regional health insurer. The role focuses on back-end testing, ETL validation, SQL development, and Java automation, requiring hands-on technical skills to develop automated test solutions in a cloud environment.
ConsultingInformation TechnologyStaffing Agency
Responsibilities
Perform technical design, coding, and back-end testing, supporting and enhancing existing applications and integrations
Develop and execute automated unit, integration, and functional tests, including creating test scenarios, plans, and TDD/BDD-based automation
Validate functional and non-functional requirements across APIs, ETL pipelines, and distributed systems
Support maintenance activities, identify optimization opportunities, and contribute to planning and estimation
Ensure adherence to DevOps, CI/CD, and code quality standards while producing interface documentation
Provide technical support for high visibility production issues and collaborate with cross-functional teams to build resilient systems
Participate in architectural discussions, tool evaluations, and roadmap planning
Mentor junior engineers and contribute to engineering best practices
Qualification
Required
SDET – Back-end focus
ETL testing
Strong SQL (expert-level): writing queries/stored procedures on demand, validating large datasets, and troubleshooting end-to-end data flows
Java automation: triaging/fixing Java code on the fly and building/extending automation frameworks
API testing & integration testing
CI/CD, DevOps, and code quality practices
Experience in cloud environments (AWS preferred)
Experience in large enterprise-class systems
System design, development, and debugging
Requirements analysis and SDLC best practices
Back-end development and integration frameworks
Strong communication skills; able to explain complex technical issues clearly
Advanced knowledge of SDLC and Agile methodologies
Proven success integrating complex systems
Proficiency in Java, Python, JavaScript, or similar languages
Proficiency with AWS or Azure
Advanced SQL + relational/non-relational databases
Expertise with CI/CD tools and pipelines
Knowledge of TDD, BDD, and automated acceptance testing
Strong understanding of code quality and promotion practices
Bachelor's degree in Computer Science, IT, or related field (or 4 additional years of relevant experience)
5+ years of software development / testing experience
Preferred
GenAI / LLM testing (1–3 years), including chatbots, Claude / Lambda, and prompt workflows
Python automation
Health insurance / healthcare domain experience
Benefits
Health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans
Participation in a 401(k) plan
Company
ALTA IT Services, LLC
ALTA IT Services, LLC combines experience and expertise to deliver IT talent that meets and exceeds the expectations of our clients.