Data Migration ETL Developer

Location: Western Sydney, New South Wales
Job Type: Contract
Posted: 19 days ago
Contact: Tim Moynihan
Reference: 181139_1525321287

Location: Sydney CBD

Start Date - 14/05/2018

End Date - 02/11/2018

The Data Migration ETL Developer is accountable for implementing & executing the extract, transformation, load and reconciliation of source-to-target HR and Payroll (HCM) data as part of the data migration stream for the client.


Design and implement data migration ETLR components in SAP Data Services for HCM data

Execute end-to-end data migration processes for trial migrations, dress rehearsal and production migration

Identify, communicate and remediate data quality errors and ETL errors

Identify, and communicate risks and issues to the Data Migration Stream Lead

Work with client and vendor groups to obtain source data and define detailed transformation rules

Work with other stream leads to determine data requirements for successful ETLR of HCM data

Ensure all analysis and development work is thoroughly documented



Completion of at least one end-to-end Data Migration project with SAP HR/PY as the target

Demonstrated experience writing T/SQL stored procedures for Microsoft SQL Server

Demonstrated experience in developing ETL solutions using SAP Data Services for migration of HR and Payroll data

Demonstrated experience in at least one of the following: SAP ABAP, SAP ALE framework (iDocs), SAP Legacy Migration Workbench (LSMW)

Demonstrated experience in analysing source data and target requirements to prepare source-to-target mapping for HR and Payroll data

Demonstrated experience in developing reconciliation solutions to validate the results of ETL for HR/Payroll data

Analytical thinker who has shown an ability to leverage lessons learned, and implement continuous improvement initiatives

Excellent written and verbal communication skills


Exposure to Chris21 HR/Payroll system and/or data

Experience working with NSW Government agencies

Experience extracting data using ODBC technologies

For a confidential discussion on this role please contact Tim Moynihan at