Data Migration Analyst/Specialist

AMK TECHNOLOGY SDN BHD
Kuala Lumpur
4-7 years
417 - 500 MYR monthly
26 days ago 24 Applied
Job Description

To facilitate Data Migration Specialist, please possess the following 3 prerequisites:

  • Proficiency in SQL for Oracle and MySQL, with a strong querying ability.
  • Prior experience in employing FME and ETL tools for migration purposes.
  • FME is indeed an ETL (Extract, Transform, Load) tool commonly used for data migration and transformation tasks.
Additional JD:
  • Responsible for the execution of data migration efforts including profiling, cleansing and migration data of jPPH legacy systems.
  • Extract structured and unstructured data from different inputs, databases, and other repositories.
  • Identify legacy data pattern and errors for the development of correction and cleansing processes.
  • Administering, implementing, testing, deploying, and managing ETL solutions using SAS Data Management Studio suite.
  • Segregate all data relevance to the JPPH NVIS development scope.
  • Conduct work related to efforts profiling, cleansing and migration of various systems related to JPPH valuation activities on-site or off-site including:
  • Identify various types of data issues present in the current legacy systems.
  • Determine proper correction approaches to effectively address data errors.
  • Develop source-to-target data mapping specifications and conversion design specifications.
  • Migrate cleansed and corrected data to the target database.
  • Develop and design ETL test cases, scenarios, and scripts.
  • Perform unit testing of each ETL mapping prior to the execution.
  • Address technical issue or problems and propose solutions within area of responsibilities.
  • Perform any other tasks as assigned by the superior(s) from time to time.
Requirement:
1 year experience in real data management using SAS Data Management software or related software

JOB TYPE

Contract Job

Industry

Oil / Gas / Petroleum

Function

Oil & Gas

Roles

Other Oil & Gas

Skills

Data Migration
Etl
Data Migration Specialist
SAS Data Management

Education

Bachelors/ Degree
About

AMK is an International group of IT companies headquartered in Malaysia, comprising of four main companies across multiple technology domains, to ensure delivery of top quality results to our clients.

About Recruiter
Binod Chetri

Functions

IT

Industry

Other

Skills/Roles

Sap,
Networking,
Etc

LEVEL HIRING FOR

Junior Level,
Mid Level,
High Level,
Top Management