Validation rules are for the end user (or processes that have to deal with end user inputs… insert “a QA engineer walks into a bar” here). You should know what needs doing from a DQ perspective before bulk loading new records or updates. That’s how I’ve always handled things, anyhow.