ETL Developer (Infrastructure Services) - Investment Bank

ZipRecruiter; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

A leading company in the financial sector is seeking an ETL Developer in London. The role involves developing infrastructure data processing solutions crucial for operational resilience. The successful candidate will work on data transformation and automation tasks, collaborating closely with a DBA.

Qualifications

• Experience in similar data capture projects, preferably in financial or complex sectors.
• Proficient in one or more ETL tools.
• Knowledge of SQL Server, Python, and Excel VBA (2019 minimum).

Responsibilities

• Develop scripts and ETL for data processing from various sources.
• Collaborate with a DBA to load data into SQL Server.
• Automate data ingestion processes.

Skills

Data Analysis

ETL Tools

RESTful APIs

Data Extraction

SQL Server

Python

Excel VBA

Job description

Job Description

A Bank, based in the City of London, is currently seeking an ETL Developer to help deliver infrastructure data processing solutions for the business.

The company is seeking an experienced ETL Application Developer with experience of Extract/Transform/Load, SQL Server and data-processing of infrastructure-sourced capacity metrics.

This role is critical to strengthening operational resilience by ensuring that the correct level of capacity monitoring is in place to highlight and mitigate potential system outages in a timely fashion to minimise potential disruptions.

Key tasks include;

• Developing scripts, and ETL to obtain such data from the providers and working with a DBA to load this data into SQL Server from an application server.
• This person will also help normalise raw infrastructure and monitoring data into structured formats suitable for graphing and trending
• Other tasks include automating regular data ingestion processing.

Key Skills;

• Demonstrate evidence of working on similar data analysis and capture projects in the financial or other sector of equal complexity.
• Strong proficiency in one or more ETL tools
• Strong proficiency in data extraction methods usingRESTful APIs
• Experience of extracting and transforming data from infrastructure management tools such as Nutanix Prism Central, VMware vCenter, Dell EMC Storage platforms (Unisphere), and OpManager desirable
• Experience with data storage platforms, Microsoft SQL Server in particular
• Knowledge and general understanding of suitable reporting and presentation frameworks
• Knowledge and general understanding of Python (for trending), SQL Server scripts (T-SQL), Excel VBA (2019 minimum)