Career Details
15-1243.01 - Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Key Facts

Tasks

Core
- Test software systems or applications for software enhancements or new products.
- Review designs, codes, test plans, or documentation to ensure quality.
- Provide or coordinate troubleshooting support for data warehouses.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- Design and implement warehouse database structures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create or implement metadata processes and frameworks.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
Knowledge

- 85%Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- 65%Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
- 64%Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
- 61%Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
- 57%Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
- 52%Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Tools

- Computer servers
- Data warehouse appliances
- Desktop computers
- Laptop computers
- Mainframe computers
- Personal computers
- Storage servers
- Multi-line telephone systems
Technology

- Adaptive Metadata Manager
- Altova MapForce
- Amazon DynamoDBHOT
- Amazon Elastic Compute Cloud EC2HOT
- Amazon RedshiftHOT
- Amazon Web Services AWS softwareHOT
- Apache Avro
- Apache CassandraHOT
- Apache Flume
- Apache HadoopHOT
- Apache Hbase
- Apache HiveHOT
- Apache HTTP ServerHOT
- Apache Oozie
- Apache PigHOT
- Apache SolrHOT
- Apache Sqoop
- Apatar
- Aster Data nCluster
- Blackbaud The Raiser's Edge
- CA Erwin Data Modeler
- Cloudera Impala
- CodeFutures dbShards
- Coglin Mill RODIN
- Customer information control system CICS
- Data entry softwareHOT
- Embarcadero ER/Studio XE
- Flat File Checker
- Greenplum Database
- HiT Software Allora
- IBM Cognos ImpromptuHOT
- IBM Netezza TwinFin
- Informatica PowerCenter
- InterMine
- Kalido Information Engine
- Microsoft AccessHOT
- Microsoft SQL ServerHOT
- Microsoft SQL Server Reporting ServicesHOT
- MicroStrategyHOT
- MongoDBHOT
- MySQLHOT
- NoSQLHOT
- Oracle Business Intelligence Discoverer
- Oracle Business Intelligence Enterprise EditionHOT
- Oracle PL/SQLHOT
- Oracle softwareHOT
- Oracle SQL Loader
- Oracle Warehouse Builder
- ParAccel Analytic Database
- Pentaho Kettle
- PostgreSQLHOT
- Qlik Tech QlikViewHOT
- Rapid-I RapidMiner
- Relational database management softwareHOT
- SAND
- SAP Adaptive Server Enterprise
- SAP Crystal ReportsHOT
- SAP IQ
- SAP NetWeaver Business Warehouse
- SAP PowerDesigner
- SAS Data Integration Server
- Scriptella
- Structured query language SQLHOT
- TableauHOT
- Talend Big Data Integration
- Talend Data Fabric
- Talendforge
- Teradata BTEQ
- Teradata DatabaseHOT
- Teradata FastLoad
- Teradata Parallel Transporter
- Teradata Tpump
- TIBCO Spotfire
- Transact-SQLHOT
- WisdomForce DatabaseSync System
- Adeptia ETL Suite
- Advanced business application programming ABAPHOT
- Apache KafkaHOT
- Apache SparkHOT
- C
- C#HOT
- C++HOT
- CloverETL
- Common business oriented language COBOLHOT
- Eclipse IDEHOT
- Extensible markup language XMLHOT
- IBM InfoSphere DataStage
- IBM WebSphereHOT
- Integrated development environment IDE softwareHOT
- Jitterbit
- Microsoft .NET FrameworkHOT
- Microsoft AzureHOT
- Microsoft SQL Server Integration Services SSISHOT
- Microsoft Visual BasicHOT
- Microsoft Visual Basic Scripting Edition VBScriptHOT
- Microsoft Visual StudioHOT
- Objective CHOT
- Oracle JavaHOT
- Perforce Helix software
- Practical extraction and reporting language PerlHOT
- PythonHOT
- RHOT
- Ruby on RailsHOT
- ScalaHOT
- SMSi Twister Data Integrator
- Talend Open Studio
- Unified modeling language UMLHOT
- VMWareHOT
- Amazon Simple Storage Service S3HOT
- IBM Domino
- Apache Subversion SVNHOT
- Atlassian JIRAHOT
- Teradata FastExport
- Apple macOSHOT
- BashHOT
- Hewlett Packard HP-UX
- Job control language JCL
- KornShell
- LinuxHOT
- Microsoft WindowsHOT
- Oracle SolarisHOT
- Red Hat Enterprise LinuxHOT
- Shell scriptHOT
- Ubuntu
- UNIXHOT
- UNIX ShellHOT
- ESRI ArcGIS softwareHOT
- Microsoft OutlookHOT
- Human resource management software HRMS
- Microsoft OfficeHOT
- Microsoft ProjectHOT
- Microsoft SharePointHOT
- IBM Clarity Systems ClarityHOT
- Microsoft DynamicsHOT
- NetSuite ERPHOT
- Oracle E-Business Suite Financials
- Oracle Fusion ApplicationsHOT
- Oracle HyperionHOT
- Oracle JD Edwards EnterpriseOneHOT
- Oracle PeopleSoftHOT
- SAPHOT
- SAP Business ObjectsHOT
- IBM SPSS StatisticsHOT
- SASHOT
- StataCorp Stata
- The MathWorks MATLABHOT
- McAfee
- SymantecHOT
- Microsoft ExcelHOT
- Microsoft PowerPointHOT
- Microsoft Publisher
- Microsoft VisioHOT
- Microsoft WordHOT
- NagiosHOT
- Oracle WebLogic ServerHOT
- Splunk EnterpriseHOT
- Veritas NetBackup
Certifications

