The main mission of the ETL team is to build the DWH.
More deeply, the ETL team have to develop ETL framework which can effectively:
- Deliver data most effectively to end user tools;
- Add value to data in the cleaning and conforming steps;
- Protect and document the lineage of data.
The ETL framework have to cover the following main points:
- Extracting data from the sources;
- Keep an eye on quality of data and cleaning data;
- Conforming the labels and measures in the data to achieve consistency across the sources;
- Delivering data in a business layer, where it can be accessed by BI tools and business users.
In addition, I want to mention about responsibility of ETL guys, they are responsible for the quality and accuracy of data and they do not hesitate to contact business in case of technical problems or in case of unclear business requirements.
We, technical staff, all work for our business departments and help to make right and accuracy business decision, that's why we have to work in collaboration with business, although we are technical guys and used to work with machines.
