Datastage / ETL

Voor onze opdrachtgever zijn we op zoek naar een Datastage/ETL

Omschrijving

ING Domestic Bank Netherlands is building a state-of-the-art Data Lake. An ambitious project based on technologies like IBM InfoSphere (DataStage, TWS-D and Information Governance Catalogue), Netezza, Cognos and Hadoop.
We are looking for an experienced and energetic Business Intelligence / Data Warehouse / Data Lake engineer for one of our core teams.

Your job
As a DevOps engineer you will be working in a scrum content squad of 6-8 people consisting of three or four other DevOps engineers and two or three Customer Journey Experts. In addition there will be a Product Owner who decides on the priority of the user stories.
Your squad is responsible for data delivery to the Dutch Tax Authority and creating Year End Statements for all DBNL customers.
The squad is responsible for its own set of data. From the extraction of the data, either in real-time or through batches, up to the delivery of Data Marts for Cognos Reporting. Ultimate the squad creates the products for customers and Dutch Tax Authority.
You will be responsible for the analysis of the data and the build of the physical model at the various stages of the data pipeline: Operational Status, Information Warehouse and Data Marts. The physical modelling method used in our environment is what we call: ‘Key-Version’ modelling. It’s a mix between relational modelling and Data Vault. You will also model our Data Marts, using the Kimball Dimensional Model method. Having hands-on experience in using Type 3 (slowly changing) dimensions is a requirement.
Additional tasks working in the squad will consist of designing, developing, testing and deploying IBM Information Server artefacts, mainly involving DataStage, as well as developing new frameworks and packages using Cognos Analytics.
Also you work with Data marts and Oracle Warehouse Builder software on the old Helix environment that will be phased out but is still important as a data source. Also the team works with data files delivered by many other ING departments.
You and your fellow engineers are not only responsible for development, but also for maintaining and monitoring your applications which includes incident management and bug fixing. You will also be responsible for keeping the operational controls up to date which is a key part of the risk appetite within the bank.
Your activities start at analysis and end at operations. As such you are a true DevOps engineer!

Your work environment

Within ING our engineers work in multi-disciplinary teams based on the Agile methodology and DevOps principles. ING adopted the ‘Spotify’ model, which means that you are part of a matrix organization. You work in your squad but are also part of a chapter, an expertise-focused group that shares knowledge and creates and governs standards. Your chapter will be ‘Data Processing’.

Eisen

Qualifications

You recognize yourself in following profile.
Together with a minimum of 5 years of experience as a DevOps engineer in similar environments, we expect you to have had experience working with the following tools, techniques and way of working:

Required

• DataStage design and development (or similar ETL tooling)

• Data Modelling like, but not limited to Data Vault and Dimensional modelling

• Oracle Warehouse Builder and Unix experience is a must to be able to work and connect with the old environment

• Netezza, Oracle, SQL Server or similar databases

• Scheduling tools like TWS-d, AutoSys

• SQL

• Bash Scripting

• Fluent communication skills in English

Preferred

• GIT (or similar version control system)

• Reporting tools like, but not limited to Cognos Analytics, Business Objects

• InfoSphere Information Server Enterprise Edition suite components

• such as Information Governance Catalogue, Information Analyser

• Programming language like Java/Python

• Hive/Hadoop

• End-to-end delivery of data integration

• Both development and operations roles

You and your fellow engineers are not only responsible for development, but also for maintaining and monitoring your CI’s, this includes incident management and bug fixing. You will also be responsible for keeping the operational controls up to date which is a key part of the risk appetite within the bank.

Standplaats

Amsterdam

Start

10-12-2018 t/m 30-06-2019 met optie op verlenging.

Duur

3 maanden +