Description
We are looking for a Data Warehouse Analyst to work at our multinational client in Rome/Italy.
Tasks
- Working in close collaboration with a DW Architect assigned to this initiative, the contractor will participate in analysis of business requirements and translate the requirements into technical deliverables through Oracle Warehouse Builder (OWB) platform required to address them including:
- Data modelling
- Deployment of physical data model to target Data Warehouse
- Design and development of data extraction routines from Oracle eBusiness Suite, or other data sources, using SQL objects and OWB components
- Design and development of data transformation and data loading routines using OWB data mappings
- Design and development of automated process flows
- perform initial technical testing and verification before the delivery of artefacts to the responsible technical team leader;
- ensure that all related tasks are properly logged and documented;
- inform the lead the technical team leader of any issues that may arise related to assigned tasks and provide regular feedback on progress;
Outputs:
- Physical data model of up to 9 fact tables and associated dimensions (the exact number of dimension table objects will be determined after analysis phase is completed) will be created and deployed to target DW schema.
- ETL process for extraction, transformation and loading of the data into the target Data Mart developed and deployed.
- Technical documentation created
Essential Requirements:
- Minimum of 5 years of experience in designing and developing end-to-end data warehouse and Business Intelligence solutions using at least one of the following tools:
- Oracle Warehouse Builder or (OWB) and/or Oracle Business Intelligence Enterprise Edition (OBIEE);
- In-depth knowledge of Oracle database PL/SQL and SQL Scripting language as well as relational and dimensional data modelling.
- Experience in analysing user requirements, incorporate them in new and existing BI solutions
- Hands-on Experience with OBI including OBI meta-data modelling techniques;
- Hands-on Experience with OWB:
- Excellent English (written and spoken) language skills with the ability to express complex technical matters.
Desirable Requirements:
- Knowledge of Oracle E-business Suite:
- Understanding of relevant administrative business processes in a public sector or international organization;
- Experience in documenting problems, assess impact and mitigate resolution of issues in a clear and concise manner;
- Experience in preparing technical documents in English.
infeurope is a Luxembourg-based IT service provider, designing, developing and managing multilingual information and documentary systems in many application areas and business sectors. For more than 32 years, we have delivered IT systems and solutions, and IT consultancy and staffing services, to our clients in Luxembourg and across Europe.