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.
The Bachelor of Professional Studies (BPS) in Cybersecurity degree program provides combines highly technical, hands-on curriculum in labs and virtual environments with invaluable collaboration with government agencies, private companies and the military experts fighting every day on cyberspace’s front lines.
The Computer Information Systems (CIS) degree at JMU prepares students for professional careers that require both the business knowledge and the technical skills to help clients design, build and deliver competitive computer-based solutions. Computer and information systems managers play a vital role in the technological direction of their organizations and must stay abreast of the latest technology to ensure the organization does not lag behind its competitors.
JMU's CIS program was recognized as one of the top ten undergraduate information technology programs in the United States (TechRepublic, 2008) and is part of the nationally recognized JMU College of Business. Professors in the program use a variety of teaching methods including projects, cases and business simulations to prepare graduates with strong technical, analytical, and problem-solving skills; effective communication and presentation skills; hands-on experience; and the ability to work effectively in individual and team-oriented environments.
Several features of JMU's CIS program are distinctive:
- Outstanding placement of graduates: the JMU CIS program is viewed as a prime recruiting school by many leading employers throughout the mid-Atlantic region.
- Course work in a variety of specialties.
- Business intelligence
- Business process management
- Computer forensics
- Computer security management
- Information technology consulting
- Information technology project management
- Excellent opportunities for internships and job-related work experience through JMU's Handshake program and an active JMU CIS alumni network of over 3,100 graduates.
- Active student chapter of the Association of Information Technology Professionals (AITP): Students regularly compete in the National Collegiate Conference, network with industry professionals, engage in service-learning projects, and expand their leadership skills by serving as chapter leaders.
The major puts students in the middle of the exploding information revolution where they study technological advances such as object-oriented software, communication networks, multimedia systems, information security and artificial intelligence. Students will learn about computing technologies used by today’s professionals and how to use these technologies to solve real-world problems. Students will learn to analyze problems, design solutions, implement solutions using multiple computing technologies, test and install those solutions, and communicate those solutions to others in written and verbal presentations.
The Bachelor of Science degree in Information Technology focuses on highly relevant skills in cybersecurity, computer networking, and end-user design and development. The Information Technology degree goes beyond the science behind computers, teaching students how to design, develop, test and maintain solutions in a wide range of computing and networking application areas.
Information Technology studies are integrated to provide students with the knowledge and skills to meet the computer technology needs of business, government, healthcare, education and other organizations. In addition to core competencies in programming and networking, security and privacy, and other application-focused computing fields, the Information Technology major features a junior-level project to address a community need. Also, students in the Information Technology major are required to complete a two-semester senior capstone project, allowing them to apply the range of their abilities in a real-world context. Students in the Information Technology major are also required to select 9 credit hours of IT senior class electives from various fields such as cyber-security, web/mobile development and computer networking.
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 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 curriculum is designed to prepare individuals to work with young children in safe and healthy environments that are supportive of children's individual physical, cognitive, and social-emotional development. Job opportunities include employment as assistant teachers, teachers, group leaders, or family child care providers in programs for young children.
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: The curriculum is designed for individuals who seek full-time employment in the graphic design field. Job opportunities include graphic designer, art director, illustrator, production artist, package designer and web content developer, among others in the graphic design marketplace.
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 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 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
The program is designed to prepare personnel who collect, process, and perform selected tests on samples for medical laboratory analysis. Medical Laboratory Assistants (MLAs) work in hospitals, medical clinics, and reference laboratories. The curriculum includes learning experiences: on-campus, online, and, in partnership, with affiliated clinical laboratories. Graduates are eligible to sit for the American Medical Technologists certification to become certified as a Medical Laboratory Assistant (MLA).
Credit for Prior Learning
Students in this program who have been certified as a phlebotomy technician by the American Society for Clinical Pathology (ASCP) Board of Certification (BOC) are eligible for credit for prior learning in MDL 105 and MDL 106
The curriculum is designed to provide an individual with a sufficient level of knowledge, understanding, and proficiency to perform the tasks associated with meeting a client's needs. These tasks can be performed by a trained, non-lawyer assistant working under the direction and supervision of a lawyer. A paralegal or legal assistant will have a basic understanding of the general processes of American law, along with the knowledge and proficiency required to perform specific tasks under the supervision of a lawyer in the fields of civil and criminal law. Occupational objectives include employment in corporate law firms, government agencies, and any of the varied law-related fields. Paralegals or legal assistants are prohibited by law from offering legal services directly to members of the public.
Advising Note: It is strongly recommended that students meet with an advisor before enrolling in classes or as early as possible in their first semester of enrollment.
Completion Requirements: To remain in the program, students must complete each of the legal specialty (LGL) courses in the program with a 'C' or higher. Students must complete LGL 110 Introduction to Law and the Paralegal Assistantduring their first semester of enrollment and complete the other legal specialty (LGL) courses in the order outlined. Course substitutions are made on a case-by-case basis. In all cases, the grade for substituted courses must be a 'C' or higher.
Special Approval Status: The Paralegal Studies Program is approved by the American Bar Association.
Transfer from Other Institutions: Students must complete 25 percent (17 credits) of their coursework at NOVA. Program guidelines require that at least 50 percent of legal specialty (LGL) credits be completed at NOVA. In addition, ABA guidelines require that at least 10 of those credits be taken in traditional (face-to-face) format. The Paralegal Studies Program accepts the transfer of legal specialty courses completed at other institutions as long as those institutions are regionally accredited and the program director determines that the course objectives and practical skills are comparable to the courses offered in NOVA's Paralegal Studies Program. In all cases, the grade for transfer courses must be a 'C' or higher.
Purpose This program is based on the standards of the American Council on Exercise (ACE) and prepares students to become knowledgeable fitness professionals in health clubs, recreation departments, and fitness facilities in private, commercial, corporate, or government settings. Emphasis is placed on preparing students to sit for a nationally recognized certification exam in Personal Training.
PurposeThe curriculum is designed to prepare students for diverse career options within the field of photography and digital imaging. Coursework will stress both technical and aesthetic elements, enabling students to solve a wide range of visual problems with imagination and originality.
Whether studied with professional goals in mind, to supplement the study of any other field, or just for interest’s sake, computer science offers a powerful way to approach many challenging problems. When combined with selected courses in mathematics and physics, the minor will help prepare the student for graduate work in computer science and related fields
Randolph College provides many ways to engage with mathematics. In addition to the rigorous training afforded by our regular course offerings, faculty frequently engage students in independent study based on student and faculty interests. Furthermore, Randolph College students have been very successful participating in various mathematics competitions against other undergraduate students in the United States. Furthermore, Randolph College Mathematics students have participated regularly in undergraduate research opportunities and internships.
The study of computer science offers students the opportunity to develop problem solving facility and helps develop skills which have broad utility in theory and application and are amongst the most sought-after by employers. The abstraction of real-world problems, the construction of algorithms to display and transform data, and the theory of computation are all central concerns of computer science. The minor in computer science can be effectively combined with any major. Whether studied with professional goals in mind, to supplement the study of any other field, or just for interest's sake, computer science offers a powerful way to approach many challenging problems. When combined with selected courses in mathematics and physics, the minor will help prepare the student for graduate work in computer science and related fields.
A major in business offers students the opportunity to explore theories and concepts from accounting, business, and economics. Students study in an active learning environment and begin to understand and appreciate the complex nature of business organizations through applied economic theory. A major in business prepares students for a career in all business environments and provides an excellent foundation for graduate studies in such fields as business and law. The major in business requires a common core of courses plus one of three concentrations: Finance, Management, or Marketing. All courses in the core and in each concentration must be completed with a grade of C- or better.
A major in business offers students the opportunity to explore theories and concepts from accounting, business, and economics. Students study in an active learning environment and begin to understand and appreciate the complex nature of business organizations through applied economic theory. A major in business prepares students for a career in all business environments and provides an excellent foundation for graduate studies in such fields as business and law. The major in business requires a common core of courses plus one of three concentrations: Finance, Management, or Marketing. All courses in the core and in each concentration must be completed with a grade of C- or better.
A major in business offers students the opportunity to explore theories and concepts from accounting, business, and economics. Students study in an active learning environment and begin to understand and appreciate the complex nature of business organizations through applied economic theory. A major in business prepares students for a career in all business environments and provides an excellent foundation for graduate studies in such fields as business and law. The major in business requires a common core of courses plus one of three concentrations: Finance, Management, or Marketing. All courses in the core and in each concentration must be completed with a grade of C- or better.
The computer science curriculum integrates theory and practice by including foundational topics that underpin the discipline and by emphasizing the value of abstraction and good engineering design in project development. Elective courses provide an opportunity for deeper study in areas of interest. An important part of the curriculum is the inclusion of professional practice activities such as research experience, teamwork, oral communication and technical writing, and project development. While being sensitive to changes in technology, the curriculum also seeks to prepare students for lifelong learning to enable them to meet future challenges.
A student expecting to major or minor in computer science should enroll in CSCI 111-CSCI 112 in the first year. If credit is given for one or both of these courses, then a student should enroll in CSCI 211 or CSCI 210. A student interested in future graduate studies should complete the two calculus sequences, MATH 131-MATH 132. A student interested in computer hardware is encouraged to select PHYS 210 to meet one of the collegiate science requirements.
Cybersecurity is a computing-based discipline that involves the creation, operation, analysis, and testing of secure systems, networks, and applications to protect against a variety of digital threats. The cybersecurity curriculum is based on national standards and builds on a computer science foundation. The curriculum emphasizes four main areas of cybersecurity: information security, software security, network security, and system security. Mindful of the rapid changes in technology, the curriculum seeks to prepare students for lifelong learning to enable them to meet future challenges. A student expecting to major in cybersecurity should complete CSCI 111 and CSCI 112 in the first year.
Capstone experiences offered by the Department of Computer Science include CSCI 401, CSCI 403, and CSCI 485, all of which are available to majors in cybersecurity.
Cybersecurity is a computing-based discipline that involves the creation, operation, analysis, and testing of secure systems, networks, and applications to protect against a variety of digital threats. The cybersecurity curriculum is based on national standards and builds on a computer science foundation. The curriculum emphasizes four main areas of cybersecurity: information security, software security, network security, and system security. Mindful of the rapid changes in technology, the curriculum seeks to prepare students for lifelong learning to enable them to meet future challenges. A student expecting to major in cybersecurity should complete CSCI 111 and CSCI 112 in the first year.
Capstone experiences offered by the Department of Computer Science include CSCI 401, CSCI 403, and CSCI 485, all of which are available to majors in cybersecurity.
The computer science curriculum integrates theory and practice by including foundational topics that underpin the discipline and by emphasizing the value of abstraction and good engineering design in project development. Elective courses provide an opportunity for deeper study in areas of interest. An important part of the curriculum is the inclusion of professional practice activities such as research experience, teamwork, oral communication and technical writing, and project development. While being sensitive to changes in technology, the curriculum also seeks to prepare students for lifelong learning to enable them to meet future challenges.
A student expecting to major or minor in computer science should enroll in CSCI 111-CSCI 112 in the first year. If credit is given for one or both of these courses, then a student should enroll in CSCI 211 or CSCI 210. A student interested in future graduate studies should complete the two calculus sequences, MATH 131-MATH 132. A student interested in computer hardware is encouraged to select PHYS 210 to meet one of the collegiate science requirements.
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.
The courses in this program prepare students for the examinations leading to industry certifications as a Cisco Certified Networking Associate (CCNA).
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.