Design a Data Warehouse Schema

You are tasked with designing a data warehouse schema for an online retail company that needs to analyze customer behavior. The company wants to track user purchases, product categories, and sales over time. Describe the overall architecture, including the choice of databases, ETL processes, and data models you would use to achieve this. Discuss how data consistency and scalability can be maintained.