The Yamuna flood plains spread across the northern part of Indian subcontinent is home to millions of people. The ever-growing population in these plains make it difficult to sustain the demand of freshwater resources. However, the productive aquifers of flood plains could provide solution for these issues. In this context, it is necessary to understand the aquifer characteristics. Thus, the paper attempts to characterize the aquifer in Palla area of the flood plain using integrated approach. Besides, grain size analysis and site-litholog study, the nature of aquifer material was also ascertained from bulk mineralogy of the sediments using X-Ray Diffraction. The aquifer parameters were estimated with help of long duration pumping test data. Moreover, the effect of pumping on salinity variation and hydrochemical facies evolution was also examined. The sand dominant, unconfined aquifer was estimated to have horizontal hydraulic conductivity in the range of 25 m/day and vertical hydraulic conductivity of 6–7 m /day. While the specific yield of the aquifer was estimated in the range of 0.07–0.08. It is observed that under conducive active flood plain environment, the given sand mineralogy at the site does not allow salinity increase in groundwater even after more than a decade of groundwater pumping. In fact, over years, hydrochemical facies have evolved towards Bicarbonate type. These things put together make the active flood plain aquifer a sustainable groundwater resource.