Back to Registry
15-1243.01Market Standard — BLS reports under Database Architects (15-1243.00)
Data Warehousing Specialists
Primary Directive
Develop and maintain efficient data warehousing solutions.
Execution Steps
- 1
Design data warehouse structures
Create and implement database structures tailored for data warehousing.
- 2
Map data sources
Establish connections and mappings between source systems and data warehouses.
- 3
Implement data extraction procedures
Develop processes to extract data from various operational systems.
- 4
Verify data quality
Ensure the accuracy and integrity of data within the warehouse.
- 5
Create documentation
Generate supporting documentation including metadata and process flow diagrams.
Toolbox Requirements
Amazon DynamoDBAmazon Elastic Compute Cloud EC2Amazon RedshiftAmazon Web Services AWS softwareApache CassandraApache HadoopApache HiveApache KafkaApache SparkApache Subversion SVNApple macOSAtlassian JIRABashCC#C++Eclipse IDEESRI ArcGIS softwareExtensible markup language XMLIBM SPSS StatisticsInformatica softwareLinuxMicrosoft .NET FrameworkMicrosoft AccessMicrosoft Azure softwareMicrosoft ExcelMicrosoft Office softwareMicrosoft OutlookMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft SQL ServerMicrosoft SQL Server Integration Services SSISMicrosoft SQL Server Reporting Services SSRSMicrosoft VisioMicrosoft Visual BasicMicrosoft Visual StudioMicrosoft WindowsMicrosoft WordMongoDBMySQLNoSQLOracle DatabaseOracle JavaOracle PeopleSoftOracle PL/SQLPerlPostgreSQLPythonRRed Hat Enterprise LinuxSAP softwareSASScalaShell scriptSplunk EnterpriseStructured query language SQLTableauTeradata DatabaseThe MathWorks MATLABTransact-SQLUNIXUNIX Shell
Free — no credit card required. 200 messages included.