This Job Vacancy has Expired!

ETL Tester

e-resourcing Limited

Posted on Sep 22, 2022 by e-resourcing Limited

London, United Kingdom
IT
Immediate Start
Annual Salary
Full-Time

ETL + Data Tester - permanent (£55,000 - £60,000 per annum plus 10% bonus)

Hybrid (3 days per week in office)

ETL/Test/Data/Business Intelligence/SQL/Data Warehouse/Automation

Exciting opportunity for an ETL + Data Tester to join our global clients Data Warehouse Team. The ETL and Data Tester will be responsible for defining and executing tests on our BI (Business Intelligence) and reporting platform. You will be expected to be able to follow and validate the data through the ETL process, interrogate the relevant databases using queries to ensure data integrity, consistency and accuracy.

  • Test planning and execution: create, enhance and maintain effective and high-value test scenarios for report testing
  • Understand and work with the requirements from technical and business specifications
  • Interrogate tables in different RDBMS databases: DB2, MySQL, SQL Server, Aurora and Redshift or similar
  • Data preparation, data loads for journaling or ETL and processing in the test environments
  • Carry out end-to-end, data completeness and quality, regression testing, including standard data validation and ensure data maintains integrity at all stages of transformation (ETL) and data flow
  • Data reconciliation in BI reports by means of reports comparison and by executing SQL queries
  • Contribute to the overall test strategy with ideas of tools and technologies, including the use of automated testing
  • Using JIRA to track defects and tasks
  • Assist business test team in UAT

Skills and experience

  • Software Testing experience within SDLC,
  • Data Warehouse (DWH), ETL and Business Intelligence (BI) testing experience
  • Strong experience of relational databases and SQL, ability to write involved SQL queries to extract and validate data
  • Hands-on experience of test planning, execution and maintenance of test scenarios
  • Test automation experience related to large data comparison, migration and ETL using Python (or similar)

If you are a keen data and ETL tester, want to learn new technologies, have a tenacious & pragmatic approach to testing then this could be the role for you!

Reference: 1737157380

Set up alerts to get notified of new vacancies.

Similar Jobs

Data/ETL Tester

Stafford, Staffordshire, United Kingdom

Annual Salary