Senior ETL Quality Assurance Engineer

$89,114 - $115,000/Yr

Kehe Food Distributors - Naperville, IL

Full-time - Senior

Naperville, IL

Merchant Wholesalers, Nondurable Goods

About the position

KeHE, a natural, organic, specialty and fresh food distributor, is seeking a Senior Quality Assurance Engineer to lead comprehensive testing efforts on the business intelligence side. This role serves as the technical expert in ETL testing using AWS, SSRS, and dashboard testing, as well as API and performance testing. The Senior Quality Assurance Engineer will ensure that KeHE products meet established quality standards and regulatory requirements while identifying potential risks to product quality. The position is part of a people-first culture committed to good living, good food, and good service.

Responsibilities

• Establish and maintain quality assurance standards and procedures.
• Design, create, implement, and write detailed and comprehensive test plans for products.
• Conduct tests to identify software defects and ensure product quality standards are met.
• Perform inspections and audits to ensure compliance with standards.
• Oversee the entire testing lifecycle from start to finish and perform manual and automated testing.
• Document test cases, test results, and quality standards along with preparing and presenting reports on quality metrics.
• Maintain detailed records of tests and inspections and implement corrective actions to address quality issues.
• Collaborate with development teams to resolve issues.
• Analyze data to identify areas for quality improvement and recommend and implement process improvements.
• Design test cases based on functional and non-functional requirements.
• Conduct regression testing to ensure changes were implemented.
• Review design specifications for testability and participate in code reviews.
• Set up test environments (software configurations) at various levels of testing.
• Manage testing tools and ensure their proper utilization.
• Communicate effectively with developers, product managers, and other team members.
• Participate in project meetings to provide quality assurance insights.
• Other duties and projects as assigned.

Requirements

• Bachelor's degree in Information Technology or a related field.
• Minimum of 7+ years of experience in ETL testing.
• Experience in testing SSRS reports, BI dashboards, and similar tools.
• Experience in API testing using tools such as Postman or similar and defect management tools such as JIRA.
• Experience working with ETL tools such as AWS Glue, Informatica, Ab Initio, SSIS, or DataStage (or similar tools).
• Experience automation data testing using Java (BDD Framework), Python or equivalent.
• Strong understanding of business intelligence and ETL processes and requirements.
• Proficiency in understanding ETL data flow and mapping documents.
• Ability to utilize extensive SQL queries to validate data across source, staging, and target systems.
• Understanding of ETL testing processes, testing, and how to evaluate results.
• Ability to work independently and in a team environment.

Nice-to-haves

• Certifications such as AWS, CSTE, CSQE, or CCP are preferred.

Benefits

• Health/Rx
• Dental
• Vision
• Flexible and health spending accounts (FSA/HSA)
• Supplemental life insurance
• 401(k)
• Paid time off
• Paid sick time
• Short term & long term disability coverage (STD/LTD)
• Employee stock ownership (ESOP)
• Holiday pay for company designated holidays