Question: can we automate etl testing?
Answer: Automating ETL tests allows frequent smoke and regression testing without much user intervention and supports automatic testing of older code after each new DB build. The decision to implement automated tools for ETL testing depends on a budget that supports additional spending to meet advanced testing requirements.