I think you have to focus your workload, human resource and data integration strategy.
For example, if you would like to load data incrementally from some RDBMS and would like to manage data linage, you have to review the data management feature of tools. If that feature is not important and throughput is important for you, you have to focus data processing power of the tool.
There is no one best solution in the market. You have to define your requirements before selecting your criteria.
I recommend, if you would like to make a design independently of cloud vendors like GCP, AWS or Azure, you can look at the Informatica Cloud product family. There are really good solutions for data integration.
Streaming Analytics processes and analyzes data continuously as it is generated, enabling businesses to derive insights in real-time. The solution empowers organizations to make immediate data-driven decisions and respond swiftly to dynamic market conditions. This technology handles vast amounts of data in motion and offers a platform for continuous computation of results using that data. Designed for time-sensitive business operations, it supports use cases such as fraud detection,...
AWS Glue and Azure Data factory for ELT best performance cloud services.
ETL Developer responsibilities include extracting, transforming, loading ETL processes and data integration. Here’s what to know about an ETL developer’s needed skills, salary and how to become one: https://www.cleveroad.com/blog/how-to-outsource-software-development/
I think you have to focus your workload, human resource and data integration strategy.
For example, if you would like to load data incrementally from some RDBMS and would like to manage data linage, you have to review the data management feature of tools. If that feature is not important and throughput is important for you, you have to focus data processing power of the tool.
There is no one best solution in the market. You have to define your requirements before selecting your criteria.
I recommend, if you would like to make a design independently of cloud vendors like GCP, AWS or Azure, you can look at the Informatica Cloud product family. There are really good solutions for data integration.