G-Z0CWG71G0R

Data Migration Engineer

Job Type:
Contract
Industry:
Infrastructure
Job reference:
BBBH105233_1563465944
Posted:
over 4 years ago

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

Back job search
Back to Search Results
G-Z0CWG71G0R