Beschreibung
DWH Consultant - Development experience - Oracle - Datawarehouse - ETL processes - banking - Zurich
Scope of Work:
- Migration of the SWISS database and staging part of an application from a Legacy environment to the DWH platform including:
- Migration of Informatica 7.14 Workflows to a standardized DWH platform operating on Informatica 8.6
- Migration of batch scheduling jobs running on a internally developed scheduling program to Control-M
- Migration of Database objects on Oracle 10G to a standardized DWH platform operating on Oracle 11G
- Migration of Feedtransfers (Connect Direct/ftp) to the new platform (ftps)
- Ensuring datatransfer of the operational and reporting data from the Legacy database to the new environment
- Development of necessary changes on the application database/staging environment as a result of the migration
- Deployment of the application parts using common change management (SWAN XP) and version control tools (Subversion)
- Close collaboration with the application and platform responsible based in Switzerland and Singapore.
Technical or Other Skills: Must
- Several years of development experience (database, Staging)
- Strong knowledge in database architecture and security
- Strong knowledge of Oracle (10g, 11g), SQL and PL/SQL
- Strong knowledge of ETL processes (Informatica 7, 8), workload automation (Control-M) and feed transfer (ftp-s)
- Strong team player and ability to work in international and heterogeneous teams
- Ability to quickly adapt to defined processes and to work in a highly standardized environment
- Basic XML skills
- Experience with Change Management, Version Control and Quality Control Tools
Nice To Have
- Experience in test management