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 real-time data streams for immediate insights, enhancing decision-making and operational efficiency in many sectors.This solution is essential for organizations that deal with large volumes of data requiring swift examination and interpretation. It provides near-instant analyses, transforming raw data into actionable insights without delays. As data flows continuously from IoT devices, sensors, and web applications, Streaming Analytics bridges the...
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.