ODI Developer - Data Engineer - PL/SQL - London

London  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

ODI Developer - Data Engineer - PL/SQL - London.

My client are looking for an ODI Developer/Data Engineer on a contract basis to join my clients development team on high profile projects. The candidate should be able to demonstrate experience of building Data warehouses using ODI (Oracle Data Integrator) as a part of an overall analytics solution. You should have strong hands on technical experience in programming, SQL and data manipulation/transformation of large data sets using varied databases and platforms.

Experience Required

  • Minimum 5 years of experience: Building, enhancing, supporting data warehouse solutions (primarily using Oracle data warehouse technologies)
  • Proven technical ability in developing, enhancing, tuning and supporting ETL/ELT and data integration solutions using tools from Oracle (Oracle Data Integrator)
  • Strong experience with a PL/SQL
  • Star schema/Dimensional modelling
  • An understanding of Google Analytics structures, data collection and storage, GA API calling, extraction and load from GA into a customer warehouse, Configuration and Enhancing GA for specific data requirement such as customer attributes, click journeys and GA reporting.
  • Good knowledge of working with JSONs in Oracle database
  • Some knowledge of Python/Spark libraries such as numPy and Plotly or other data manipulation libraries to create data pipelines would be advantageous
  • Knowledge/experience of Snowflake and JSON manipulation in Snowflake or the aptitude to understand this technology quickly
  • An understanding of AWS DMS, Kafka, Real Time analytics, NoSQL, Elastic Stack would also be advantageous

About you:

You have experience of the following -

  • Build and support data warehouses/data marts/data stores to facilitate data analytics and insights
  • Build and support data integration and transformation routines from source systems to target data stores using Oracle Data Integrator (ODI)
  • Build performant code following good development practices and improve existing code as appropriate
  • Work closely with BA's and the Business Analysis team to build data structures that facilitate data driven insights using various BI Tools like OBIEE, Tableau, Oracle DV etc.
  • Scope of work includes on premise and cloud platform environments primarily covering relational databases (eg Oracle, PostgreSQL) and file/object stores (eg AWS S3)
Start date
ASAP
Duration
6 months Rolling
From
Nexere Consulting Limited
Published at
17.01.2021
Project ID:
2030974
Contract type
Freelance
To apply to this project you must log in.
Register