Oracle Data Warehouse Developer

icon location London, The United Kingdom
icon company Workshop

Unverified relocation package Source: theworkshop.com

About Workshop

We build scalable solutions so businesses can stay miles ahead of the competition. Our technology teams are working on the next generation of payments, security, and backend services. We also have a full games studio and expert support services in research, analysis and design.

Position

  • Design, develop and support data warehouse solutions
  • Design and implementation of real time data replication using Oracle GoldenGate ,XML Web Services and JSON message parsing
  • Design and implementation of real time data transformations using Oracle Data Integrator (ODI) and PL/SQL
  • Dimensional modelling using the Kimball methodology
  • Performance tuning of SQL queries
  • Support other developers to raise skill levels across the team
  • Part of the on-call Rota

Your qualification

  • Strong experience working with Oracle databases (both OLTP and DW) and knowledge on advanced DW features
  • Solid experience writing SQL and PL/SQL
  • Good knowledge and experience working with ODI
  • Knowledge of database design and development with previous experience in developing ETL processes, dimensional models and OLAP transformations
  • Strong understanding of both relational and OLAP modelling principles
  • Good experience with SQL queries and database tuning
  • Excellent interpersonal skills and the ability to work in a team environment
  • Excellent verbal and written communication skills

What we offer

  • Challenging and fulfilling work at an innovative, global company that uses cutting-edge tech
  • Global work experience in an Agile environment
  • Competitive salary and relocation packages
  • Team building events, learning labs and extravagant corporate events
  • Office perks including gaming consoles, table tennis, pool table, darts, foosball, books and a kitchen full of coffee, fruit and even ice-cream

Oracle Data Warehouse Developer

icon location London, The United Kingdom
icon company Workshop

Unverified relocation package Source: theworkshop.com

About Workshop

We build scalable solutions so businesses can stay miles ahead of the competition. Our technology teams are working on the next generation of payments, security, and backend services. We also have a full games studio and expert support services in research, analysis and design.

Position

  • Design, develop and support data warehouse solutions
  • Design and implementation of real time data replication using Oracle GoldenGate ,XML Web Services and JSON message parsing
  • Design and implementation of real time data transformations using Oracle Data Integrator (ODI) and PL/SQL
  • Dimensional modelling using the Kimball methodology
  • Performance tuning of SQL queries
  • Support other developers to raise skill levels across the team
  • Part of the on-call Rota

Your qualification

  • Strong experience working with Oracle databases (both OLTP and DW) and knowledge on advanced DW features
  • Solid experience writing SQL and PL/SQL
  • Good knowledge and experience working with ODI
  • Knowledge of database design and development with previous experience in developing ETL processes, dimensional models and OLAP transformations
  • Strong understanding of both relational and OLAP modelling principles
  • Good experience with SQL queries and database tuning
  • Excellent interpersonal skills and the ability to work in a team environment
  • Excellent verbal and written communication skills

What we offer

  • Challenging and fulfilling work at an innovative, global company that uses cutting-edge tech
  • Global work experience in an Agile environment
  • Competitive salary and relocation packages
  • Team building events, learning labs and extravagant corporate events
  • Office perks including gaming consoles, table tennis, pool table, darts, foosball, books and a kitchen full of coffee, fruit and even ice-cream

You have successfully subscribed

Create an alert

As an applicant