Skip to contentSkip to footer

It Program Manager Interview Questions

Salaries
Interviews

7,687 it program manager interview questions shared by candidates

Multiple (10?) non-technical behavioral questions. Some very strange and "progressive" subjects. Not sure what the expected answers were supposed to be but several of the questions were focused on "sensitive" topics such as diversity in the workplace, how to grade employee performance, etc. Very uncomfortable interview, not knowing which way to go with STAR questions (remain business focused or go left of center). Pretty sure that I am better versed in the subjects discussed than those who conducted the interview based upon their inability to answer even basic questions related to the STAR questions they were asking. Overall, not a good experience. Nothing like what I expected and no questions related to the technical nature of the posted position. One of those interviews where I'd really love to know what the correct answers were. Time: >1 hr.
avatar

IT Manager

Interviewed at Allstate

3.5★
Jan 18, 2020

Multiple (10?) non-technical behavioral questions. Some very strange and "progressive" subjects. Not sure what the expected answers were supposed to be but several of the questions were focused on "sensitive" topics such as diversity in the workplace, how to grade employee performance, etc. Very uncomfortable interview, not knowing which way to go with STAR questions (remain business focused or go left of center). Pretty sure that I am better versed in the subjects discussed than those who conducted the interview based upon their inability to answer even basic questions related to the STAR questions they were asking. Overall, not a good experience. Nothing like what I expected and no questions related to the technical nature of the posted position. One of those interviews where I'd really love to know what the correct answers were. Time: >1 hr.

Suppose you are managing an e-commerce database for a company that sells products globally. The company's database schema includes multiple tables: Orders, Customers, Products, and OrderDetails. Your task is to extract information about orders that were placed for a specific product category, within a certain price range, and between two specific dates. Additionally, you need to include customer information and handle translations for product names. Database Schema: Orders: OrderID (Primary Key) CustomerID (Foreign Key) OrderDate Customers: CustomerID (Primary Key) CustomerName Country Products: ProductID (Primary Key) ProductName_EN (Product name in English) ProductName_FR (Product name in French) CategoryID (Foreign Key) UnitPrice OrderDetails: OrderDetailID (Primary Key) OrderID (Foreign Key) ProductID (Foreign Key) Quantity Question: Write an SQL query to retrieve the following information: OrderID, OrderDate, CustomerName, Country, ProductName (in English), UnitPrice, and TotalPrice (Quantity * UnitPrice) for orders placed for products in the 'Electronics' category, with a UnitPrice between £500 and £1000, and OrderDate between 1st January 2023 and 31st March 2023. Ensure that you handle translations for the product names, displaying them in English. If a product name is not available in English, display the French name. Include all orders, even if there are no details (i.e., use LEFT JOIN).
avatar

IT Manager

Interviewed at AutoRek

3.7★
Mar 27, 2024

Suppose you are managing an e-commerce database for a company that sells products globally. The company's database schema includes multiple tables: Orders, Customers, Products, and OrderDetails. Your task is to extract information about orders that were placed for a specific product category, within a certain price range, and between two specific dates. Additionally, you need to include customer information and handle translations for product names. Database Schema: Orders: OrderID (Primary Key) CustomerID (Foreign Key) OrderDate Customers: CustomerID (Primary Key) CustomerName Country Products: ProductID (Primary Key) ProductName_EN (Product name in English) ProductName_FR (Product name in French) CategoryID (Foreign Key) UnitPrice OrderDetails: OrderDetailID (Primary Key) OrderID (Foreign Key) ProductID (Foreign Key) Quantity Question: Write an SQL query to retrieve the following information: OrderID, OrderDate, CustomerName, Country, ProductName (in English), UnitPrice, and TotalPrice (Quantity * UnitPrice) for orders placed for products in the 'Electronics' category, with a UnitPrice between £500 and £1000, and OrderDate between 1st January 2023 and 31st March 2023. Ensure that you handle translations for the product names, displaying them in English. If a product name is not available in English, display the French name. Include all orders, even if there are no details (i.e., use LEFT JOIN).

Viewing 661 - 670 interview questions

Glassdoor has 7,687 interview questions and reports from It program manager interviews. Prepare for your interview. Get hired. Love your job.