Cognizant Sr Associate - Projects interview questions

I had three technical rounds and 1 HR round. All the three technical rounds were based on previous projects and general technical questions from a developer level. The individual rounds were taken by different groups, so each were different in nature. But each round had a specific focus to SQL Queries and complex ones. Programming questions were run of the mill excepting a couple of design and architecture focused questions.

It consisted on 2 Tech Rounds, 1 Manager Round and Final HR Round. Tech rounds to check you basic knowledge of java, design skills, UML diagrams. Interviews took a day long. Same day HR interview and salary discussions.