If you watched the video ArcGIS Data Interoperability In Action you might have some questions on how some of the demos were built.
I tend to create Spatial ETL tools with external sources - namely .fmw files - as I can easily drag them into Workbench after opening it from the Analysis ribbon or share them with FME users. They are attached below to give you the pattern, but they will not all work for you without repair and replacement of credentials. Contact me if you need help with any of them.
To head off one question - how did I create the New York county name pulldown parameter and attribute value mapping in the Simple Powerful ETL demo, see the CountyParameter.fmw workspace. It scrapes the NY website and writes a CSV file that can be used to import parameter values for the demo tool. You can see the pattern and recycle it elsewhere.