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