Ultimate access to all questions.
Your company is integrating data from multiple sources, including a MySQL database, an S3 bucket containing JSON files, and a Kafka stream. The data needs to be transformed and loaded into an Amazon Redshift cluster. Which AWS service would you recommend for orchestrating this ETL process, considering the need for cost optimization and ease of use?