Senior Specialist - Architecture

Title: Data Technical Consultant SAP S4HANA Data Migration

ERP Transformation Programme Data Workstream

Role Purpose

The Data Technical Consultant is responsible for the technical build execution and support of data migration activities for an SAP S4HANA transformation This includes the development of ETL jobs transformation logic load preparation data validation routines and execution support during mock cycles and cutover

The role serves as the technical engine room of the data migration workstream working closely with the Data Technical Lead Data Functional Consultants SAP Functional Leads and System Integrator SI teams

Key Responsibilities

1 Technical Build ETL Development

Develop ETL jobs mappings and load processes using

oSAP BODS Data Services

oSAP Migration Cockpit LTMC LTMOM Direct Transfer

oIDocBAPI frameworks

oSQL and scripting

Produce efficient repeatable parameterised ETL jobs for multiple mock cycles

Build data extraction and transformation logic from non SAP or legacy systems

2 Data Object Technical Configuration

Configure LTMOM migration objects including field mappings rules staging tables and extensions

Support BPMATDOCACDOCA related technical configuration for complex objects BP roles materials CO assignments valuations etc

Implement code conversions and derivations based on functional rules

3 Data Validation Reconciliation Quality

Develop pre load and post load validation scripts SQLExcelPython

Support reconciliation between source datasets and S4HANA target tables

Implement automated checks for completeness consistency and data relationships

4 Mock Loads Cutover Execution

Run technical execution of mock migration cycles including extract transform load and validate

Analyse defects troubleshoot load issues and provide technical root cause analysis

Support cutover activities including final data loads delta capture and post load checks

5 Collaboration Support

Work closely with Data Functional Consultants to translate business rules into technical logic

Support SAP Functional Teams FICO MM SD PP etc with data defect resolution

Provide input to design documents test scripts and runbooks

Key Deliverables

ETL Jobs Load Pipelines BODSLTMOMSQLScripts

LTMOM Object Extensions Technical Mapping Logic

Transformation Rules Derivation Logic

ValidationRecon Scripts Load Reports

Technical Documentation Runbooks

Mock Execution Technical Summary

Cutover Technical Execution Support

Skills Experience Required

Technical Skills

510 years technical data migration experience SAP preferred

Strong hands on skills with

oSAP BODS Data Services

oSAP Migration Cockpit LTMCLTMOM

oIDocBAPI interfaces

oSQL advanced

oPythonPowerShellBatch scripting nice to have

Understanding of SAP tables structures keys and data models BP Material Finance etc

Functional Process Understanding

Ability to readinterpret S4HANA data models especially

oBusiness Partner customervendor merge

oUniversal Journal ACDOCA

oMaterial Management MM plants valuation

Experience supporting functional mapping and transformation rule design

Delivery Soft Skills

Experience with SAP Activate and structured project methodologies

Strong defect analysis and problem solving skills

Clear communication with both technical and non technical stakeholders

Ability to work under pressure during mocks and cutover

Qualifications

Degree in Computer Science Data Engineering Information Technology or equivalent

SAP certifications in BODS S4HANA or ABAP advantageous

ETLdata engineering certifications beneficial

Success Measures

Clean repeatable and performant ETL jobs across all mock cycles

Low technical defect rates during SITUAT

Successful execution of migration loads with no high severity issues at go live

Positive feedback from Technical Lead Data Lead and Functional Teams

Interaction Model RACI Simplified

Data Technical Lead Receives direction escalates risks aligns on technical architecture

Data Functional Consultant Interprets business rules consultant builds technical logic

SI SAP Functional Leads Collaborate on load sequencing validation and error handling

Data Lead PMO Provides timelines governance and status reporting