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 allows businesses to process data in real-time for immediate insights and decision-making. This technology is crucial for industries that rely on timely data processing, such as finance, telecommunications, and e-commerce.Streaming Analytics processes continuous data flows, enabling businesses to react promptly. It helps detect trends, anomalies, and patterns for more informed decisions. This technology enhances data visibility and operational efficiency by enabling...
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.