Data Engineer - ODI - Azure - Bristol

Recruiter
Confidential
Location
Bristol
Salary
Inside IR35
Posted
08 Apr 2021
Closes
06 May 2021
Sectors
Engineering
Contract Type
Contract
Hours
Full Time
Data Engineer - ODI - Azure - Bristol.

My client are looking for a Data Engineer to join their Data & Business Intelligence team currently working on several business-critical projects positioning data. You'll be joining a team of multi-skilled engineers to apply expertise to the highest standards to meet our business end user's requirements.

You will have experience of the following:

* Successfully delivered data focussed solutions having been part of an Agile development team

* Built and supported data warehouse and data mart solutions using Oracle Data Integrator (ODI)

* Using your extensive skills, developed performant and sustainable code following good development practices

* Demonstrated an ability to understand end to end requirements to influence the design and build and to facilitate data driven insight

* Experience of Cloud platform environments and services preferably AWS (eg RDS, DMS and S3 Buckets)

Experience Required:

* 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

Desirable

* 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