Interview question asked to Data Scientists interviewing at LogMeIn, Wise, Airbnb and other companies. Original question asked: Write out the pseudocode for an ETL validation step that compares today's row count against a 7-day rolling average to detect ingestion failures..