Responsibilities:
Design, develop, maintain and execute the SAP Data migration strategy
Document the SAP Data entity model
Design, develop and coordinate the integrity of the Data Migration and its environments for the global template
Design, develop and maintain an agreed set of Data Migration Test cycles in accordance with the agreed ERP deployment testing and DM strategies
Design, develop and maintain an agreed set of Data Migration test scripts in accordance with the agreed ERP test cycles
Coordinate the execution of data test scripts
Coordinate the formal capture, analysis and remedial action of data related faults found as part of the testing cycles
Coordinate site data cleansing activity
Design, develop, implement and execute Extract, Translate and Load (ETL) processes and protocols . data repositories, extract histories, error trapping conventions, error resolution processes and sign-off criteria -
Design functional specifications for Data Extracts, Translations and Loads (ETL)
Source appropriate ETL toolset
Design, develop and implement data reconciliation processes and controls
Update test rig to capture test scripts, sequencing, faults, patches and remedial actions as a result of data related faults
Liaise with the configuration manager to preserve the integrity of the Data environments and supporting materials
Requirements:
5+ years of managing Data Migration and Integration stage ERP projects.
Full lifecycle SAP experience in an SAP manufacturing environment with specific understanding of manufacturing, supply chain, shop floor, commercial and finance processes and operations
College or University (IT /Business Degree or Equivalent)
Certified Data Management Professional (CDMP) or equivalent
SAP systems general architecture; Broad understanding of business functions. Specific knowledge of ETL methodology, tools and processes
Technical expertise in: Data Models, Database Design Oracle SQL or MS SQL, Access queries & report writing
Techn.