ETL / Business Intelligence Tester

  • Job Reference: PR/021530
  • Date Posted: 13 June 2022
  • Recruiter: E-Resourcing
  • Location: London
  • Salary: £55,000
  • Bonus/Benefits: 10% bonus + exceptional benefits
  • Sector: IT (general)
  • Job Type: Permanent
  • Work Hours: Full Time

Job Description

ETL / Business Intelligence Tester - permanent (£55,000 per annum plus 10% bonus)

Hybrid (3 days per week in office)

Exciting opportunity for a ETL / Business Intelligence Tester to join our global clients Data Warehouse Team. The ETL / Business Intelligence 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
  • Proficiency in Excel usage
  • Solid understanding of software testing concepts and methodologies
  • 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!