Data/ETL Test Automation Engineer - Aladdin

ZipRecruiter; London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading recruitment platform seeks a Data/ETL Test Automation Engineer in London to design and implement automated testing frameworks for data quality validation and ETL processes. Candidates should have strong experience in SQL and Python, with proficiency in handling large data sets. The role offers hybrid working with remote flexibility.

Qualifications

• Proven experience in designing and implementing automation frameworks for data quality checks.
• Proficiency in working with large data sets in XML, JSON, and CSV formats.
• Strong programming skills for querying and validating data using SQL.

Responsibilities

• Design, implement and maintain automated testing frameworks.
• Validate data transformations and mappings.
• Develop test cases and execute tests for various phases.

Skills

Designing automation frameworks

SQL

Python

Data quality validation

ETL processes

Tools

Azure DevOps

Jira

Job description

Job Description

Data/ETL Test Automation Engineer is required by my client ideally with experience of working on the Aladdin trading platform (or another investment banking trading platform) to work on a large scale Data Program. This client offers hybrid working, which will be mainly remote based with flexibility to be onsite in London (City) on an ad-hoc basis.

The role:

To be considered you must be a Test Automation Analyst/Engineer with strong technical data skills as you will be playing a pivotal role in the design, implementation and maintenance of automated testing frameworks for data quality validation, ETL processes, data mapping and reconciliations.

Essential experience:

• Proven experience in designing and implementing automation frameworks for data quality checks, data mappings, transformations, ETL processes, and reconciliation scripts using Python
• Proficiency in working with large data sets in XML, JSON, and CSV formats to validate data transformations and mappings.
• Strong knowledge of databases, SQL, ETL processes, and data warehousing concepts.
• Ability to interpret specifications, data maps, data models, and automated data conditions and validations.
• Solid experience in data preparation, input data feed analysis, developing test cases and executing tests for System Testing, System Integration, Functional, Regression and UAT phases for each release iteration.
• Strong programming skills for querying and validating data using SQL and Scripting.
• In-depth understanding of relational databases, data warehousing concepts, and ETL tools/processes.
• Knowledge of Azure DevOps (ADO), Jira and other test management tools, Agile and Waterfall methodologies, and wider test governance adherence.
• Strong communication skills; able to engage with senior stakeholders and work with a proactive, self starting attitude.

This is a great opportunity, please send your CV in the first instance and if relevant you will be contacted with full role and company information.

We are passionate about promoting , , and equality, and are committed to working with clients who share our outlook. We offer equal opportunities to all candidates regardless of background, , sexuality, and . We strive to create inclusive cultures where is seen as real value for the company. Our mission is for everyone to feel empowered to be their true authentic selves at work.