Environmental pollution and energy scarcity is a major issue of the current scenario which forbear the progress of developing world. To overcome these problems towards a sustainable future, the utilization of sunlight by means of photocatalysis can be regarded as a best and suitable pathway. To validate this purpose, design and development of efficient heterogeneous photocatalyst for harvesting solar energy should be the major research concern for scientific community. In this regard herein, we have prepared a series of stable and efficient CoTiO3/UiO-66-NH2 p-n junction mediated heterogeneous photocatalyst by hydrothermal method. The functionalised linker of UiO-66-NH2 provided an intimate interfacial contact with CoTiO3 by Co/Ti-O-N ionic interaction, as proved by HRTEM and XPS analysis. Moreover the inverted V-shaped Mott-Schottky plot confirmed the junction formation in the optimised CoTiO3/UiO-66-NH2 material. In addition, EIS and PL analysis also provides sufficient evidence about the hindrance of active species recombination in composite as a result of p-n hetero junction. LC-MS characterization technique traces the assorted intermediate species produced in the course of photodegradation of Norfloxacin and confirms its complete degradation to corresponding CO2, H2O and NH4+ by the optimised CoTiO3/UiO-66-NH2. The highest photo-catalytic activity obtained towards Norfloxacin degradation is 90.13% and H-2 production is 530.87 mu mol in 1 h. The enhanced photo-catalytic reaction follows Type-II p-n hetero junction charge transfer mechanism and thus, paves a new way to design MOF based heterojunction photocatalyst for diverse photo catalytic performance. (C) 2020 Elsevier Inc. All rights reserved.