SDET/QA Engineers with ETL testing
Boston, MA (3days onsite) Need local only
Long Term
Contract
SDET/QA Engineers candidates with ETL testing and data validation, data ingestion, Python, SQL, AWS
• 8 years of experience in software QA, with at least 4–5 years focused on ETL testing and data validation.
• Strong hands-on experience in ETL testing for enterprise data integration platforms.
• Strong SQL skills, including complex queries, joins, subqueries, aggregations, and analytical functions.
• Hands-on experience developing and executing automated test scripts using Python.
• Experience validating data pipelines involving multiple source systems and target data platforms.
• Experience with AWS S3, including file-level validation and data ingestion testing.
• Strong understanding of data warehousing concepts and layered data architecture.
• Experience testing data across Landing, Raw, Prepared, and Curated layers.
• Experience with full load, incremental load, and historical data processing validation.
• Experience in test case design, test execution, defect management, and regression testing.
• Strong analytical, troubleshooting, and communication skills.
Good-to-Have Skills
• Exposure to Xray for Jira or similar test management tools.
• Experience setting up and managing test plans, test cases, test executions, and test reporting in Xray.
• Exposure to integrating automated test scripts and execution results with Xray/Jira.
• Familiarity with broader QA automation frameworks and practices.
• Experience with Python-based automation frameworks such as Pytest.
• Hands-on experience with SnapLogic pipeline testing.
• Experience with Control-M job scheduling and workflow orchestration.
• Experience with Snowflake, including SQL-based data validation.
• Familiarity with dbt and transformation testing.
• Knowledge of data quality frameworks and tools.
• Experience with CI/CD-based automated test execution.
Qualifications
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Ability to work independently in a distributed offshore/onshore delivery model.
• Strong collaboration skills and ability to work with developers, data engineers, and QA teams.
• Ability to understand complex data flows and translate business requirements into effective test scenarios.
Key Expectations
The selected candidate is expected to be hands-on and capable of independently:
1. Understanding end-to-end ETL workflows and data movement.
2. Designing comprehensive test cases for each data processing layer.
3. Developing Python and SQL-based automated test scripts.
4. Executing automated and manual ETL test scenarios.
5. Validating data accuracy and completeness across source, S3, and target layers.
6. Testing Control-M workflow execution, dependencies, and recovery scenarios.
7. Using or supporting test management platforms such as Xray to organize and track test cases.
8. Contributing to the setup and improvement of automated testing practices that can be reused across ETL and other QA initiatives
Munesh
,
CYBER SPHERE LLC