Description
SAP Data Migration Technical Consultant - 12 months - Maidenhead - Pharmaceutical.
SAP Data Migration Technical Consultant-RTR(FI/CO), CTC(SD) and FTS/XFS(MM) and RTP (Vendor) - SAP ERP, SAP CRM and SAP MDGc.
A world leading Pharmaceutical client in Maidenhead requires the expertise of an SAP Data Migration Technical Consultant. Process Area(s): RTR(FI/CO), CTC(SD) and FTS/XFS(MM) and RTP (Vendor) - SAP ERP, SAP CRM and SAP MDGc.
Responsibilities:
Providing technical expertise in Informatica (9.1.0) and MS SQL Server to support the technical data migration to deliver and continuously improve the ETL process. Creation of data conversion programmes using ETL Informatica (Power Centre) based toolset and SAP LSMW: Create the technical design for data conversion of specified areas master and transactional data object based on the business requirements provided by the Functional Data Analyst, the project functional/process team and the end business users.
This includes identification of source system data objects, Legacy field to SAP field data mapping and mapping rules and target system upload requirements. Resolve any inconsistencies discovered. Ensure the component meets the stated functional design requirements. Provide sign-off that functional design requirements are met. Loading of data via ETL and SAP LSMW toolsets: Load data into Integration test, Training, UAT and other SAP environments as needed. Creation of reconciliation and validation reports to support the business testing and production sign-off audited process: Support the business in the completion of data cleansing activities providing report on data quality and data cleansing requirements to ensure completeness of pre-load datasets and approval process. Create SAP based, SQL and Informatica reports based on project compliance requirements and support the business in the post-load reconciliation and approval process.
Qualifications Required:
Informatica Power Centre(9.1.0) - Advanced Level SQL (T-SQL) - advanced level MS SQL Server 2008 - advanced level SAP LSMW (BDC/Direct Input/IDOC/BAPIs) - advanced level SAP FI - advanced level SAP SD - advanced Level
SAP MM - advanced level SAP CRM - advanced level SAP MDGc - low level
SAP tables structures - advanced level
Length of Secondment: 12 months