At a Glance
- Tasks: Join us to design and execute 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 supportive community.
- Why this job: Make an impact on digital transformation with innovative tech solutions.
- Qualifications: 5+ years in ETL testing and experience with Agile methodologies.
The predicted salary is between 50000 - 60000 € 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.
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 ADF
- 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. 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 in London employer: Telefónica Tech (EN)
Telefónica Tech is an exceptional employer that fosters a diverse and inclusive work culture, empowering over 6,000 employees from more than 60 nationalities to thrive in their roles. With a strong commitment to employee growth, we offer numerous opportunities for professional development and collaboration across global teams, particularly within our UK&I hub, where innovation meets cutting-edge technology solutions. Join us to be part of a trusted partner network and contribute to meaningful projects that drive digital transformation.
StudySmarter Expert Advice🤫
We think this is how you could land ETL Test Engineer in London
✨Tip Number 1
Network like a pro! Reach out to current employees at Telefónica Tech on LinkedIn. Ask them about their experiences and any tips they might have for landing a role. Personal connections can make all the difference!
✨Tip Number 2
Prepare for those interviews! Brush up on your ETL testing knowledge and be ready to discuss your experience with tools like Azure Data bricks and SQL. We want to see how you can contribute to our team!
✨Tip Number 3
Show off your skills! If you’ve got a portfolio or examples of your work, bring them along to the interview. Demonstrating your expertise in creating test cases or developing validation scripts can really set you apart.
✨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 our awesome team at Telefónica Tech!
We think you need these skills to ace ETL Test Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the ETL Test Engineer role. Highlight your experience with test management tools, Azure, and any relevant programming languages like Python or SQL.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about data quality and how your background makes you a great fit for our team. Be bold and let your personality shine through!
Showcase Your Projects:If you've worked on any relevant projects, especially involving ETL testing or data quality frameworks, make sure to mention them. We love seeing real-world applications of your skills!
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’s super easy!
How to prepare for a job interview at Telefónica Tech (EN)
✨Know Your Tech Stack
Familiarise yourself with the technical skills mentioned in the job description, especially Azure Data bricks, Azure ADF, and SQL. Be ready to discuss your experience with these tools and how you've used them in past projects.
✨Showcase Your Testing Experience
Prepare examples of your experience in ETL testing and how you've automated tests using Python or Pyspark. Highlight specific challenges you faced and how you overcame them, as this will demonstrate your problem-solving skills.
✨Understand Agile Methodologies
Since the role involves working in a Scrum/Agile environment, brush up on Agile principles and be prepared to discuss your experience in sprint ceremonies and defect triage. This shows that you can adapt to their workflow seamlessly.
✨Communicate Clearly
Strong communication skills are essential for this role. Practice explaining complex technical concepts in simple terms, as you'll need to collaborate with various teams. Clear communication can set you apart from other candidates.
