As far as Ceramic Engineering is concerned, 2 Prominent Institutes have this Course, IIT BHU and NIT Rourkela. There are few prominent recruiters at both these Institutes including Tata Steel, Saint Gobain, Piramal Glass and couple more. Most of the students aspire careers in Data Science, Finance, Consulting, Software and especially IIT BHU Campus gives you enough opportunities for these. Same is with Mining Engineering, however in Mining, you have some scope with PSUs(GATE) as well as Steel, Petroleum and Mining Corporations. The Only advantage Ceramic Engineering has over Mining is, you have strong research scope and prospects. You may shift your Branch in Postgraduation to Material Science and Engineering, maybe pursue a MS/PhD Abroad. Ceramic Engineering as well as Materials engineering has immense scope even in the Nuclear and Aerospace Industry. In India, BARC and many other CSIR Organization attract Scientists and Projects in fields of Ceramic Technology, Design and Management. Definitely, if your Aim is UPSC CSE or MBA, either branch is good, however I believe Ceramic would be more interesting than Mining. You have both Dual Degree (5 Years) as well as BTech (4 Years) Courses in Ceramic and Mining. Some of the Best Colleges for Mining include IIT ISM Dhanbad, IIT Kharagpur, BIT Sindri, NIT Rourkela, NIT Raipur, NIT Surathkal and many others.