All procedures for Extract, Transform and Load will be build on required DW/BI architecture including: extraction from source systems (profiling, change data capture and extract), cleanse and conform ( Data Quality screens and responses, Error Schema, Audit Dimension and Conforming, Deduplication), load to target model ( Dimension building, Slowly Changing Dimensions handling, Fact tables loading, Aggregation building, etc.) Procedures could be build using off-the-shelf ETL tools such as ODI or PL/SQL procedures using Oracle DB as staging area.