Beschreibung
BRINE SA places the customer needs firmly in the centre and offers a speedy and professional solution. We carefully select suitable consultants and IT-specialists on the basis of their qualification. We pay particular attention to their education, business and technical knowledge, professional experience, individual character and not least, personal preferences
We are looking for a System Engineering & Architecture
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.
Skills:
- 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
Technical or Other Skills:
- 3+ years Java
- 3+ years systems development (design, development, integration, configuration management and documentation)
- 3+ years UNIX, Scripting
- Relational database design
- Knowledge of Sybase and/or Oracle databases is required.
- Strong analytic al and problem solving skills
- Precision of expression using spoken and written English
Nice To Have:
- Experience with the internal tools used on the DWH platform such as Generic
Staging and SDSS - Experience in test managemen't
Work Location:
- Zurich
Total Duration of Project:
- to