I have read the answers here and here and need to ask something more.
I wish to study the book on Homological Algebra by Weibel but am not sure of the prerequisites. In particular how much category theory is assumed on the part of the reader ?
Would prerequisites for Rotman's book be lesser ? Should I prefer Rotman's book over Weibel's ?
I am more interested in applying Homological Algebra to Topology & Geometry rather than other applications.
My background is 1 year graduate course on Algebra based on Lang covering Groups, Rings, Modules, Fields & Galois Theory and basics of Homological Algebra. I do not know any algebraic topology beyond the definition of fundamental group. But I do not mind postponing understanding the motivation for some concepts of Homological Algebra that may have origin in Topology.
You definitely have enough prerequisites to read Weibel, especially since you've already seen some basic homological algebra. The toughest part in terms of category theory for you might actually be getting used to abelian categories, but in most places you don't actually need to work directly with abelian categories, and you can use the embedding theorem (so essentially you prove things as if you were in the category of modules). So category theory probably won't be a block for you.
The good thing about Rotman is that he has more material on specific examples, and he goes into more detail.
Ultimately I recommend reading Weibel's book (however, as a disclaimer I have only read Weibel and just glanced at Rotman). Reading Rotman you will have gone through nearly seven hundred pages (Weibel: 415) and still not have seen Lie algebra homology, Hochschild and cyclic homology, and perhaps most importantly for someone who might be interested in topology, simplicial methods (the highlight of which is the Dold-Kan correspondence). To me this seems unacceptable. Rotman also places the chapter on spectral sequences at the end of the book and thus you don't get much of a chance to use them throughout the other chapters, such as group cohomology.
Finally, although Weibel's book has exercises, you might want to supplant them with a few more from either Rotman or Hilton and Stammbach.