ETL Test Engineer

ROLE

You will be working from Office in India collaborating and socialising with your colleagues across our two UK and Bulgaria Offices.

Occasionally we would need your help outside of normal office hours (you might be required to work on the weekend or to be on-call at times).

The Data Quality Analyst 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.

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.
• Regularly review and interprets QA results and findings with limited support from senior leadership.

Qualifications :

• At least 3 years related experience or equivalent combination of education and Consulting experience.
• At least 3 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.

Must Have 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 writing Python scripts.
• 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.

Nice to Have Skills:

• Experience in understanding and writing DAX queries.

Technical Skills:

• Azure Data bricks
• Python/Pyspark
• Azure ADF
• Azure DevOps
• SQL
• DAX
• Javascript/Typescript

Additional Information :

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

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

Remote Work :

No

Employment Type :

Full-time