In doubt, use common sense.Proverb
There are no fixed guidelines on when to use ETL or ELT. It is normal that both are used in many enterprise companies and normal.
It is clear that you can design a process and it is working beautifully for you, 100% OK.
But what is happening when you extrapolate this problem to a scale that your process it is taking longer and longer time because your database has become a MONSTER…
In this post, we do a quick analysis on each method with Pros and Cons of each methodology.
ETL is more typical than ELT because of the existing GUI Tools that help the user to set the process outside of the data source.