Tata Consultancy Services QA Analyst/ETL Tester interview questions

Good, went well, explained about project details, Python coding, SQL coding, testing , sprint details : How do you validate large volume data loads in ETL testing? A: I use a combination of row count checks, data profiling, and aggregate comparisons. For large datasets, I run SQL queries to check sum, count, min, max on numeric columns to ensure source and target consistency. I also perform sampling and use automation scripts in Python for record-by-record validation if needed.