[ad_1]

We are seeking applicants for the position of ETL Developer within the office of Data and Application Architecture (DAA). This is a full/part-time position based in Leiden, Netherlands.

The ETL Developer will be part of a project team. These project teams can have one or more Project Managers, Database administrators, ETL Developers, APEX developers and QlikView/Qlik Sense developers. The ETL developer will work with each of these roles to get the required results.

The ETL developer will get requirements and has to translate these into jobs in DataStage/InfoSphere. Part of the process is to get data from the source system and store it into the data warehouse, following Astellas BI standards and procedures. The data warehouse consists of different layers and the ETL Developer is responsible for getting data from the source system, into all the layers until getting the data into a data mart. One of the factors to take into account is that data comes from different regions and the Japanese kanji character set must also be dealt with because of that.

Working with SCD type 2 is needed as history is stored in one of the database layers.
There is also a need to create documentation. The ETL developer must create these as part of the project for the developed jobs. These jobs must be tested and tests must be documented.

DAA PLATFORM

• Oracle Enterprise server 11g data warehouse.
• IBM Datastage 11.5 for ETL.
• Oracle APEX for data entry purposes.
• QlikView, Qlik Sense and ThoughtSpot as data visualization tools.

[ad_2]

Source link