Career Overlap Transition record Edition 1 · ESCO v1.2.1
Table 1Transition record

big data archive librariantodatabase integrator

A big data archive librarian already meets 54% of what the database integrator role asks for. The move turns on 10 required skills not yet in the profile.

From big data archive librarian
54%
Overlap1
To database integrator
40 Skills carried over
10 Required, not held
56.8 Difficulty2
adjacent 0–30
moderate 30–55
substantial 55–75
career change 75–100
this move, 56.8

This move: 56.8 of 100 · substantial

1 Share of the database integrator role’s weighted skill requirement already met by the big data archive librarian profile. Required skills count in full, supplementary skills at 0.35. Directional: the figure for the reverse move differs. 2 Combines what is missing with how specialised it is, so a gap of general skills scores easier than the same number of narrow ones.

Table 2

Table 2 · What you already bring

Of the 40 skills that carry over, these are the ones fewest other occupations ask for. A database integrator role needs them, and most people applying for one will not have them already. This is the part of a big data archive librarian background worth leading with.

Skill the target role also needs Area
  • already held data extraction, transformation and loading tools information and communication technologies (icts)
  • already held IBM InfoSphere DataStage information and communication technologies (icts)
  • already held IBM InfoSphere Information Server information and communication technologies (icts)
  • already held Informatica PowerCenter information and communication technologies (icts)
  • already held Oracle Data Integrator information and communication technologies (icts)
  • already held Oracle Warehouse Builder information and communication technologies (icts)

All 40 carried skills, including the 7 the database integrator role treats as required.

Table 3

Table 3 · What you would need to learn

The 27 missing skills fall into 5 areas of the ESCO skill hierarchy, numbered below in the order worth working in: the areas carrying the most required skills come first, and inside each one the required skills sit above the supplementary ones.

Skill to acquire Tier
01 working with computers 6 required, 4 supplementary
  • required, not held use interface description language required
  • required, not held balance database resources required
  • required, not held execute integration testing required
  • required, not held implement data warehousing techniques required
  • required, not held manage ICT legacy implication required
  • required, not held perform data cleansing required
  • optional, not held apply ICT systems theory optional
  • optional, not held manage ICT semantic integration optional
  • optional, not held perform data mining optional
  • optional, not held use scripting programming optional
02 information and communication technologies (icts) 2 required, 6 supplementary
  • required, not held ICT debugging tools required
  • required, not held domain name service required
  • optional, not held inter-organisational middleware system optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held data engineering optional
  • optional, not held digital systems optional
  • optional, not held systems development life-cycle optional
03 communication, collaboration and creativity 1 required, 3 supplementary
  • required, not held create database diagrams required
  • optional, not held define integration strategy optional
  • optional, not held design application interfaces optional
  • optional, not held create solutions to problems optional
04 information skills 1 required, 2 supplementary
  • required, not held verify formal ICT specifications required
  • optional, not held execute ICT audits optional
  • optional, not held manage cloud data and storage optional
05 management skills 2 supplementary
  • optional, not held define data quality criteria optional
  • optional, not held perform project management optional
Table 4

Table 4 · Where to start

The 3 entries a database integrator role is least likely to hire without. The ordering is computed from the skill data, not from what pays.

Each entry opens a course search for that skill. Career Overlap earns nothing from these links.

Appendix

Appendix · The rest of the record

