Club

O'Connor played his underage and club hurling and football with his local St Martin's club. The club won the county minor hurling championship in 1974, with O'Connor sharing in the success as a fourteen-year-old substitute. By the time the three-in-a-row at minor level was completed in 1976, O'Connor had become the star player on the team. He was also a figure at midfield in 1977 as St Martin's captured the intermediate hurling championship. This victory allowed the club to advance to the senior grade; however, despite reaching the final four on a number of occasions throughout the 1980s, O'Connor's side failed to win the competition.

On the football fields O'Connor helped St Martin's to win the intermediate championship in 1982.

Inter-county

O'Connor first came to prominence on the inter-county scene as a member of the Wexford minor hurling team in the late 1970s. He captained the team to the 1977 Leinster final, however, Wexford were denied victory on that occasion. In his final year as a minor O'Connor also played in the Leinster football final, however, Dublin denied Wexford. In 1979 he captured a Leinster under-21 title as Wexford surprisingly defeated Kilkenny. The team were later beaten by Galway in the All-Ireland semi-final. These games brought O'Connor to the attention of the senior selectors and he quickly made the step up to that grade.

O'Connor made his senior debut in the 1979 Oireachtas final. Wexford defeated Offaly on that occasion, however, this competition was regarded as little more than a warm up for the National Hurling League. Two years later in 1981 O'Connor was one of the stars of the team, and he was presented with an All-Star award. Two years later in 1983 O'Connor had success on the football field as Wexford defeated Clare to win the Division 3 final of the National Football League. Over the next decade or so Wexford would appear in five Leinster hurling finals, however, the team would be defeated on every occasion. Similarly, the National League final of 1993 saw Wexford battle it out with Cork in a three-game saga that eventually resulted in defeat for the Wexford men.

The following year Wexford crashed out of the provincial championship once again and O'Connor contemplated retirement. New manager Liam Griffin persuaded him to stay on. 1995 saw Wexford endure defeat again, however, 1996 was to be their year. O'Connor endured a hand injury in the provincial semi-final against Dublin, however, he made a cameo appearance in the final as he collected his first Leinster title. It was Wexford's first provincial title since 1977. The subsequent All-Ireland final saw Wexford take on Limerick, the defeated finalists of 1994. O'Connor started at midfield for that game in which a fourteen-man Wexford side defeated the Munstermen and O'Connor won an All-Ireland Senior Hurling Championship medal. One of the iconic images of that All-Ireland final is of O'Connor, the oldest man on the field, being shouldered off in victory. After seventeen seasons in the Wexford jersey O'Connor decided to finally retire from inter-county hurling.