Career Overlap Transition record
RecordMove

Big data archive librarian to database 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.

Fig. 1 · Skill transfer ESCO v1.2.1 · directional
From big data archive librarian
54 % overlap
Partial match
To database integrator
40 You already bring
10 Still to learn
67 Skills in the target role2
Learning distance Substantial retraining

56.8/ 100

1 How much of what a database integrator is expected to do is already part of a big data archive librarian’s work. Directional: the figure for the reverse move differs, because moving into a speciality is not the same problem as moving out of one. 2 Every skill the database integrator role is recorded as needing, required and optional together. What these numbers mean.

Why

Why this move works

A database integrator role treats 7 of its required skills as things a big data archive librarian already does. You would walk in with these on day one.

  • data extraction, transformation and loading tools
  • database management systems
  • information structure
  • integrate ICT data
  • manage data
  • query languages

What stands in the way is 10 required skills the profile does not yet cover. Table 3 groups them; Table 4 says which to take first.

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 may need to learn

The 27 missing skills fall into 5 areas of the ESCO skill hierarchy, numbered in the order worth working in. Areas carrying the most required skills come first, and inside each one the required skills sit above the optional ones. Nothing here is a verdict on you: it is a list of what this particular job asks for that your current one does not.

Skill to pick up Tier
01 working with computers 6 required, 4 supplementary
  • still to learn use interface description language required
  • still to learn balance database resources required
  • still to learn execute integration testing required
  • still to learn implement data warehousing techniques required
  • still to learn manage ICT legacy implication required
  • still to learn 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
  • still to learn ICT debugging tools required
  • still to learn 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
  • still to learn 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
  • still to learn 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 pick up 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 pick up Tier
  • still to learn ICT debugging tools required
  • still to learn 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
FAQ

Common questions about this move

Can a big data archive librarian become a database integrator?

Yes, and it is a substantial move. A big data archive librarian already covers 54% of what a database integrator is expected to do: 40 skills carry over, 7 of which the database integrator role treats as required.

What skills does a big data archive librarian need to become a database integrator?

10 required skills are missing, plus 17 optional ones. They fall into 5 areas of the ESCO skill hierarchy, led by working with computers. The single most important is use interface description language.

How hard is the move from big data archive librarian to database integrator?

Its learning distance is 56.8 out of 100, which is the substantial band. That accounts for both how much is missing and how specialised those skills are.

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.