ETL Developer (Infrastructure Services) - Investment Bank
Posted 5 days ago by Sterlings
Negotiable
Undetermined
Undetermined
City Of London, England, United Kingdom
Summary: A Bank in the City of London is seeking an experienced ETL Developer to deliver infrastructure data processing solutions. The role focuses on Extract/Transform/Load processes, SQL Server, and capacity metrics to enhance operational resilience and minimize system outages. Key responsibilities include developing scripts for data extraction and automation of data ingestion processes. The ideal candidate will have a strong background in data analysis within the financial sector or similar complexity.
Key Responsibilities:
- Develop scripts and ETL processes to obtain data from providers.
- Collaborate with a DBA to load data into SQL Server from an application server.
- Normalize raw infrastructure and monitoring data into structured formats for graphing and trending.
- Automate regular data ingestion processing.
Key Skills:
- Experience in data analysis and capture projects in the financial sector or similar complexity.
- Strong proficiency in one or more ETL tools.
- Proficiency in data extraction methods using RESTful APIs.
- Experience with infrastructure management tools such as Nutanix Prism Central, VMware vCenter, Dell EMC Storage platforms, and OpManager.
- Knowledge of data storage platforms, particularly Microsoft SQL Server.
- Understanding of reporting and presentation frameworks.
- General understanding of Python, SQL Server scripts (T-SQL), and Excel VBA (2019 minimum).
Salary (Rate): undetermined
City: City Of London
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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)