ETL Test Engineer

ETL Test Engineer

Full-Time 60000 - 75000 £ / year (est.) Home office (partial)
Telefónica Tech (EN)

At a Glance

  • Tasks: Join us in designing and executing a cutting-edge Data Quality framework.
  • Company: Telefónica Tech, a global leader in NextGen Tech solutions.
  • Benefits: Inclusive culture, diverse team, and opportunities for professional growth.
  • Other info: Embrace diversity and be part of a dynamic, collaborative environment.
  • Why this job: Make an impact on digital transformation with innovative tech solutions.
  • Qualifications: 5+ years in ETL testing and experience with DevOps tools.

The predicted salary is between 60000 - 75000 £ per year.

Telefónica Tech (part of the Telefónica Group) is a leading NextGen Tech solutions provider with a diversified team of over 6,000 employees and +60 nationalities. We serve more than 5.5m customers every day in over 175 countries, with a global ecosystem of market-leading partners.

The Telefónica Tech UK&I hub has an end-to-end portfolio of market leading services and develops integrated technology solutions to accelerate digital transformation through: Cloud, Data & AI (Adatis), Enterprise Applications (Incremental), Workplace Services and Cyber Security & Networking.

Values: Open, Trusted and Bold

Trusted Partners:

  • Microsoft: Top 3 Service Providers, Azure Expert Status, Fastrack & Inner Circle Partner
  • HPE: Platinum Partner – FY23 UK&I Solution Provider of the Year
  • Palo Alto & Crowdstrike: part of our NextDefense Cyber Security Portfolio
  • Fortinet: Elite VIP Program – one of only 2 in the UK
  • AWS: Advanced Solution & Managed Service Provider Program

Job Description: The Data Quality Analyst is accountable for the design and operational execution of the Data Quality framework, as well as coordination across all technical and business resources throughout the test. Responsibilities include creation and maintenance of quality assurance testing deliverables and assisting in delivery activities.

General Responsibilities:

  • Analyzing business requirements for completeness and accuracy
  • Analyzing business requirements against the technical specifications (data modelling)
  • Creating high level test scenarios
  • Creating manual test cases
  • Developing validation scripts for automated execution, while creating actionable data quality reports that measure trends over time
  • Developing YAML code to create DevOps pipelines and maintain them
  • Analyzing test outputs and reporting defects
  • Working closely with Business Analysts, Data Analysts/Scientists, Development, and Product Owners to ensure data housed in multiple source systems is valid and accurate
  • Participating in defect triage and sprint ceremonies
  • Involvement in both automated and manual ETL testing across multiple scrum teams, with most testing automated
  • Participation in architecting the logical design of data quality practices with the technical team, including DQ design and specifications, data modelling, and documentation of logical processing flows
  • Agile testing
  • Developing documents and implementing data quality standards
  • Regularly reviewing and interpreting QA results and findings with limited support from senior leadership

Technical Skills:

  • Azure Data bricks
  • Azure AD
  • Azure DevOps
  • SQL
  • DAX
  • Javascript/Typescript
  • Python/Pyspark
  • YAML
  • Powershell

Qualifications:

  • Key Skills - Must have: Experience in test management tools – Devops, JIRA
  • Must have: Experience in source control repositories – git (github and bitbucket)
  • Nice to have: Experience in Azure Databricks, Python/Pyspark, YAML and SQL queries - ability to analyse data in a Data Warehouse environment
  • Nice to have: Experience in understanding and writing DAX queries
  • Nice to have: worked on testing reports (Power BI/ Tableau)
  • Good understanding of the framework of ETL
  • Experience working in a Scrum / Agile environment

Minimum Requirements:

  • At least 5+ years related experience or equivalent combination of education and consulting experience
  • At least 5 years’ experience in large scale system implementation efforts following a standard software development lifecycle approach (scrum desired)
  • Experience with ETL testing
  • Ability to automate ETL tests using Pyspark/Python
  • Ability to write manual test cases from business requirements and technical specifications
  • Ability to create Databricks notebooks to automate the manual tests
  • Ability to create and run test pipelines and interpret the results
  • Ability to test complex reports and write queries to check each metric
  • Strong oral and written communications skills

