Description
Objective:
The Business Intelligence team at my client, an international Bank based in Brussels, is in charge of the development of Management Reports. The team already comprises Business Analysts and Designers - now we are looking for a Senior Developer: you must have strong Datastage development skills and experience (up to version 8.7). Candidates from other industries (non-financial sector) will also be considered.
Tasks:
Design the technical ETL solution (Define the technical interface, specs for the source systems, the ETL processes from landing zone till storage) and develop the solution with IBM DataStage.
Design the physical relational datamodel in collaboration with the DBA.
Define the scheduling requirements for ETL processes in the data warehouse.
Develop & test (unit test, functional test and data profiling) the ETL processes.
Prepare the releases & installation instructions.
Collaborate with the users to build them the adequate reporting in Cognos.
Your main responsibilities will be to drive Business Intelligence developments.
Based on your depth knowledge of both Business and Business Intelligence you will act as catalyst in order to identify pragmatic solutions.
You will identify the right balance between Cost and Quality/Completeness.
You should be able to design the data model in a data warehouse context (Dimensional Datamodelling for data warehouse and data-mart applications).
Skills/Experience:
Essential:
Minimum 5 years experience in total of IBM Datastage (including some recent knowledge of version 8.7), Sybase IQ (15.4).
Nice to have but not essential:
Cognos BI (10.1) and experience in Agile development such as SCRUM methodology.
Language: English.