Licensing

Related Programs

Clicking on the Degree programs in the list below will take you away from the Careers page.
Purpose: The curriculum is designed primarily for students who wish to transfer to a four-year college or university to complete a baccalaureate degree in computer science. The curriculum emphasizes the study of the science of computing and the use of computing in a scientific setting.
Purpose: This curriculum is designed for those who seek employment in the field of Cybersecurity (information assurance), for those who are presently in IT or a security field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in information security. The curriculum is mapped to the NSA/DHS Knowledge Units necessary for NOVA's designation as a Center of Academic Excellence.
Purpose: This curriculum is designed for those who seek employment in the field of information technology, for those who are presently in that field and who wish to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in information technology.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for those who seek employment in the field of cloud computing, for those who are presently in that field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in cloud computing.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for persons who plan to transfer to a four-year college or university to complete a baccalaureate degree program in information technology.
Purpose
Prepares students for entry-level positions or transfer pathways in computing, software development, and artificial intelligence. Students gain foundational programming, data structures, and algorithmic problem-solving skills with optional specialization in General CS, AI, or Data Science & Machine Learning.Purpose: This program is designed as an enhanced competency module to provide expertise in security to networking specialists. This curriculum will prepare networking specialists for employment as network security specialists or Internet security specialists. This program also helps prepare students for the Security+ and the CISSP certification exams.
Purpose: This program is designed to prepare students for entry-level employment in data centers or companies that support data center function as a technician, operator and/or technologist. Coursework will prepare students to earn the DICSI Installer 2 (Fiber Optic) and OSHA 10 industry credentials.
Recommended prerequisites: There are no required prerequisites for this certificate. It is recommended that the student possess a proficiency in high school English, high school algebra and geometry, and possess the ability to utilize hand tools and instrumentation.
Purpose: This program prepares the student to design and implement traditional/legacy stand-alone and client-server applications using procedural and object-oriented development techniques. Upon completion, graduates are prepared to study for one of the following industry certifications: MCP-Programming or the Sun Certified Programming for Java 2.
Purpose: This program is designed to provide students with skills that support the newest capabilities and advances in digital data analytics. These new features in digital data analytics technology enable the data analyst to collect, analyze and make data accessible for making business decisions. This program focuses on training data analytics specialists who can provide these advantages to their employers and stay on the leading edge of technology. Upon completion, graduates are prepared to study for data analytics exams such as CompTIA Data+, Microsoft Certified: Data Analyst Associate and Google Data Analytics Certificate. Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for those who seek employment in the field of cloud computing, for those who are presently in that field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in cloud computing.
Credit for Prior Learning:Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This program is designed to provide students with skills that support the newest capabilities and advances in database technology. These new features in database technology enable databases to increase in scale and provide higher security and greater reliability. This program focuses on training database technologists who can provide these advantages to their employers and stay on the leading edge of database technology. Upon completion, graduates are prepared to study for some of the exams for the Oracle Database Administrator Certified Associate.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This program prepares students for entry-level employment in data centers and related industries that require technicians/technologists trained in engineering technology, information technology, fiber optics, electronics, and data processing. Coursework will prepare students to earn the A+ Hardware, A+ Software, Network Troubleshooting, ETA FOI (Fiber Optic), and OSHA 10 industry credentials. Recommended prerequisites: There are no required prerequisites for this certificate. It is recommended that the student possess proficiency in high school English, high school algebra, and geometry and possess the ability to utilize hand tools and instrumentation.
Purpose: This program is designed for individuals seeking employment in a technical support center and for those persons employed who wish to update their skills in the help desk field. This curriculum will prepare students for employment as help desk specialists/technicians, desktop support specialists, and technical support specialists. Upon completion, graduates are prepared to study for the A+ Software, A+ Hardware, Network+, Security+ and AWS Certified Cloud Practitioner exams.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose:This program is designed for individuals seeking employment in either a mobile application software development firm or large organization with a mobile application development team as well as for those persons already employed who wish to update their skills in mobile application development and testing. This curriculum will prepare students for employment as junior mobile application developers as well as quality assurance test engineers for native mobile applications. Upon completion, graduates are prepared to study for the Google Associate Android Developer certification.
Computer Science courses required for the Computer Science degree are available at the Chesapeake and Virginia Beach campuses.
Admission to the Engineering program requires satisfactory completion of the following high school units or their equivalents: four units of English; four units of mathematics (two units of algebra, one unit of plane geometry, one unit of advanced mathematics or trigonometry and solid geometry); one unit of laboratory science; and one unit of social studies.
Students desiring to enter the A.S. in Engineering program must provide proof of having a strong foundation in math and science and be eligible to take ENG 111. Additional information is available online at tcc.edu (search keyword "Engineering").
Engineering courses required for the Engineering degree are available at the Chesapeake and Virginia Beach campuses.
TCC is an Oracle Academic Initiative (OAI) Partner and an authorized Oracle training site. The courses in this program prepare students for the examinations leading to Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) industry certifications.
TCC is an Oracle Academic Initiative (OAI) Partner and an authorized Oracle training site. The courses in this program prepare students for the examinations leading to Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) industry certifications.
The courses in this program prepare students for the examinations leading to industry certifications as a Cisco Certified Networking Associate (CCNA).