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 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.
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.
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).