The interview process consisted of:

• First round with HR
• Second technical round
• Third technical round
• Fourth and Fifth with the Hiring Manager in the US

My first interaction with HR was very negative. The HR representative was rude and seemed to assume I had a comprehensive understanding of the hiring process and the typical negotiations between a candidate and an HR representative. It felt like he should have been explaining these aspects to me as part of his role.

Given two objects:

• Images: Contains tags (e.g., tag1, tag2, tag3), imagename, image_URL, and propertyX.
• Brand: Contains brand information, with each brand (e.g., brand1, brand2) having associated tags.

Write code that provides an output depicting which images are related to what brands.

An SQL question roughly on the tables below:

Q: Write an SQL query to fetch the employees who are managers of more than one department.

Q: Employees that are employee managers, people managers, and department managers with a start date less than 3 years.

Table 1: Employee

• Employee_id
• employee_name
• manager_id
• start_date

Table 2: Department

• department_id
• department_name
• department_manager
• manager_id

Second Round:

Design a software system to operate a lift system in a building with over 40 floors. Design an object-oriented system.