ETL Data Solutions Developer/ Designer - SSIS - Informatica

Job Title: ETL Data Solutions Developer/ Designer - SSIS - Informatica
Contract Type: Permanent
Location: London, England
Salary: £60000.00 - £65000 per annum + Plus bonus and benefits
Reference: BBBH17774_1519302278
Contact Name: Doug Collyer
Contact Email:
Job Published: February 22, 2018 12:24

Job Description

ETL Data Solutions Developer/ Designer - Financial Services - SSIS - Informatica - Oracle

A global Banking group are looking to hire a ETL focused Data Solutions Developer/Designer to working on upcoming projects and within a Data focused team that utilises SSIS, Informatica as well as Oracle and SQL Server.


  • Architect and design Data Warehouse infrastructure and solutions
  • Gather and analyse business requirements and develop technical specifications
  • Perform data profiling to detect patterns, trends and anomalies
  • Develop overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse
  • Effectively negotiate and influence project direction with alignment to data modelling and data management standards
  • Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions
  • Test, deploy and maintain Data Warehouses/Data Marts
  • Identifies, evaluates, and recommends emerging data technologies
  • Map existing or legacy logical entities to the Enterprise Data Warehouse
  • Develop dimensional models and views needed for data analytics and reporting
  • Design, develop and maintain target interface solutions to support Bank's OLTP and MI/BI systems

Required Skills:

  • ETL (Extraction, Transformation and Loading) experience required
  • In-depth PL/SQL knowledge to enhance and develop the data architecture required to support Oracle/SQL Server based applications and data warehouse environments essential.
  • Experienced in using modelling tools Erwin & ER/Studio Data Architect
  • Expert level of understanding of enterprise class ETL tools (SSIS/Informatica)
  • Strong quantitative and analytic skills are required. Proven ability to quickly earn the trust of key stakeholders
  • experience of exposure in banking industry working as Data Solution Architect / Data Modeller in the Banking domains
  • In-depth understanding of Financial Instruments that helps to translate data requirements into canonical DWH model
  • Extensive experience implementing relational database designs, data warehousing, data architecture, & data modelling, including strong knowledge of various data modelling approaches and practices
  • Hands-on experience with large/complex database implementations in Oracle and SQL Server