This job has been posted for more than 30 working days and has expired.

ETL Developer



*ETL developer, ETL developer, ETL developer, ETL developer




ETL developer required for a major Pharmaceuticals client based in London.

The key responsibilities of this role are:

  • The development of ETL/ELT solutions (mappings, procedures, packages, scenarios) for various projects using ODI, OWB or SQL/PLSQL.

  • Detail design for specific ODI/OWB mappings and flows by interacting with the technical Lead, system analyst and other team members involved in the project.

  • Perform and document the Unit Testing (developer testing.)

  • Create the deployment artefacts for migration of the solution on various environments following the stages of the project (System test, Integration Test, User Acceptance Test, Production) in line with the Agency Standards.

  • Analyse various issues reported by the testing team including data issues

  • Support of the solutions in production (investigate, document, propose solution and estimate.)

  • Estimate the work packages assigned.

  • Physical data modelling design for target or staging objects using Power Designer as a tool for this.

  • Tuning the ETL/ELT processes and asses the performance issues (ODI, OWB or SQL PLSQL code.)

  • Peer reviews.

The following qualities are considered mandatory for the successful candidate:

  • Deep knowledge of data warehousing concepts, terminology, and architecture.

  • In depth knowledge of ETL Architecture based on ODI and Oracle.

  • Solid SQL, PL/SQL Skills and strong understanding of database, data structures, data quality, physical data modelling, SQL tuning, stored procedure expertise.

  • Working experience with Oracle Warehouse Builder 11g.

  • Working experience with Oracle Data Integrator.

  • Knowledge and work experience using Power Designer.

  • Ability to produce quality technical analysis covering data, logical data mapping and process mapping between source and target systems.

  • Ideally you will havee been involved as developer in at least 2 ODI projects or the candidate must have at least 2 years working experience with ODI.

Required Software Expertise:

Oracle 11g DBMS development

Oracle 10g DBMS development




Power Designer

Oracle Warehouse Builder

Optional skills:

IBM Rational ClearQuest

Oracle Workflow



If this role is of interest then please do not hesitate to contact us.