For a project at our client s site, an international bank based in Zurich, we are looking for an experienced Data Warehouse Consultant - Oracle (80 - 100%).
Please note, that Switzerland has stopped issuing new work permits until 15 June 2020 due to Covid-19 situation (present stage). Qualifikationen
Many years’ experience as Data Warehouse Consultant with focus on Oracle versions 11g and 12c including knowledge of the differencesWell versed in designing and developing data marts or data warehouses on Oracle as well as strong knowledge of development in SQL / PLSQL and InformaticaIn depth knowledge of architecture and data model designExtensive experience in dynamic script generationExperience with Toad and in Business IntelligenceOpen, proactive team player with excellent documentation skillsFluency in English required, German is an advantage Aufgaben
Build an Oracle data mart for CRM (customer relationship management) based on data from the Oracle DWHDocument the implementation and write user guide for future enhancements by the Analytics teamWork closely together with Analytics teamPrepare deployments and assist in deployment (UAT and Production environment are different Oracle version)Assess in detail the impact of the new origination process / system on existing BI infrastructure, data warehouse and reportingDesign the changes to be executed in the ETL and reportingProvide detailed technical specifications for the ETL development teamCoordinate the preparation of the development and test environmentsTest and validate the ETL developmentDocument all the changes and new process implemented including data models and dictionaries, and handover them to the BI and production support teamsCoordinate and communicate proactively with all the stakeholders all along the project (external vendors, project management, BI team, development team, IT)