I would not call it a 'standard' but a possible architecture. The great thing about the cloud is you can complete the puzzle in many ways and make it as complex or as easy as possible.
Also I would not consider Fivetran to be standard in companies. It is pretty expensive and there are a lot of alternatives available at lower cost (but perhaps a tad more work).
For transformation, what about Databricks itself?
You also need orchestration (or perhaps that is what you mean by pipelines).
The whole Machine Learning part is skipped, so you might wanna look into that.
And what about devops/cicd?