Description
Developer Oracle-based DWH, ETL and BI for risk and issue reporting
We are looking for a Developer/engineer to improve an Oracle based datawarehouse, who is experienced in ETL and BI. In this role you will work as a Developer in the IT organization of Group Services Risk Management in a Busy DevOps team. This will be based in the busy heart of Amsterdam on a long term contract with an OPTION to go perm!
Further development and improving the current datawarehouse, and reporting functionality has been prioritised as a strategic objective. The current Oracle datawarehouse is being transformed, and Business Intelligence (BI) functionality is being developed, to feed dynamic reports by Cognos.
Your profile
Your key competences:
- A hands-on, and pro-active professional who can keep oversight of complex processes
- At least 5 years' experience with Oracle databases, datawarehouse, ETL and BI. In specific:
- You are capable to learn and oversee an entire datawarehouse. You are capable to re-design the data model of the current DWH, to efficiently support current reporting.
- You have experience with PL/SQL, eg you are able to develop new ETL procedures in PL/SQL and fine-tune existing PL/SQL code for efficiency and maintenance reasons
- You are capable to develop Data Marts (this will enable the building of interactive/BI reporting instead of our current static reports) and efficient and maintainable SQL queries
- You are capable to educate/instruct report builders how to configure their reports so that they get up and running and can carry out themselves
- From the perspective of your database knowledge and experience, you are capable to advice and support Operations engineers and other team members, eg during an upcoming transfer operation of the current Data Warehouse into the ING Private Cloud environment
- You are eager to learn, like to deep-dive technology, to search for root causes of issues and incidents, and to resolve them
- Team player.
Please send your CV to (see below) to be contacted for the next stage of the process.
Please note that if you are successful you will be contacted within 2-3 days, if you are not please assume you have not been successful on this occasion.