I'm sure there are many who have been hired with a DUI somewhere in their background.
It's very hard to give advice with the little information provided, there simply are too many variables. Rickair's post has good advice - I would add to that whether or not the person had a commercial license prior to the DUI. The commercial license is a pivotal point as it now makes the pilot a professional and as such is held to a higher standard.
Nobody knows what this industry is going to look like tomorrow, next week, next year or several years from now. Competition may be so fierce that an airline may have the luxury of not interviewing anyone with any skeletons. It's really anybody's guess as to what the hiring climate will look like down the pike. If an interview is extended then be prepared to discuss, in detail, what happened and what the learning experience was. Accountability and responsibility....