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)