Data Migration Engineer

  • Location

    Dublin City Centre, Dublin

  • Sector:

    Infrastructure

  • Job type:

    Contract

  • Salary:

    €500 - €600 per day

  • Contact:

    Alison Byrne

  • Contact email:

    alison.byrne@experis.ie

  • Job ref:

    BBBH105233_1563465944

  • Published:

    about 1 month ago

  • Duration:

    12-18 months

  • Expiry date:

    2019-08-17

Data Migration 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.

Responsibilities:

  • 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.


Experience:


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 @ experis.ie