Full Description

Dreаmix was founded 19 years ago by passionate IT students, who wanted to create the dreamiest workplace where everyone is heard, works under transparent management, and lives up to their full potential. Now, many years later, we deliver software solutions for renowned companies from Germany, the UK, Switzerland, and Silicon Valley. Dreamix provides quality software services and products for top enterprises around the world through Java and Web technologies. We believe that the employer-employee relationship must be in the form of partnership not transaction. We are committed to investing as much as possible in our employees and we expect the same from you. Culture is what makes us different as we strongly believe in striving for mastery, teamwork, knowledge sharing, proactivity, a healthy lifestyle, and personal development. We are seeking an experienced Data QA Engineer with a strong manual testing background to take ownership of quality across our Data quality products. You will drive testing efforts, define test strategies, and act as a quality advocate across the engineering organisation. A key part of this role is providing clear, accurate, and timely reporting on test progress, quality risks, and defect status to support informed release decisions.

Responsibilities

• Validate end-to-end data pipelines from source systems to data marts.
• Test batch data loads.
• Validate transformations, aggregations, and derived metrics.
• Ensure data completeness, accuracy, and consistency across layers.
• Understanding of data governance, privacy, and PII handling
• Write complex SQL queries to validate fact and dimension tables in Redshift.
• Validate data models (fact/dimension, keys, relationships)
• Perform reconciliation between raw, curated, and reporting layers.
• Validate business KPIs and metrics against source systems and definitions.
• Validate data ingestion in S3 (file counts, schema, partitions, formats)
• Review Glue job and Lambda execution logs to troubleshoot data issues.
• Monitor pipeline health, failures, and data refresh SLAs.

Requirements

• Strong SQL skills (joins, aggregations)
• Hands-on experience testing data pipelines, ETL, or data warehouses

Experience with AWS services: S3, Glue, Lambda, Step Functions, Redshift, Athena, CloudWatch Experience validating structured and semi-structured data (Parquet, JSON, CSV) Solid understanding of data warehousing concepts and dimensional modelling 5+ years’ experience in software quality assurance with a strong focus on manual testing Proven experience testing complex web and/or mobile applications Familiarity with browser developer tools for debugging network, console, and UI issues Strong understanding of QA methodologies, SDLC, and Agile/Scrum Excellent test design, defect management, and reporting skills Experience with Jira, TestRail, or similar tools