Working with the ETL lead developer, the data quality analyst must transfer his or her knowledge about the condition of the source files and source databases discovered during Step 5, Data Analysis. Since the data quality analyst usually has a systems analysis background, he or she can assist in or even take over creating the source-to-target mapping document.
Database administrator
The database administrator must be involved in the design of the ETL process because of its database aspects (RI, indexing, clustering, and the use of the DBMS load utility). The database administrator can provide valuable input to the ETL process flow and can sometimes reduce the ETL staging window by several hours.
ETL lead developer
The ETL lead developer is responsible for the entire ETL process. With the help of the database administrator, the data quality analyst, and the subject matter expert, the ETL lead developer designs the ETL process flow and creates the ETL program design document with the actual programming specifications for the ETL developers (or instructions for the ETL tool).
Subject matter expert
The subject matter expert plays an advisory role during this step. Since the subject matter expert was involved in identifying the source data and finding the data quality problems, he or she should participate in creating the source-to-target mapping document. The subject matter expert will also be the liaison to the business representative who must validate the business rules used in the ETL process.
