Data ETL Test Automation Engineer - Aladdin/Trading experience required
Posted 3 days ago by Logic Engagements Ltd
£450 Per day
Outside
Hybrid
Remote & City, London office on an ad-hoc basis, UK
Summary: The Data ETL Test Automation Engineer role requires expertise in Aladdin or trading systems within investment banking to support a large-scale data program. The position involves designing, implementing, and maintaining automated testing frameworks for data quality validation and ETL processes. The role offers hybrid working, primarily remote with occasional onsite presence in London. Strong collaboration with development and operations teams is essential to ensure high software quality standards.
Key Responsibilities:
- Design, implement, and maintain automated testing frameworks for data quality validation, ETL processes, data mapping, and reconciliations.
- Collaborate with development, product, and operations teams to identify potential issues early in the development process.
- Interpret specifications, data models, and mapping documents to develop automated data validation scripts.
- Prepare data, analyze input data feeds, and develop test cases for various testing phases including System Testing, Integration, Functional, Regression, and UAT.
- Engage with senior stakeholders and maintain proactive communication throughout the project lifecycle.
Key Skills:
- Proven experience in designing and implementing automation frameworks using Python or equivalent programming languages.
- Experience testing trading systems like Aladdin or in an investment banking environment.
- Proficiency with large data sets in XML, JSON, and CSV formats.
- Strong knowledge of databases, SQL, ETL processes, and data warehousing concepts.
- Ability to interpret specifications, data maps, and automated data conditions.
- Solid experience in data preparation and executing tests across various testing phases.
- Strong programming skills for querying and validating data using SQL and scripting.
- In-depth understanding of relational databases and ETL tools/processes.
- Knowledge of Azure DevOps, Jira, Agile and Waterfall methodologies.
- Strong communication skills with a proactive, self-starting attitude.
Salary (Rate): £450 per day
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Data ETL Test Automation Engineer is required with previous Aladdin or Trading systems/investment banking testing experience by my client 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 Data/ETL Test Automation Analyst/Engineer with good experience of working on Aladdin and/or another Trading systems 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.
You will work closely with development, product and operations teams to identify potential issues early in the development process and ensure that the software meets the highest standards before release. This role demands a strong focus on automated data validation, a deep understanding of software architecture, and the ability to work in a fast-paced, collaborative environment. You will be responsible for designing and building scalable automation frameworks for validating data quality, data transformations, mappings, ETL workflows, and reconciliation logic. You will also be required to interpret specifications, data models, and mapping documents to design and develop automated data validation scripts.
Essential experience:
- Proven experience in designing and implementing automation frameworks for data quality checks, data mappings, transformations, ETL processes, and reconciliation scripts using Python or equivalent programming languages.
- Experience of testing Trading systems like Aladdin or within an investment banking trade environment.
- 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 diversity, inclusion, and equality, and are committed to working with clients who share our outlook. We offer equal opportunities to all candidates regardless of background, identity, sexuality, and disability. We strive to create inclusive cultures where diversity is seen as real value for the company. Our mission is for everyone to feel empowered to be their true authentic selves at work.