We make and run software for companies across a variety of industries – with roots in banking/finance, the company has continuously evolved, expanding into sports betting, gaming, healthcare and the civil service.

What’s the opportunity?

We are looking for a Data Warehouse QA Analyst to assess the quality of large volumes of data, by employing both manual and automated test techniques. In this role, a successful candidate will be responsible for finding and reporting defects in the product and in design/development artefacts. The ideal candidate should have a keen eye for detail, excellent communication skills and be comfortable with SQL and with ETL/ELT methodologies. If you meet these requirements and are passionate about quality, we would like to meet you.

Responsibilities:

• Validate the data sources, extract the data, apply systematic permutations of transformation logic, load the data into the target tables, and validate the integrity of the loaded data.
• Run ETL/ELT tests such as data quality testing, metadata testing, source-to-target count testing, source-to-target data testing, performance testing, data transformation testing, data integration testing, production validation, report testing.
• Create test cases and execute test plan and test suite runs.
• Carry out retesting of defects that have been fixed.
• Carry out regression testing in the impact scope of changes made to the product.
• Carry out static testing on the software design/development artefacts made available and identify missing requirements, deviations from standards, design defects, inconsistent interface specifications etc.
• Coordinate with the test manager in carrying out the various day-to-day tasks.

Required Skills:

• Strong understanding of the SDLC and of Agile methodologies.
• Knowledge of or experience with ETL/ELT practises.
• Experience in writing complex SQL queries.
• Experience in tuning SQL queries, stored procedures, views, etc. for performance improvements.
• Hands-on knowledge of data models and entity relationship diagrams
• Familiarity with architectural components such as EDW, ODS, DM, OLAP, OLTP, etc.
• A propensity to explore and understand complex software systems.
• Strong understanding of black-box testing techniques.
• A firm grasp of the English language, and of English orthography.
• Manual functional testing experience (preferably with web applications).
• Experience with a programming/scripting language (C# or Python preferred).

Desirable skills:

• ISTQB-CTFL certification, or equivalent.
• White Grey-Box testing experience.