ETL Developer

My client requires a number of DW/ETL Developers for a major client project in Switzerland. You will be responsible for the logical design and execution of DWH modules and ETL processes in the context of projects of various sizes, taking into consideration the business-related and technical requirements. He/she develops the physical design of the DWH database and implements the ETL processes.

Role and Responsibilities

- Analysis of the data sources, data profiling
- Logical and physical design of the DWH in the 3rd normal form and of the staging
- Definition of standards for data extraction and archiving of extracts
- Design of the ETL/ETL processes
- Analysis and documentation of the source data
- Design of the interfaces (extraction, load)
- Design Source-To-Target Mapping including Business Rules and DQ Checks
- (Transform)
- Definition of the standards for the general achieving
- Design of the Auditing system
- Implementation and optimisation of the ETL/ETL processes
- Implementation of the Historic and Incremental Load
- Implementation of the Job Scheduling
- Implementation of the Auditing Systems
- Design and implementation of the Data Marts
- Design and implementation of BI applications like Reports, Dashboards, ad-hoc
- analysis tools (SAP BO) and similar
- Design and implementation of BI applications like Crystal Reports
- Support of the project manager in the estimates and planning

Skills and Experience required.

- At least 3 year of experience as Oracle DWH developer with experience of Oracle 11G
- At least 3 year of experience in the implementation of ETL processes
- Experience of deployment and configuration
- If you have experience with Oracle warehouse builder for end-to-end data integration and ODI will be a plus but not essential.
- German language skills will be a major advantage but not essential