You need to have knowledge about Photoshop and similar tools, knowledge about how to create textures or VTF files, knowledge about models and correct version to use with each source engine version, and then some related tools for compiling and decompiling models, textures etc.
Each of the above phrases you can google or youtube and learn.