DWH Consultant - Development experience - Oracle - Datawarehouse - ETL

Vor Ort
November 2012, maybe extended
Adecco IT
flag_no Schweiz

Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.

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