Almost every job at UPS involves handling packages at some point. What I think your brother is probably talking about is becoming a "Sorter". You can't do this right off, you have to take a bunch of tests first and have the right seniority.
Speaking from my experience you will either become a loader or an unloader. These are the two "entry" level jobs. If you are a loader you will need to learn a list of zip codes that are for your area. You will need to check the zips on the packages, scan them and load them. They train you EXTENSIVELY on doing all this. It's not the hardest job, and it's actually kind of fun. UPS is a great company to work for. They treat their employees great and if you work hard you can definitely move up.
Now, with that being said my number one piece of advice I could give you is IGNORE ALL THE UNION BULL that you will be hearing. You are going to have to become a Teamster...aka...organized cry babies. For the most part this isn't that big of a deal, but I guarantee you you will meet at least one "Old guy" who will try and fill your head with the grand knowledge that you should do only what is the bare minimum required and not one thing more. Now this advice is great if you aspire to one day become one of these Old Guys who go around taping up boxes on light duty for 8 hours because of their numerous "back injuries", but if you want to actually get somewhere in the company I recommend you work hard. Trust me, you will be rewarded nicely if you do.
I started at UPS as a loader, moved up to Management and left a few years back.