UST Lead 1 - software engineering interview questions

Round 1 Technical - moderate to difficult, many questions asked on Looker BI tool and complex SQL questions asked Round 2 Managerial - normal discussion with Hiring manager and the interview went well, I have got shortlisted for the interview

HR Screening: Initial screening conducted by the HR team to assess candidate eligibility, communication skills, cultural fit, and alignment with the role requirements. Technical Round 1: Evaluation of foundational technical skills, including core Python concepts, web frameworks such as Flask, relational databases (MySQL), and NoSQL databases (MongoDB). Technical Round 2: In-depth assessment covering advanced and problem-solving–oriented Python questions, along with system design concepts to evaluate architectural understanding and scalability considerations. Final HR Round: Discussion focused on compensation, availability, company policies, and final confirmation of mutual fit before proceeding with an offer.