92 lines
3.1 KiB
Markdown
92 lines
3.1 KiB
Markdown
# Competences — database integrator
|
|
|
|
Source: ESCO v1.2.1 occupation-skill relations (http://data.europa.eu/esco/occupation/3d190639-90f8-4402-b1b3-a104a17e0d67).
|
|
|
|
## Essential
|
|
|
|
- **balance database resources** (skill/competence)
|
|
- **create database diagrams** (skill/competence)
|
|
- **data extraction, transformation and loading tools** (knowledge)
|
|
- **database management systems** (knowledge)
|
|
- **domain name service** (knowledge)
|
|
- **execute integration testing** (skill/competence)
|
|
- **ICT debugging tools** (knowledge)
|
|
- **implement data warehousing techniques** (skill/competence)
|
|
- **information structure** (knowledge)
|
|
- **integrate ICT data** (skill/competence)
|
|
- **manage data** (skill/competence)
|
|
- **manage ICT legacy implication** (skill/competence)
|
|
- **perform data cleansing** (skill/competence)
|
|
- **query languages** (knowledge)
|
|
- **resource description framework query language** (knowledge)
|
|
- **use interface description language** (skill/competence)
|
|
- **verify formal ICT specifications** (skill/competence)
|
|
|
|
## Optional
|
|
|
|
- apply ICT systems theory (skill/competence)
|
|
- business intelligence (knowledge)
|
|
- CA Datacom/DB (knowledge)
|
|
- create solutions to problems (skill/competence)
|
|
- data engineering (knowledge)
|
|
- database (knowledge)
|
|
- DB2 (knowledge)
|
|
- define data quality criteria (skill/competence)
|
|
- define integration strategy (skill/competence)
|
|
- design application interfaces (skill/competence)
|
|
- digital systems (knowledge)
|
|
- execute ICT audits (skill/competence)
|
|
- Filemaker (database management systems) (knowledge)
|
|
- IBM Informix (knowledge)
|
|
- IBM InfoSphere DataStage (knowledge)
|
|
- IBM InfoSphere Information Server (knowledge)
|
|
- Informatica PowerCenter (knowledge)
|
|
- inter-organisational middleware system (knowledge)
|
|
- LDAP (knowledge)
|
|
- LINQ (knowledge)
|
|
- manage cloud data and storage (skill/competence)
|
|
- manage ICT semantic integration (skill/competence)
|
|
- MarkLogic (knowledge)
|
|
- MDX (knowledge)
|
|
- Microsoft Access (knowledge)
|
|
- MySQL (knowledge)
|
|
- N1QL (knowledge)
|
|
- ObjectStore (knowledge)
|
|
- OpenEdge Database (knowledge)
|
|
- Oracle Data Integrator (knowledge)
|
|
- Oracle Relational Database (knowledge)
|
|
- Oracle Warehouse Builder (knowledge)
|
|
- Pentaho Data Integration (knowledge)
|
|
- perform data mining (skill/competence)
|
|
- perform project management (skill/competence)
|
|
- PostgreSQL (knowledge)
|
|
- QlikView Expressor (knowledge)
|
|
- SAP Data Services (knowledge)
|
|
- SAS Data Management (knowledge)
|
|
- SPARQL (knowledge)
|
|
- SQL Server (knowledge)
|
|
- SQL Server Integration Services (knowledge)
|
|
- system design (knowledge)
|
|
- systems development life-cycle (knowledge)
|
|
- systems theory (knowledge)
|
|
- Teradata Database (knowledge)
|
|
- TripleStore (knowledge)
|
|
- use scripting programming (skill/competence)
|
|
- write database documentation (skill/competence)
|
|
- XQuery (knowledge)
|
|
|
|
<!-- market-evidence -->
|
|
|
|
## Market evidence (job-ad analysis, 51 ads, as of 2026-07-11)
|
|
|
|
Share of analyzed job ads mentioning the item (threshold ≥ 20 %). Source: JSearch/Adzuna APIs.
|
|
|
|
### Hard skills
|
|
|
|
- data integration — **75 %**
|
|
- data modeling — **29 %**
|
|
- etl development — **27 %**
|
|
- data analysis — **20 %**
|
|
|
|
<!-- market-evidence -->
|