To each their own, but in the case of ETL/ELT, you would just be asking for pain not using aliases.
That’s not an argument against table aliases, its an argument against unclear table aliases.
Single letter table aliases are better than just using unqualified column names, both of which are worse than table aliases guided by the same naming rules you’d use for semantically-meaningful identifiers in regular program code.