I know a slightly different version of this song that my family sings on holidays
i was looking for it online and "I am a fine musician" seems to be the closest thing"
but the one I know goes

In a small town in germany
there lived a shoemaker
and his name was Schumann
And he played the piccolo
picca-picca-picca lo picca-lo picca-lo
and then big bass drum, big tuba, clarinet, etc

does anyone else know this version?