Description
Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
EssentialOptional
Theoretical Knowledge
domain name servicedatabase management systemsquery languagesinformation structuredata extraction, transformation and loading toolsICT debugging toolsresource description framework query languageOpenEdge DatabaseIBM InfoSphere DataStagesystems theoryMicrosoft AccessMDXQlikView ExpressorOracle Warehouse BuilderMySQLsystems development life-cycleOracle Data IntegratorPostgreSQLdigital systemsTripleStoreCA Datacom/DBDB2business intelligenceIBM InformixTeradata DatabaseLINQSAS Data ManagementN1QLdata engineeringSAP Data ServicesXQuerySQL ServerFilemaker (database management systems)Pentaho Data IntegrationObjectStoreOracle Relational DatabaseLDAPIBM InfoSphere Information ServerdatabaseInformatica PowerCentersystem designSPARQLSQL Server Integration ServicesMarkLogicinter-organisational middleware system
Practical Skills
use interface description languagebalance database resourcesimplement data warehousing techniquescreate database diagramsintegrate ICT dataexecute integration testingverify formal ICT specificationsmanage datamanage ICT legacy implicationperform data cleansingdefine data quality criteriadesign application interfacesmanage ICT semantic integrationdefine integration strategyapply ICT systems theoryexecute ICT auditsperform project managementwrite database documentationmanage cloud data and storageuse scripting programmingperform data miningcreate solutions to problems