Senior ETL/Oracle Developer

We Offer:

• A challenging role as a database developer in a fast paced environment.
• A chance to grow the platform into more business areas.
• A chance to expand your knowledge on trading information and the reporting thereof.
• A chance to work with experts in this field who are passionate about technology.
• A chance to work in a small team that shares knowledge and believes in bring the best value to the business.
• Full product lifecycle development environments, i.e. from requirements gathering through implementation to release.

You Offer:

• At least 3 years of experience in a data warehousing or another "big data" environment.
• Previous experience using visual ETL tools or crating DB procedural ETL processes.
• Good understanding of Agile practices, including test driven development and refactoring.
• UNIX scripting would be an advantage.
• Being proactive and take ownership of tasks and is proud of their work.
• Motivated and enthusiastic team player who's willing to teach as well as learn.
• Someone that shows initiative and resourcefulness and can deliver on time.
• Bachelor/Master degree preferred
• Good English (written and spoken)

General technical skills:

• Has in-depth understanding of data warehousing and working with very large data sets.
• Experience using PowerCenter (or other ETL tools).
• RDBMS experience (SQL Server / Oracle) in both UNIX and Windows server environments.
• Can write scripts to pre-parse files for loading in a UNIX environment.
• Experience of the full project lifecycle.
• Experience of Unit Testing and Mocking.
• Experience of Agile practices and processes.
• Can work collaboratively or independently to deliver within project timelines.
• Can adapt and reapply lessons learned from previous tasks.

What we're looking for in an individual:

• Good written and spoken English.
• Committed to excelling in their job and enjoys delivering accurate and efficient work products..
• A team-first attitude and the flexibility to change tasks as the project requirements change.
• Motivation to support others, to share information and knowledge and to work effectively towards shared goals.
• Can explain complex ideas clearly.
• Proactive in seeking help when needed, and happy to admit when they don't understand something.
• A desire to excel in one's job, by actively learning about new technologies and gaining insight into the business we serve

What we do?

Data warehousing and reporting of trade and product data to both the business (front office) and for regulatory reporting.

How we do it?

Using tried and tested best practices we load data from many disparate systems and build reporting layers and/or reports to fulfil both the requirements of business and various regulatory bodies. This small team operates using agile project management and relies heavily on communication to manage their book of work.

Technology-wise

Our platform consists of both Oracle and MSSQL server databases where data is loaded using a combination of both PowerCenter jobs and UNIX scripts. The data is sourced from a variety of systems either via a database connection or via a flat file delivery for end of day processing, all controlled by Control-M.