Additional Information: At Telefónica Tech, we believe inclusion is the bridge that empowers everyone to be their authentic selves. We celebrate and respect our differences because diversity drives innovation and makes us stronger. Be yourself with us, and feel that you belong.

We welcome applicants from all backgrounds and identities regardless of age, disability, gender reassignment, marital or civil partnership status, pregnancy or maternity, race, religion or belief, sex, and sexual orientation.

We are committed to equity, accessible hiring practices, and creating an inclusive culture through many means including TogetHer (Women's network) and our Employee Resource Groups which include Diversity and Inclusion, Telefónica Tech Pride, Neurodiversity, ELEVATE (African and Caribbean heritage network), and Sustainability.

Note: We don’t believe hiring is a tick box exercise, so if you feel that you don’t match the job description 100%, but would still be a great fit for role, please get in touch.

ETL Test Engineer employer: Telefónica Tech (EN)

Telefónica Tech is an exceptional employer that champions diversity and inclusion, fostering a vibrant work culture where every employee can thrive. With a commitment to professional growth, employees benefit from access to cutting-edge technology and collaborative projects that drive digital transformation across the globe. Located in the UK&I hub, team members enjoy a dynamic environment that encourages innovation and offers opportunities to work with leading partners in the tech industry.
Telefónica Tech (EN)

Contact Detail:

Telefónica Tech (EN) Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land ETL Test Engineer

Tip Number 1

Network like a pro! Reach out to current employees at Telefónica Tech on LinkedIn. A friendly chat can give you insider info and might just get your foot in the door.

Tip Number 2

Prepare for the interview by brushing up on your ETL testing skills. Be ready to discuss your experience with tools like Azure DevOps and SQL, as well as how you've tackled data quality issues in the past.

Tip Number 3

Show off your problem-solving skills! During interviews, share specific examples of how you've approached challenges in previous roles, especially in Agile environments.

Tip Number 4

Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining the team.

We think you need these skills to ace ETL Test Engineer

Data Quality Framework Design
Test Management Tools (DevOps, JIRA)
Source Control Repositories (Git, GitHub, Bitbucket)
Azure Databricks
Python/Pyspark
YAML
SQL Queries
DAX Queries
ETL Testing
Agile Methodologies
Manual Test Case Development
Automated Test Execution
Data Analysis in Data Warehouse
Communication Skills

Some tips for your application 🫡

Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with ETL testing and the specific tools mentioned in the job description. We want to see how your skills align with what we're looking for!

Showcase Your Technical Skills: Don’t forget to emphasise your technical expertise, especially with Azure, SQL, and Python/Pyspark. We love seeing candidates who can demonstrate their knowledge of these tools in real-world scenarios.

Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to see your key achievements and skills at a glance.

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you're keen on joining our team!

How to prepare for a job interview at Telefónica Tech (EN)

Know Your ETL Basics

Before the interview, brush up on your understanding of ETL processes and frameworks. Be ready to discuss how you've applied these in past roles, especially in relation to data quality and testing. This will show that you’re not just familiar with the terms but can also apply them practically.

Showcase Your Technical Skills

Make sure to highlight your experience with tools like Azure Databricks, SQL, and Python/Pyspark during the interview. Prepare specific examples of how you've used these technologies to automate tests or improve data quality. This will demonstrate your hands-on expertise and problem-solving abilities.

Prepare for Agile Discussions

Since the role involves working in a Scrum/Agile environment, be prepared to discuss your experience with Agile methodologies. Think of examples where you participated in sprint ceremonies or collaborated with cross-functional teams. This will illustrate your adaptability and teamwork skills.

Ask Insightful Questions

At the end of the interview, don’t forget to ask questions that show your interest in the company and the role. Inquire about their current data quality challenges or how they measure success in their ETL processes. This not only shows your enthusiasm but also helps you gauge if the company is the right fit for you.

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

>