Junior ETL Test Engineer

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, Enterprise Applications , 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

ROLE

We are looking for a Junior ETL Test Engineer who will thoroughly inspect our products before they’re launched.

As a Junior ETL Test Engineer in our company, you will work closely with the production team to understand why we’re building a product and what the specific requirements are. Then, you will run a series of tests through all stages of production to identify potential malfunctions and recommend improvements.

Ultimately, you’ll ensure our final products meet our quality standards.

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

• Develops validation scripts for automated execution, while creating actionable data quality

reports that measure trends over time.

• Monitoring the test pipelines

• 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.

• 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.

• Develop, documents and implements data quality standards.

• Regularly review and interprets QA results and findings with limited support from senior

leadership.

EXPERIENCE & SKILLS

• At least 2+ years related experience or equivalent combination of education and Consulting

experience.

• At least 2 years’ experience in large scale system implementation efforts following a standard

software development lifecycle approach (scrum desired).

• Experience with ETL testing

• 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.

Technical Skills:

• Experience in Azure Databricks and SQL queries - ability to analyse data in a Data

• Warehouse environment.

• Experience in test management tools – Devops, JIRA

• Experience in source control repositories – git (GitHub and bitbucket)

• Worked on testing reports (Power BI/ Tableau)

• Good understanding of the framework of ETL

• Experience working in a Scrum / Agile environment.

• Azure Data bricks

• Azure ADF

• Azure DevOps

• SQL

• DAX

• Javascript /Typescript

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.

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.