Easy: for transformations, code first approach is superior to low/no code tools.

So this leaves extract and orchestration. Keep that as cheap as possible, no need for Matillion.

Can't speak for people who do not like code though.

On AWS I'd try Glue.