Contract type: Freelance (Full time), EU citizenship requiredVASS is actively looking for an Expert Data Warehouse Architect to work for our client the European Commission, remotely.Job Description:Review of the architecture of existing systems.Analysis of the integration of different information systems.Review of data warehouse architecture. Design, review and development of data warehouse architecture components.Production of data warehouse architecture documents, design and analysis models, implementation models.Follow up of the data analysis and data modelling.Documentation of the technical implementations.Participation in technical working groups, progress meetings and meetings with the users.Provide assistance or support in the resolution of production issues and data quality issues.Assistance in the testing, the technical documentation, the deployment, the evaluation and the reporting.Job Requirements:Bachelor's degree in Computer Science or related field.Outstanding knowledge of Relational DBMS and DB applications.Good knowledge of UML or other with equivalent value.Good knowledge of RDBMS microservices architecture and database architecture in the cloud.Good knowledge of data warehouse applications design.Good knowledge of Enterprise Data Warehouse Architecture.Good knowledge of ETL tools and complex file transformation and processing.Good knowledge of modelling tools.Good knowledge of Wiki and collaborative sites.Knowledge of software development methodologies (e.g. RUP, Agile).Very good working experience of Java.SPECIFIC EXPERTISE:At least 12 years of outstanding experience with ORACLE, ORACLE advanced PL/SQL (advanced cursors, advanced exception handling, advanced database triggers, dynamic SQL/PL/SQL), PL/SQL procedures and packages, performance tuning and Microsoft SQL server DB, and demonstrable experience with ORACLE external procedures, Flashback features, Publish-Subscribe Model, Microservices Architecture, Sagas APIs, Lock-Free Reservation, Sessionless Transactions, Edition-Based Redefinition, Transaction Guard, DDL Change Notification.If you are interested, please don't hesitate to submit your application before the deadline!Seniority levelMid-Senior levelEmployment typeContractJob functionInformation TechnologyIndustriesIT Services and IT Consulting
#J-18808-Ljbffr