3D hybrid heterostructure have been fabricated using Ag Nanoparticles decorated ZnO nanorods over textured Silicon Micropyramid for Surface Enhanced Raman Scattering (SERS) applications. Silicon texturing was performed using facile Alkaline texturing route followed by the growth of ZnO nanorods (ZnONR) array on the micropyramids over which, the Ag nanoparticles (AgNPs) were decorated. The phase and the surface of the heterostructure was studied by XRD and Field Emission Scanning Electron Microscope (FESEM), respectively. The SERS performance of the 3D heterostructure was evaluated using Rhodamine 6G (R6G) at various concentrations with a detection limit of 0.1 pM. The superior properties of SiMP/ZnONR/AgNP over ZnONR/AgND heterostructure has also been presented to understand the effect of the 3D pyramidal substrate for superior SERS performance. The recovery of the prepared heterostructure has also been demonstrated by photocatalytic degradation of Rhodamine 6G and Methylene Blue. Our work demonstrates a facile synthesis of 3D SERS heterostructure and sheds light on its superior SERS properties paving ways for wide range of applications in bio-sensors, detection of harmful chemicals, food adulterations, narcotic detection and many more.