This research paper presents a comprehensive geotechnical site investigation and analysis of pilefoundation interaction for the Hub River Bridge. The site under consideration is characterized by alluvial deposits overlying a continuous bedrock, with distinct variations in soil composition and scouring phenomena. The top 15.0 meters of soil on either abutment side comprises predominantly alluvial deposits, transitioning into weak sandstone from depths ranging between 15.0 and 45.0 meters. In the middle portion of the bridge, the alluvial deposit extends up to 5.0 meters, succeeded by weak sandstone reaching depths of 45.0 meters. The presence of scouring has been observed, indicating potential challenges in foundation stability. The proposed foundation depth is determined based on pile diameter considerations, ranging from 0.75 meters to 2.0 meters. The design parameters aim to accommodate a service load of 950 tons. The study incorporates a thorough analysis of the subsurface conditions, considering the variations in soil types and potential scouring effects. Additionally, the paper addresses the implications of different pile diameters on the foundation design, ensuring structural integrity and load-bearing capacity. The bridge piles undergo analysis and length determination using the All Pile software. This software facilitates a comprehensive examination of pile behaviour and foundation interaction, ensuring that the designed piles meet the specified load requirements. The utilization of All Pile software allows for a precise and efficient design process, considering the complex geological conditions and variations in soil types. The findings from this research contribute valuable insights into the geotechnical considerations and pile-foundation interaction for the Hub River Bridge, aiding in the development of optimal foundation designs for safe and resilient infrastructure in similar geological settings.