# 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 (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 %**