You are required to design a data pipeline that integrates data from multiple sources, including on-premises databases and cloud storage. Discuss how you would use AWS services to achieve this integration, focusing on data extraction, transformation, and loading processes.