Description
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
EssentialOptional
Theoretical Knowledge
systems theoryICT security legislationdatabase management systemsbusiness process modellingquery languagesinformation structuredatabase development toolsdata warehousedatabaseweb programmingresource description framework query languageErlangSmalltalk (computer programming)OpenEdge DatabaseCOBOLMicrosoft Accessdata scienceVisual BasicHaskellMDXCoffeeScriptMySQLRPostgreSQLObjective-CPerlTripleStoreScalaPython (computer programming)CA Datacom/DBAPLSwift (computer programming)DB2VBScriptScratch (computer programming)Pascal (computer programming)Ruby (computer programming)TypeScriptC#ICT project management methodologiesML (computer programming)lean project managementIBM InformixTeradata DatabaseLINQProlog (computer programming)Assembly (computer programming)N1QLOpenEdge Advanced Business Languagedata modelsXQueryGroovySQL ServerSAP R3JavaScriptFilemaker (database management systems)ObjectStoreProcess-based managementOracle Relational DatabaseABAPPHPLDAPproduct data managementAgile project managementJava (computer programming)Common LispMATLABSPARQLASP.NETSAS languagedata visualisation softwareLispMarkLogicAJAXMicrosoft Visual C++computer programmingC++unstructured data
Practical Skills
design database schemecreate software designcreate database diagramsapply ICT systems theoryassess ICT knowledgemigrate existing datadevelop automated migration methodswrite database documentationuse databasesuse markup languagesidentify software for warehouse managementoperate relational database management systemanalyse business requirementsmanage standards for data exchangemanage databasedefine technical requirementscreate data setsapply technical communication skillsdesign user interfacedesign database in the clouddevelop reporting softwarebuild business relationshipsperform resource planningdesign database backup specificationsuse back-up and recovery toolsuse access control softwareuse query languagesmanage cloud data and storagestore digital data and systemsdefine database physical structureperform data analysisrespond to customers' inquiries