ETL QA Automation Engineer

Location: Charlotte, North Carolina – 3 days a week onsite

Experience Level: Senior (8+ Years)

Summary

We are seeking a senior-level ETL QA Automation Enineer to support the Cyber Data Operations team within ISDAD. This candidate will be involved in QA testing efforts, including designing and executing test cases for CyberDW and Cyber Data Dashboards. The role will identify, report, and track defects while participating in the creation and maintenance of regression test plans, test cases, and scripts. This position supports the delivery of reliable systems by identifying defects and verifying that requirements are met.

Responsibilities

1. Develop and execute test plans, test cases, and test scripts based on business and technical requirements.
2. Perform manual and automated testing across functional, regression, integration, and user acceptance phases.
3. Document defects clearly and collaborate with developers to resolve issues.
4. Ensure traceability of requirements and maintain test documentation. Participate in Agile Scrum calls with the CyberDW team and provide feedback on system usability and stability. Contribute to continuous improvement of QA processes and tools.
5. Identify, evaluate, and manage the documentation and deliverables required for each project testing and automation.

Skills & Qualifications

1. 8+ years of experience in Quality Assurance, Data Testing, ETL/ELT Testing, Data Engineering, or related disciplines.
2. 5+ years of experience leading QA efforts for enterprise data warehouse, data lake, or lakehouse platforms.
3. Strong hands-on experience with Databricks and testing data pipelines in cloud-based data platforms.
4. Advanced proficiency in SQL and Spark SQL for complex data validation, reconciliation, and root-cause analysis.
5. Hands-on experience with Python, PySpark, and Pandas for test automation, data validation, profiling, and analysis.
6. Hands-on experience testing and validating REST APIs using Postman or similar API testing tools.
7. Strong experience testing ETL/ELT pipelines, data transformations, and source-to-target mappings.
8. Experience designing and executing functional, integration, regression, system, performance, and user acceptance testing.