# Tools & technology — data warehouse designer

Source: O*NET 30.3 'Software Skills' for 15-1243.01.

| Software | Category | Hot technology |
|---|---|---|
| IBM SPSS Statistics | Analytical or scientific software | yes |
| SAS | Analytical or scientific software | yes |
| The MathWorks MATLAB | Analytical or scientific software | yes |
| Microsoft Power BI | Business intelligence and data analysis software | yes |
| Tableau | Business intelligence and data analysis software | yes |
| Splunk Enterprise | Cloud-based management software | yes |
| Atlassian JIRA | Content workflow software | yes |
| Amazon DynamoDB | Data base management system software | yes |
| Apache Cassandra | Data base management system software | yes |
| Apache Hadoop | Data base management system software | yes |
| MongoDB | Data base management system software | yes |
| NoSQL | Data base management system software | yes |
| Oracle PL/SQL | Data base management system software | yes |
| Teradata Database | Data base management system software | yes |
| Microsoft SQL Server Reporting Services SSRS | Data base reporting software | yes |
| Amazon Elastic Compute Cloud EC2 | Data base user interface and query software | yes |
| Amazon Redshift | Data base user interface and query software | yes |
| Amazon Web Services AWS software | Data base user interface and query software | yes |
| Apache Hive | Data base user interface and query software | yes |
| Microsoft Access | Data base user interface and query software | yes |
| Microsoft SQL Server | Data base user interface and query software | yes |
| MySQL | Data base user interface and query software | yes |
| Oracle Database | Data base user interface and query software | yes |
| Structured query language SQL | Data base user interface and query software | yes |
| Transact-SQL | Data base user interface and query software | yes |
| Apache Kafka | Development environment software | yes |
| C | Development environment software | yes |
| Eclipse IDE | Development environment software | yes |
| Microsoft .NET Framework | Development environment software | yes |
| Microsoft Azure software | Development environment software | yes |
| Microsoft Visual Basic | Development environment software | yes |
| Microsoft Visual Studio | Development environment software | yes |
| Microsoft SharePoint | Document management software | yes |
| Microsoft Outlook | Electronic mail software | yes |
| Extensible markup language XML | Enterprise application integration software | yes |
| Microsoft SQL Server Integration Services SSIS | Enterprise application integration software | yes |
| Oracle PeopleSoft | Enterprise resource planning ERP software | yes |
| SAP software | Enterprise resource planning ERP software | yes |
| Apache Subversion SVN | File versioning software | yes |
| ESRI ArcGIS software | Geographic information system | yes |
| Informatica software | Metadata management software | yes |
| Apache Spark | Object or component oriented development software | yes |
| C# | Object or component oriented development software | yes |
| C++ | Object or component oriented development software | yes |
| Oracle Java | Object or component oriented development software | yes |
| Perl | Object or component oriented development software | yes |
| Python | Object or component oriented development software | yes |
| R | Object or component oriented development software | yes |
| Scala | Object or component oriented development software | yes |
| PostgreSQL | Object oriented data base management software | yes |
| Microsoft Office software | Office suite software | yes |
| Apple macOS | Operating system software | yes |
| Bash | Operating system software | yes |
| Linux | Operating system software | yes |
| Microsoft Windows | Operating system software | yes |
| Red Hat Enterprise Linux | Operating system software | yes |
| Shell script | Operating system software | yes |
| UNIX | Operating system software | yes |
| UNIX Shell | Operating system software | yes |
| Microsoft PowerPoint | Presentation software | yes |
| Microsoft Visio | Process mapping and design software | yes |
| Microsoft Project | Project management software | yes |
| Microsoft Excel | Spreadsheet software | yes |
| Microsoft Word | Word processing software | yes |
| StataCorp Stata | Analytical or scientific software |  |
| Oracle WebLogic Server | Application server software |  |
| Veritas NetBackup | Backup or archival software |  |
| IBM Cognos Impromptu | Business intelligence and data analysis software |  |
| MicroStrategy | Business intelligence and data analysis software |  |
| Oracle Business Intelligence Enterprise Edition | Business intelligence and data analysis software |  |
| Qlik Tech QlikView | Business intelligence and data analysis software |  |
| TIBCO Spotfire | Business intelligence and data analysis software |  |
| IBM WebSphere | Cloud-based management software |  |
| Jitterbit | Cloud-based management software |  |
| Aster Data nCluster | Clustering software |  |
| VMware | Clustering software |  |
| IBM Domino | Communications server software |  |
| Perforce Helix software | Configuration management software |  |
| Blackbaud The Raiser's Edge | Customer relationship management CRM software |  |
| Apache Flume | Data base management system software |  |
| Apache HBase | Data base management system software |  |
| Apache Oozie | Data base management system software |  |
| Apache Pig | Data base management system software |  |
| Apache Solr | Data base management system software |  |
| Apache Sqoop | Data base management system software |  |
| CodeFutures dbShards | Data base management system software |  |
| Greenplum Database | Data base management system software |  |
| InterMine | Data base management system software |  |
| Kalido Information Engine | Data base management system software |  |
| ParAccel Analytic Database | Data base management system software |  |
| Relational database management software | Data base management system software |  |
| SAND | Data base management system software |  |
| SAP Adaptive Server Enterprise | Data base management system software |  |
| SAP IQ | Data base management system software |  |
| Talend Big Data Integration | Data base management system software |  |
| TalendForge | Data base management system software |  |
| IBM Netezza TwinFin | Data base reporting software |  |
| Oracle Business Intelligence Discoverer | Data base reporting software |  |
| Oracle SQL Loader | Data base reporting software |  |
| SAP Crystal Reports | Data base reporting software |  |
| Cloudera Impala | Data base user interface and query software |  |
| Operational Data Store ODS software | Data base user interface and query software |  |
| Teradata BTEQ | Data base user interface and query software |  |
| Rapid-I RapidMiner | Data mining software |  |
| SAP NetWeaver BW | Data mining software |  |
| Teradata FastLoad | Data mining software |  |
| Teradata Parallel Transporter | Data mining software |  |
| Teradata Tpump | Data mining software |  |
| Microsoft Publisher | Desktop publishing software |  |
| Adeptia ETL Suite | Development environment software |  |
| CloverETL | Development environment software |  |
| Common business oriented language COBOL | Development environment software |  |
| Integrated development environment IDE software | Development environment software |  |
| Microsoft Visual Basic Scripting Edition VBScript | Development environment software |  |
| Teradata FastExport | Document management software |  |
| IBM InfoSphere DataStage | Enterprise application integration software |  |
| SMSi Twister Data Integrator | Enterprise application integration software |  |
| Talend Open Studio | Enterprise application integration software |  |
| IBM Clarity Systems Clarity | Enterprise resource planning ERP software |  |
| Microsoft Dynamics | Enterprise resource planning ERP software |  |
| NetSuite ERP | Enterprise resource planning ERP software |  |
| Oracle Fusion Applications | Enterprise resource planning ERP software |  |
| Oracle Hyperion | Enterprise resource planning ERP software |  |
| Oracle JD Edwards EnterpriseOne | Enterprise resource planning ERP software |  |
| SAP Business Objects | Enterprise resource planning ERP software |  |
| Oracle E-Business Suite Financials | Financial analysis software |  |
| Human resource management software HRMS | Human resources software |  |
| Apache Avro | Information retrieval or search software |  |
| Adaptive Metadata Manager | Metadata management software |  |
| Altova MapForce | Metadata management software |  |
| Apatar | Metadata management software |  |
| Coglin Mill RODIN | Metadata management software |  |
| Embarcadero ER/Studio XE | Metadata management software |  |
| Flat File Checker | Metadata management software |  |
| HiT Software Allora | Metadata management software |  |
| Informatica PowerCenter | Metadata management software |  |
| Oracle Warehouse Builder | Metadata management software |  |
| Pentaho Kettle | Metadata management software |  |
| Quest Erwin Data Modeler | Metadata management software |  |
| SAP PowerDesigner | Metadata management software |  |
| SAS Data Integration Server | Metadata management software |  |
| Scriptella | Metadata management software |  |
| Talend Data Fabric | Metadata management software |  |
| WisdomForce DatabaseSync System | Metadata management software |  |
| Nagios | Network monitoring software |  |
| Advanced business application programming ABAP | Object or component oriented development software |  |
| Objective C | Object or component oriented development software |  |
| Hewlett Packard HP-UX | Operating system software |  |
| Job control language JCL | Operating system software |  |
| KornShell | Operating system software |  |
| Oracle Solaris | Operating system software |  |
| Ubuntu | Operating system software |  |
| Apache HTTP Server | Portal server software |  |
| Unified modeling language UML | Requirements analysis and system architecture software |  |
| Amazon Simple Storage Service S3 | Storage networking software |  |
| McAfee | Transaction security and virus protection software |  |
| NortonLifeLock cybersecurity software | Transaction security and virus protection software |  |
| Customer information control system CICS | Transaction server software |  |
| Ruby on Rails | Web platform development software |  |