Description
Data Engineer (Oracle - ODI - PL/SQL)
6 month contract
£500 per day
London/Bristol
An industry leading client require a Data Engineer (Oracle - ODI - PL/SQL) to join their Business & Data Intelligence Team on multiple data focused projects that have come as a result of demand to provide alternative data services to meet differing user requirements.
Data Engineer (Oracle - ODI - PL/SQL) Essential Experience:
Minimum 5 years of experience:
- Building, enhancing, supporting data warehouse solutions using Oracle 12c & 19c databases.
- Proven technical ability in developing, enhancing, tuning and supporting ETL/ELT and data integration solutions Oracle Data Integrator 12c
- Strong experience with a PL/SQL experience including development of packages and procedures with robust error handling.
- Star schema/Dimensional modelling
- Practical experience of developing within Snowflake would be advantageous.
Data Engineer (Oracle - ODI - PL/SQL) Desirable Experience:
- An understanding of streaming technologies such AWS DMS, Kafka or Golden Gate to enable Real Time analytics.
- An understanding of Google Analytics structures, data collection and storage, GA API calling, extraction and load from GA into a custom warehouse.
- Good knowledge of JSON manipulation in Oracle Database and Snowflake
- Experience of delivering a database application using Apex.
- Some knowledge of common data manipulation Python/Spark libraries to create data pipelines would be advantageous.
If you have the experience that this role is asking for, please apply with a CV ASAP.