At a Glance
- Tasks: Join us to ensure data quality through testing and collaboration with diverse teams.
- Company: Telefónica Tech, a leading NextGen Tech solutions provider with a global presence.
- Benefits: Inclusive culture, diverse teams, and opportunities for professional growth.
- Other info: Embrace diversity and be part of a team that values your authentic self.
- Why this job: Make an impact in digital transformation while working with cutting-edge technologies.
- Qualifications: 5+ years in ETL testing, experience with Azure and Python preferred.
The predicted salary is between 50000 - 60000 £ per year.
Company Description
Telefónica Tech (part of the Telefónica Group) is a leading NextGen Tech solutions provider with a highly diversified team of over 6,000 exceptionally skilled 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. Global strategic hubs: Spain, Brazil, the UK, Germany. 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
- Analysing Business requirement for completeness and accuracy
- Analysing 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
- Analysing 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
- Candidate will be involved in both automated and manual ETL testing across multiple scrum teams, although most of the testing will be 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 automated ETL tests using Pyspark/Python
- Ability to write manual test cases from business requirements and technical specifications.
- Ability to create data bricks 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 metrics.
- 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 also 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. 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: Telefonica Tech
Telefónica Tech is an exceptional employer, offering a dynamic work environment in Glasgow where innovation meets collaboration. Employees benefit from comprehensive training and development opportunities, fostering personal and professional growth while working on impactful projects that shape the digital landscape. With a strong commitment to employee well-being and a vibrant team culture, Telefónica Tech stands out as a rewarding place to advance your career in technology consulting.
StudySmarter Expert Advice🤫
We think this is how you could land ETL Test Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Telefonica Tech!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like ETL Test Engineer at Telefonica Tech.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Telefonica Tech.
✨Apply Directly through Our Website
When you find a suitable opening like ETL Test Engineer at Telefonica Tech, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace ETL Test Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Telefonica Tech, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Telefonica Tech. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Telefonica Tech
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Telefonica Tech!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
