The method you describe of having of having tiles going from the outside of the footings to the inside, connecting the outside tile (I assume this is plastic perforated type) to the inside tile (non perforated)leading to the sump pit is normal for our area. The reason for the sleeves or stubs going through the footing in several places as well as right at the sump pit is to provide an alternate path for the water to get to the sump pit if one area should plug up for some reason. Having a sump pit and pump is good insurance and costs little to do in new construction. Some areas require it by code regardless of the ground conditions. One thing, if radon gas is of any concern in your area, the builder should be installing a sealed sump, possibly with a vent to the roof.