Automation Test Engineer Python - Asset & Investment Management Python SQL ETL - Strike IT

Responsibilities

• Design, build and maintain automated test frameworks using Python
• Develop automated test scripts for ETL/ELT pipelines and data integration workflows
• Validate data movement across source systems, transformation layers and target platforms
• Write complex SQL queries to test data quality, transformation rules and reconciliation logic
• Build automated data reconciliation checks across portfolio, holdings, transactions and reference data
• Support testing of integrations into investment platforms such as Aladdin, CRD, SimCorp, OMS, PMS, IBOR or ABOR systems
• Perform regression testing across new and existing data pipelines
• Work closely with Data Engineers, Data BAs and business SMEs to understand data mappings and requirements
• Identify, investigate and document data defects, root causes and test evidence
• Support automation within CI/CD pipelines using tools such as Azure DevOps, Jenkins or GitHub Actions
• Contribute to test strategy, test planning and best practice around data quality and automation
• Experience Required
• Strong hands-on experience in Python test automation
• Good experience with Python testing frameworks such as PyTest, unittest or Robot Framework
• Strong SQL skills, including writing complex queries for data validation and reconciliation
• Experience testing ETL/ELT pipelines, data warehouses, data lakes or cloud data platforms
• Understanding of data quality, data mapping, reconciliation and regression testing
• Experience working with Azure-based data platforms, ideally including Azure Data Factory, Databricks, Data Lake or Synapse
• Exposure to tools such as Great Expectations, dbt tests, Soda, Pandas or PySpark would be beneficial
• Experience testing APIs/integrations using tools such as Postman, Swagger, requests or httpx
• Good understanding of CI/CD and automated testing within delivery pipelines
• Strong defect management, analytical and problem-solving skills
• Experience working within Agile delivery environments
• Financial Services experience is required; Asset/Investment Management experience would be highly beneficial
• Investment Data Experience Beneficial
• Experience testing or validating any of the following would be highly beneficial:
• Portfolio and holdings data
• Transactions and cash movements
• Security master and instrument reference data
• Positions and valuations
• Benchmarks and indices
• Client and mandate hierarchies
• IBOR/ABOR data
• Data from platforms such as Aladdin, CRD, SimCorp or other OMS/PMS platforms

Additional Information

We are supporting a leading organisation within the Investment Management sector that is looking for an Automation Test Engineer with Python to support a major investment data integration platform. The platform acts as an enterprise ETL and integration layer, connecting to front-to-back investment management systems and delivering standardised, high-quality investment data into a modern cloud environment. This role would suit a hands-on test automation engineer with strong Python, SQL and data testing experience, ideally gained within Asset/Investment Management or Financial Services. INSIDE IR35 HYBRID WORKING 2- 3 DAYS IN LONDON MUST HAVE ASSET/INVESTMENT MANAGEMENT EXPERIENCE

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at eFinancialCareers? Share your experience