Cognizant interview questions

Deeper interview questions. Mainly focused on the resume. Touched all the topics mentioned in the resume. Questions on SAP BASIS,SAP hana, upgrades, refresh, conversation, performance troubleshooting, printers,job administration, workload,hana replication,backups

Round 1: Online Aptitude + Technical Test The test consisted of 20 aptitude questions and 2 SQL-based coding questions. Topics covered: joins, aggregations, and writing efficient queries. One SQL question was to find the second highest salary from an employee table without using LIMIT. Round 2: Technical Interview (Virtual) The interviewer started with a quick introduction and asked me to explain a project I had worked on. I explained my project on predictive analytics using machine learning, where I used Python, Pandas, and scikit-learn. Then I was asked: Difference between primary key and unique key in SQL. Write a query to fetch duplicate rows from a table. Explain normalization and why it is important. Some scenario-based questions on data cleaning (e.g., handling missing values). Round 3: HR Round The HR focused more on cultural fit and communication. Questions included: "Why do you want to join XYZ?" "Where do you see yourself in 5 years?" "Tell me about a time you worked in a team and resolved a conflict."