A data warehouse developer is the person responsible for designing, implementing, and testing a database's structure and schemes. He or she codes stored procedures and complex queries against the database and tests, debugs, and implements them in order to extract and/or manipulate the information in the database. He or she is expected to utilize his or her systems analysis skills in order to provide expertise in data warehousing. The data warehouse developer must have a demonstrated knowledge of data warehousing modeling utilities. A data warehouse developer must be extremely analytical, detail-oriented, a team-player, and an effective communicator, and should have a high tolerance for stress, as this job oftentimes requires long work hours dictated by deadlines.Thus, the data warehouse developer in principle may have regular hours, but in practice may work at odd hours when scheduled maintenance of the database is most convenient for the company. The data warehouse developer usually reports to the data warehouse administrator or to an information technology (IT) manager. He or she works side-by-side with the business or systems analyst as well as with other developers and members of the design group. This job typically requires a bachelor's degree or an equivalent amount of work experience. It is common for a data warehouse developer to have taken a certificate course in data warehousing. He or she must be skilled in the prevailing data warehousing tool such as SQL (Structured Query Language) or ETL (Extract, Transform, Load). The data warehouse developer must have considerable exposure to development languages such as C/C++, and to various operating systems such as Windows and Linux.
Data Warehouse Developer Tasks
- Design, implement, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information.
- Write stored procedures and code to implement extract, transform, and load methodologies.
- Design, implement, and test the structure and schemas of the data warehouse.