• Sign In
  • |
  • Register
Duties / Responsibilities (Including Objectives of the role):
  • For all systems, understand all “external” applications across all Business Applications Systems. External systems being those outside the subject application.
  • Plan and implement all new and revised integrations in line with BAU requirements, planned upgrades or projects / programmes
    • All integrations to have formal transition from test to live operation
    • Liaise with IT security for all planned integrations adhering to general design principles, protocols and security policy.
    • Procure and implement any new integration technology according to requirements and IT / project budgets.
  • Segregation of Master, reference and transactional data;
  • assessment of data quality;
  • management of risks associated with Data Migration; ownership of data extraction, transformation and migration activities;
  • management of data validation processes for migrated data;
  • identify data to be transitioned from Legacy systems to target system / application, defining the process and responsible for the data migration across all functional work streams; develop core data migration deliverables and technical assets and support the testing throughout the data migration test cycles
  • Create and keep up to date all documents for all integrations.
  • Act as 2nd / 3rd level support for Group Lotus Systems integrations as included in all support plans.
  • Work with external technical teams to deliver optimum solutions for integrations between Lotus or Lotus and external systems.
  • Work with chosen vendor and existing Legacy system support teams to deliver a data migration strategy to support SAP ERP deployment
  • Act as Subject Matter Expert for migrations of data between legacy and new systems
  • Train IT Lead Engineer and BASIS engineer for all common tasks integrations.
  • Have knowledge of common Business Applications (eg SAP, Oracle, Doc Mgmt, BI etc)
Qualifications and Experience (Essential & Desirable criteria)

Indication and level of skills, knowledge, training and experience necessary to perform the job effectively

 

Essential Criteria

Desirable Criteria

Vocational/Academic Qualifications

Educated to degree level

 

BSc Degree or Equivalent

Professional/Specialised/ Technical Knowledge and Experience

At least 2 years working with relational databases & business applications. Eg MS SQL, Oracle, Access

 

Extensive use of SQL / ETL/ Query extracting data for business reporting / use.

 

MS SSIS & SSRS

 

Experience in running data migration in major projects

Understanding of Data modelling

 

MS SQL Server 2008 r2

Oracle 7.3.4 or above

 

DTS package tools.

 

Crystal Reports

 

Working knowledge of ERP applications & associated interplay between business transactions.

 

Experience in SAP End to End Data Migration projects involving migration of data objects from multiple ERP/source systems

 

 

Skills and Aptitudes

Fluent English spoken and written

Advanced PC skills (Office)

Methodical, Analytical

Strong analytical skills

Extensive SQL & API knowledge

 

 

Previous Related Experience/Background

(Please do not state number of years experience)

Technical experience in a variety Data migration projects

 

Hands On Experience of ETL tools

Personal Attributes

Team player

Self starter

Technical hands-on

Independent thinker

Proactive “doer”

 

Good interpersonal skills.

Other Requirements

 

 


Other information

3. JOB SUMMARY

Purpose of the role (function within the organisation):

Responsible for physical migration (and steps to get there) of data between applications.

Full life cycle experience of the data migration process, from strategy and planning, through to execution and go-live.

Emphasize the ‘future’ opportunity of the role, why would someone want to take this position, what will they achieve, what opportunities will it offer?

 

Develop ETL (Export, Transform & Load) routines in support of the Digital Transformation of Group Lotus to achieve a leading position within the automotive market.

Provide SME & 3rd level support to BAU team for migrations and interfaces.