Data Engineer

  • Location

    Dublin City Centre, Dublin

  • Sector:


  • Job type:


  • Salary:

    Up to €0.00 per annum

  • Contact:

    Alison Byrne

  • Contact email:

  • Job ref:


  • Published:

    about 2 years ago

  • Duration:

    3 Months

  • Expiry date:


Data Engineer

This position is with a global ICT and solution organisation on-site with a utilties company. You will be working on a large data migaration project.


  • Able to work from verbal requirements.
  • Create custom staging tables in Oracle database.
  • Extract data from Core HR and Payroll product tables residing in an Oracle database.
  • Load data into staging tables.
  • Write Linux shell scripts to load value mapping spreadsheets into custom Oracle tables using sdcli.
  • Map populated fields in source structure data to fields in target structure (e.g. HCM Data Loader file specifications).
  • Update staging tables and transform from source field values to target field values.
  • Spool data from staging tables into a data file matching HDL file specification.
  • Write OBIEE report to extract configured reference values from target Oracle HCM Cloud.
  • Load extracted target reference values into HDL Validator Tool.
  • Validate spooled HDL data file using HDL Validator Tool.
  • Document process after build.


ERP data migration: one project, preferably end-to-end migration (extract, transform and load)
Oracle PL/SQL: at least five years

For more information on this or other roles feel free to contact Alison on 01 6455250 or alison.byrne @