The present work describes the fabrication of CdS-D@CeO2 Z-scheme heterojunctions as highly stable, efficient and recyclable photocatalysts for the visible light assisted reduction of CO2 to methanol as well as Cr(VI) to Cr(III). The bare CeO2 produced methanol with the rate of 111 μmolh−1g−1 that is much lower in comparison to CdS-D@CeO2 (501 μmolh−1g−1). In addition, the photocatalytic efficiency remained nearly same for three successive runs, indicating the higher stability and recycling ability of the heterojunctions CdS-D@CeO2. It was also observed that under direct sunlight irradiation, CdS-D@CeO2 efficiently reduced 100% Cr(VI) to Cr(III) in an aqueous medium in just 40 minutes. Moreover, >95% removal was maintained even after 5 catalytic cycles. Additionally, for mimicking real contaminated water samples, the influence of the foreign ions on Cr(VI) reduction was evaluated by using lake water sample and no adverse effects on the result were observed. Thus, this work showed a way to develop cost-effective, easily synthesized, durable and recyclable composite photocatalysts for CO2 utilization and proficient removal of waste water pollutants by employing the clean, green, and renewable solar energy.