ETL Developer - Perm

  • GBP60000 - GBP70000 per annum + Benefits
  • London, England, United Kingdom London England GB
  • Permanent, Full time
  • Skillfinder International
  • 13 Jun 18 2018-06-13

This role will focus on delivering all the data requirements for the ALM business- Design and build end to end robust ETL solutions that can handle different data types, like XML, csv, web services.

We are urgently looking for an experienced ETL Developer to join a well known investment bank in London.

The ideal candidate should ideally come from an investment banking background and hands on experience working in a challenging environment.

We offer an excellent salary package as well as fantastic progression opportunities.

Responsibilities:

-Design and build end to end robust ETL solutions that can handle different data types, like XML, csv, web services, database sources.

-Work with end users and analysts on requirements and translate them into technical specification, provides estimation to the management

-Support existing ALM systems, where required reverse engineer and improve processes

Follow and contribute to, departmental development process in terms of standards, methodologies, testing, version control and documentation, mentor junior members, drive and implement industry best practises, evaluate and introduce new tools, design and improve existing ETL framework, data validation framework

Technical Requirements:

-Microsoft SQL Server 2005/2008/2008R2/2012/2014, performance tuning, backup and recovery, data encryption, capacity planning, understanding of database engine internals and all database objects. Experience of loading data from different sources - xml, csv, excel, web services, different databases, MQ messages etc.

-Extensive experience of using SSIS, script tasks, custom plugins

-Understanding of Kimball methodology, ODS design principles and 3rd normal form.

-Post release support of deployed solutions

-Experience of working with data in different formats and different data specifications, i.e. XML, XSD, XSLT, JSON, Excel spreadsheets, etc.

-Experience of putting robust checks and controls, implementing auditing of data, quality controls, etc.

-Experience of working in a team following agile development practices, using team development tools, working on the same objects, sprint planning and backlog review.

-Wide knowledge of other tools, vendors, solutions available on the market and applicable to BI space, upcoming releases of new software packages, etc.


If you are keen to discuss this role in more detail please contact us urgently.