I've just written a few new, fragile jobs and was hoping to write tests to cover the bits that make me nervous. Ideally, there would be a small sample of input data copied to test tables, and the job would produce an expected output in the destination tables, which could be compared.
There's currently no WMF standard for writing tests like this, so this task is for investigating what other organizations do.