ETL Tester

ETL Tester

City of London Full-Time 55000 - 77000 £ / year (est.) No home office possible
Go Premium
V

At a Glance

  • Tasks: Join us as an ETL Tester, ensuring data quality and integrity through rigorous testing.
  • Company: Be part of a dynamic team focused on innovative data solutions.
  • Benefits: Enjoy competitive pay, flexible working arrangements, and opportunities for professional growth.
  • Why this job: This role offers hands-on experience with cutting-edge technology and a chance to impact business decisions.
  • Qualifications: 4+ years in data testing, a degree in a quantitative field, and SQL skills are essential.
  • Other info: Experience with Agile practices and test automation is a big plus!

The predicted salary is between 55000 - 77000 £ per year.

Rate: £275/day inside IR35

Requirements:

  • 4+ years of experience as a Data Warehouse Developer Tester or ETL Tester
  • Graduate degree preferred in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
  • Expert in understanding and implementing QA/Testing Lifecycle
  • Expertise in DB-related testing and ETL testing
  • Testing experience with reporting and BI tools
  • Writing basic SQLs to check record counts, data truncation, invalid data types, NULLs and data integrity, data transformation, aggregate functions testing
  • Expertise preferred in testing our current or a similar analytics stack
  • Experience in transforming complex Business logic into SQL or PL/SQL queries
  • Must be a self-starter with the ability to work on complex projects and analyse business requirements independently
  • Must be able to identify and document testing issues and quality risks, participate in defect remediation
  • Willingness to follow Agile Testing practices and guidelines, including Defect Management
  • Actively participate in all test management activities like assessment, test strategies and test plans
  • Knowledge of Database objects and relational data model
  • Experience in scripting
  • Test automation experience is a huge plus
  • Understanding of ETL requirements (source-to-target mappings)
  • Testing experience with different file types
V

Contact Detail:

Vallum Associates Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land ETL Tester

✨Tip Number 1

Familiarise yourself with the specific ETL tools and technologies that we use at StudySmarter. Having a solid understanding of our analytics stack will give you an edge during discussions and interviews.

✨Tip Number 2

Brush up on your SQL skills, especially in writing queries that check for data integrity and transformation. Being able to demonstrate your ability to handle complex business logic will impress us.

✨Tip Number 3

Showcase your experience with Agile Testing practices. We value candidates who can adapt to our workflow and contribute to test management activities, so be ready to discuss your past experiences in this area.

✨Tip Number 4

Prepare to talk about your problem-solving skills, particularly in identifying and documenting testing issues. We appreciate self-starters who can work independently and tackle complex projects, so highlight relevant examples from your past work.

We think you need these skills to ace ETL Tester

Data Warehouse Development
ETL Testing
Quality Assurance Lifecycle
Database Testing
SQL Proficiency
Data Integrity Checks
Business Logic Transformation
Defect Management
Agile Testing Practices
Test Management Activities
Relational Data Model Knowledge
Scripting Skills
Test Automation
Analytical Skills
Self-Starter Attitude

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience as a Data Warehouse Developer Tester or ETL Tester. Emphasise your expertise in QA/Testing Lifecycle and any relevant projects you've worked on that align with the job description.

Showcase Technical Skills: Clearly outline your technical skills, especially in DB-related testing, ETL testing, and SQL proficiency. Provide specific examples of how you've used these skills in past roles to demonstrate your capability.

Write a Compelling Cover Letter: Craft a cover letter that explains why you're a great fit for the role. Mention your self-starter attitude, ability to work independently on complex projects, and your willingness to follow Agile Testing practices.

Highlight Relevant Experience: In your application, focus on your experience with reporting and BI tools, as well as any test automation experience. Discuss how you've transformed complex business logic into SQL or PL/SQL queries in previous roles.

How to prepare for a job interview at Vallum Associates

✨Showcase Your Technical Skills

Be prepared to discuss your experience with ETL testing and data warehouse development. Highlight specific projects where you implemented QA/testing lifecycles and how you tackled challenges related to database testing.

✨Demonstrate SQL Proficiency

Since writing basic SQLs is crucial for this role, be ready to explain your approach to checking record counts, data integrity, and transformation. You might even be asked to write a simple query on the spot, so brush up on your SQL skills!

✨Understand Agile Methodologies

Familiarise yourself with Agile Testing practices, as this role requires adherence to these guidelines. Be prepared to discuss how you've participated in test management activities and how you handle defect management in an Agile environment.

✨Prepare for Scenario-Based Questions

Expect questions that assess your problem-solving abilities, especially regarding complex business logic and testing issues. Think of examples from your past experiences where you identified quality risks and how you documented and resolved them.

ETL Tester
Vallum Associates
Location: City of London
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

V
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>