Here is a presentation (slides + video) I gave about a Ruby ETL, for instance. It illustrates the typical use cases I run into.
http://lanyrd.com/2012/rulu/swxtt/