Matillion does it all but slightly clunky. There isn't much info online about Matillion to support you, either with Google, Stack, or LLMs. The APIs aren't well documented and the Git integration is very poor. It does work though.

You might want to check out DBT. That's one of the main alternatives (We're switching from Matillion to DBT+airflow).