ING wants to be an innovative bank, so we need people who are real innovators. Because within ING or people are the engine for ING s growth and success.
The international project Model Bank is multi-cultural and cross-business, and is developing a borderless, scalable, retail platform uniting Spain, Italy, France, Czech Republic and Austria.
We offer the position ETL Mapping Analyst within the Model Bank project based in Madrid.
Model Bank in collaboration with the MB countries (Spain, Italy, France and Czech Republic) aims to deliver :
A retail harmonized digital platform (with 60% to 90% harmonization), fully focused on supporting the MB countries in increasing customer interaction, improving customer satisfaction and increasing sales
A scalable platform which can be extended to on-board additional countries, products and services in future;
An agile, central IT shared service center that can develop, maintain and run digital requirements going forward
A high level of standardization and centralization across systems, processes, data and way of working aligned with Enterprise Architecture, Global Process Management, Global Data Management and Bank Infra
As an ETL Mapping Analyst you will support the initiative in the process of mapping Data Lake data structures to other Datamarts and systems.
This task implies a good understanding of Business as well as of Data Models and ETLs.
Define reusable SQL Extraction Patterns from IWH (BDW Classification Model) to feed other Dimensional Datamarts
Documenting extraction logic from IWH (BDW) for each requirement
Validating extraction patterns on DEV environment
Knowledge transfer of data warehouse structures to ETL teams
Support and supervise ETL Delivery Teams by ensuring proven development best practices and governance processes are applied
Support Reporting Teams and other parties in understanding data models
Good English language skills, able to work on call with remote teams
Proactive, able to take ownership and involve and engage other stakeholders when required. Able to report to Program Management
Agile WoW (Scrum or similar) nice to have
Knowledge and experience
We are looking for an experienced ETL / DWH Architect or Designer with relevant background in Data Warehousing and Business Intelligence
ETL tooling experience, preferably Data Stage. Experience in ETL design for Data Lineage
Work experience with Key-Value Stores and Classification models is a plus
Knowledge of Banking Industry is a plus
Knowledge of IBM BDW and Data Lake paradigm is a plus
Tecnología : Temporalidad