QA Engineer

About the Role:

We are looking for a QA Engineer to join the Kestra Data Products team. The candidate will be responsible for validating data pipelines, data products, ETL processes, and reporting solutions to ensure high data quality, accuracy, and reliability. The role involves functional testing, data validation, defect management, RCA analysis, and collaboration with business and development teams in an Agile environment.

Requirements

Required Skills:

Data Testing

• Strong experience in Data Warehouse and ETL Testing.
• Experience validating large datasets and complex data transformations.
• Good understanding of data quality concepts and data validation techniques.
• Experience with data reconciliation and source-to-target validation.

SQL

• Strong SQL skills with the ability to write complex queries.
• Experience in data analysis and troubleshooting using SQL.
• Ability to validate data across multiple databases and tables.

Responsibilities

Key Responsibilities:

• Analyze business requirements, user stories, and acceptance criteria.
• Create and execute test cases, test scenarios, and test plans for data product initiatives.
• Perform end-to-end functional testing of Data Products and ETL pipelines.
• Validate data across source systems, staging layers, and target tables.
• Develop and execute SQL queries to verify data accuracy, completeness, and consistency.
• Perform data reconciliation and identify data quality issues.
• Investigate defects, perform Root Cause Analysis (RCA), and document findings.
• Maintain test execution results, defect logs, and QA documentation.
• Collaborate with Business Analysts, Data Engineers, Product Owners, and stakeholders.
• Participate in Agile ceremonies including sprint planning, grooming, standups, reviews, and retrospectives.

Benefits

Insurance 
Career Development 
Flexible Work hours 
Learning Opportunities
Inclusive and collaborative work culture