As a Data Warehouse Analyst you perform database analysis and design in solving complex problems. You define architecture, including database structures and metadata, and develop and maintain best practices for data extraction, data loading, and data transformation into and out of a data warehouse or data mart.

As the architect for data warehouses, you develop metadata definitions from business rules and have an intimate familiarity with data modeling, CASE, and data design tools. You establish the data management framework that improves the data quality and standards for both database structures and repository.

You serve as technical leader and consultant for the extraction, transformation, and load (ETL) between data sources, data warehouses, and data marts. As such, you ensure that a consensus among the business users for best practices has been achieved before implementation. Additionally, you define and manage the architecture and infrastructure, honing flexibility and extensibility of the data warehouse.

To meet your data warehouse implementation needs, you use OracleBI Warehouse Builder.

To learn more about this tool, review demonstrations, join a forum, or review documentation, click on the tool's link above.