Description
PowerCenter/ETL Developer - Senior
Project/Department Description and responsibilities:
- Pharma RandD IT, Data Services and Business Intelligence team.
Environment Development Tool(s) and Platform(s):
- Windows OS
- Informatica PowerCenter 9.1 (Designer, Workflow Monitor, Workflow Manager, Repository Manager)
- Oracle 11 R2 (SQL, PL/SQL, Performance Tuning)
Primary Tasks and responsibilities:
- Development of ETL for the JEDI project (data warehouse and data marts) using Informatica Powercenter.
- Coach for the other developers regarding Oracle issues; liaison to the Oracle DBAs.
- Maintainer of common (reused) Oracle code in the Data Services and Business Intelligence team.
- Proactively suggest reusable elements and ways of working.
- Participate in Oracle/PowerCenter design/code reviews.
Technical profile requirements:
- Development and implementation of warehouse solutions in Informatica PowerCenter (+5 years), most recent experience not older than 1 year.
- Oracle PL/SQL, Performance Tuning (+3 years), most recent experience not older than 1 year.
- Data Vault experience (+4 year), most recent experience not older than 1 year.
- Teradata experience (+4 year), most recent experience not older than 1 year.