Reading the benchmarks about Oracle BigData Appliance and expecially how to write a map-reduce program for hadoop, I didn't understand if the map-reduce programs must be written only in java language or exist in the suite graphic tools or more simple languages to write them
As to building simpler map reduce jobs, I can suggest this page:
I am not sure if ODI will have such capabilities, but the pentaho product seems pretty simple and straightforward.
You can even compare the implementation with the straight java one.
Hope it helps.