Cognizant Data Engineer interview questions

2 Tech rounds and 1 Behavioural round. Tech round was with SQL and Python, Py Spark SQL : DDL,DML, Aggregates, Window Function Python : List, Dict, PySpark: spark SQL, Spark DataFrames

Technical/Skill Assessment: Depending on the role, include a technical test, coding challenge, case study, or a portfolio review to evaluate the candidate's skills. Behavioral Interview: Conduct a behavioral interview using the STAR (Situation, Task, Action, Result) method to assess how candidates have handled situations in the past. Cultural Fit: Assess how well the candidate aligns with the company’s values, culture, and work environment. This might involve interviews with potential team members. Panel Interview: Involve multiple interviewers from different departments to provide a well-rounded assessment of the candidate. Problem-Solving Assessment: For roles requiring critical thinking, include a problem-solving or scenario-based question to gauge the candidate’s thought process.