Oracle Data Warehouse Developer

IT Services BI London Temporary

Our DNA

At The Workshop, we invent and reinvent software solutions so businesses can rise above the competition. From disruptive software to cutting-edge technology, we’re all about thinking big and bringing our razor-sharp ideas to life. We’re not bogged down by process or limited by lack of aspiration. And we trust each other to make intelligent decisions, to challenge, change, improve and perfect. It’s a culture where forward-thinkers like you can be fearless

Your Mission

The Workshop is currently looking for an Oracle Data Warehouse Developer to join our multi-skilled scrum team in London. The ideal candidate will have essential data warehousing and relational database knowledge along with good interpersonal and communication skills. The role involves development, implementation and support of a cutting edge real-time data warehouse.

What you’ll do

  • 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).
  • Dimensional modelling using the Kimball methodology
  • Performance tuning of SQL queries
  • Support other developers to raise skill levels across the team

What you’ll bring

  • Significant experience of working with Oracle databases (both OLTP and DW) and knowledge on advanced DW features
  • Experience writing SQL
  • Strong ODI skills
  • 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

 

Desirable:

  • Experience of JSON messages
  • Experience working with Exasol
  • Understanding of Agile methodology

What’s in it for you

  • 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, darts, pool, foosball, books and a kitchen full of coffee, fruit and even ice-cream.