- Discover, profile, explore and document any potential source system for a data warehousing project, including detailed examination of source data at the table and column levels
- Design, populate and test any target data warehouse schema, whether normal form, dimensional, data vault or hybrid
- Implement, test and populate any purchased enterprise data model in the planned target environment
- Perform a complete source-to-target mapping between profiled and documented source systems, and designed target schema
- Test planned schema, populated with real data, for functionality and coverage, with end users, before building activities commence.