Data extraction, transformation and loading tools

Description

The tools for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure.

Alternative labels

extract, transform, load
ETL

Adeptia Integration Server
Syncsort DMX
Relational Junction ETL Manager
Sagent Data Flow
Data Migrator
Elixir Repertoire for Data ETL
Talend Studio for Data Integration
IBM Infosphere WarehoEdition
Centerprise Data Integrator
Cognos Data Manager
PowerCenter Informatica
CloverETL
Pervasive Data Integrator
Open Text Integration Center

Skill type

knowledge

Skill reusability level

cross-sector

Relationships with occupations

Essential knowledge

Data extraction, transformation and loading tools is an essential knowledge of the following occupations:

Database integrator: Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Big data archive librarian: Big data archive librarians classify, catalogue and maintain libraries of digital media. They also evaluate and comply with metadata standards for digital content and update obsolete data and legacy systems.
Database developer: Database developers program, implement and coordinate changes to computer databases based on their expertise of database management systems.

Optional knowledge

Data extraction, transformation and loading tools is optional for these occupations. This means knowing this knowledge may be an asset for career advancement if you are in one of these occupations.

Clinical informatics manager: Clinical informatics managers oversee the daily operations of information systems used in a medical institutions. They also carry out research, using their understanding of clinical practices to find ways to improve healthcare services.

 


 

References

  1. Data extraction, transformation and loading tools – ESCO

 

Last updated on September 20, 2022