All 40 skills that carry over
Skill Type
  • already held data extraction, transformation and loading tools knowledge
  • already held database management systems knowledge
  • already held information structure knowledge
  • already held integrate ICT data skill
  • already held manage data skill
  • already held query languages knowledge
  • already held resource description framework query language knowledge
  • already held CA Datacom/DB knowledge
  • already held DB2 knowledge
  • already held Filemaker (database management systems) knowledge
  • already held IBM InfoSphere DataStage knowledge
  • already held IBM InfoSphere Information Server knowledge
  • already held IBM Informix knowledge
  • already held Informatica PowerCenter knowledge
  • already held LDAP knowledge
  • already held LINQ knowledge
  • already held MDX knowledge
  • already held MarkLogic knowledge
  • already held Microsoft Access knowledge
  • already held MySQL knowledge
  • already held N1QL knowledge
  • already held ObjectStore knowledge
  • already held OpenEdge Database knowledge
  • already held Oracle Data Integrator knowledge
  • already held Oracle Relational Database knowledge
  • already held Oracle Warehouse Builder knowledge
  • already held Pentaho Data Integration knowledge
  • already held PostgreSQL knowledge
  • already held QlikView Expressor knowledge
  • already held SAP Data Services knowledge
  • already held SAS Data Management knowledge
  • already held SPARQL knowledge
  • already held SQL Server knowledge
  • already held SQL Server Integration Services knowledge
  • already held Teradata Database knowledge
  • already held TripleStore knowledge
  • already held XQuery knowledge
  • already held business intelligence knowledge
  • already held database knowledge
  • already held write database documentation skill
17 supplementary skills, helpful but not required
Skill to acquire Tier
  • optional, not held apply ICT systems theory optional
  • optional, not held define data quality criteria optional
  • optional, not held define integration strategy optional
  • optional, not held design application interfaces optional
  • optional, not held execute ICT audits optional
  • optional, not held inter-organisational middleware system optional
  • optional, not held manage ICT semantic integration optional
  • optional, not held manage cloud data and storage optional
  • optional, not held perform data mining optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held use scripting programming optional
  • optional, not held create solutions to problems optional
  • optional, not held data engineering optional
  • optional, not held digital systems optional
  • optional, not held perform project management optional
  • optional, not held systems development life-cycle optional
33 held skills the database integrator role does not ask for
Skill Type
  • not needed by the target role analyse big data skill
  • not needed by the target role apply information security policies skill
  • not needed by the target role comply with legal regulations skill
  • not needed by the target role creatively use digital technologies skill
  • not needed by the target role data models knowledge
  • not needed by the target role data quality assessment knowledge
  • not needed by the target role database development tools knowledge
  • not needed by the target role design database backup specifications skill
  • not needed by the target role design database scheme skill
  • not needed by the target role develop ICT workflow skill
  • not needed by the target role digital curation knowledge
  • not needed by the target role digital data processing skill
  • not needed by the target role digitise documents skill
  • not needed by the target role digitization knowledge
  • not needed by the target role give live presentation skill
  • not needed by the target role identify technological needs skill
  • not needed by the target role information confidentiality knowledge
  • not needed by the target role maintain data entry requirements skill
  • not needed by the target role maintain database performance skill
  • not needed by the target role maintain database security skill
  • not needed by the target role manage ICT data classification skill
  • not needed by the target role manage archive users guidelines skill
  • not needed by the target role manage content metadata skill
  • not needed by the target role manage data collection systems skill
  • not needed by the target role manage database skill
  • not needed by the target role manage digital archives skill
  • not needed by the target role manage information access aids skill
  • not needed by the target role migrate existing data skill
  • not needed by the target role monitor technology trends skill
  • not needed by the target role normalise data skill
  • not needed by the target role perform backups skill
  • not needed by the target role statistics knowledge
  • not needed by the target role visual presentation techniques knowledge
8 gaps that are knowledge rather than practice

Knowledge gaps usually close through study. Practical skill gaps usually need something you can point at.

Skill to acquire Tier
  • required, not held ICT debugging tools required
  • required, not held domain name service required
  • optional, not held inter-organisational middleware system optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held data engineering optional
  • optional, not held digital systems optional
  • optional, not held systems development life-cycle optional
Index
Note

How this record was compiled

Both occupations are taken from ESCO, which lists the skills and knowledge each occupation is expected to have and marks every one required or optional. Nothing here is a prediction about hiring, and nothing here knows that a particular employer wants a particular certificate. Treat Table 3 as a starting point for your own research rather than a syllabus. The full method states what these figures can and cannot tell you.