ETL Test Engineer at Telefonica Tech

London, England, United Kingdom -

Full Time

Start Date

Immediate

Expiry Date

26 Jan, 26

Salary

0.0

Posted On

28 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Azure Data Bricks, Azure ADF, Azure DevOps, SQL, DAX, Javascript, Typescript, Python, Pyspark, YAML, Powershell, Test Management Tools, Git, Azure Databricks, Power BI, Tableau

Industry

Telecommunications

Description

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 ETL Test Engineer The Test Engineer is accountable for the design and operational execution of the Data Quality framework, as well 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 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.

Responsibilities

The ETL Test Engineer is responsible for designing and executing the Data Quality framework while coordinating with technical and business resources. Responsibilities include creating test scenarios, developing validation scripts, and ensuring data accuracy across multiple systems.