This study investigated the structural performance of Cast-in-Place (CIP) pile-integrated composite basement walls (CIP-CBW) featuring socket-type shear connectors (SSCs) in both steel and RC applications through finite element analysis. The results demonstrated that while the height and spacing of SSCs significantly influenced the ultimate load and corresponding displacement of the CIP-CBW, their impact on initial stiffness was negligible. Due to the leverage effect, shear forces along the interface between the CIP pile and the basement wall were resisted by both the front and rear bolts of the SSC. The failure mechanism of the SSC joint was characterized by concrete crushing and cracking around the connector, followed by the formation of plastic hinges in both bolts. Bending moment analysis revealed that the rear bolt is particularly susceptible to flexural yielding. Furthermore, the slip tendency at the interface was more pronounced in the steel scheme than in the RC scheme. Notably, the effect of SSC spacing on slip was significant, whereas SSC height exhibited minimal influence.