Consultant & Software Engineering Interview Questions

Informations de contact

Prénom*

Nom*

Email*

Carrière et Objectifs

NB: À noter de remplir les trois premières questions en langue française

Quelles sont vos objectifs de carrière dans les 5 prochaines années?

Pensez-vous continuer votre carrière au Liban ou à l'étranger ? (5 lignes minimum)

Pourquoi voulez-vous travailler chez Aliston ?

Object Oriented Programming

Design the data model (UML or Entity-Relationship diagram) for an online book reader system

Database Questions

Write the SQL Query that returns the Contact FirstName, Contact LastName and Company Name from the following database tables:

Write the SQL statement that changes the Company of the Contact “Sami Johns” from “org2” to “org1”

Problem Solving

Definition of “Quintile”: any of five equal groups into which a population can be divided according to the distribution of values of a particular variable.

Which of the following statements BEST describes why the Managing Director of Aliston has engaged Cedars Tech?
--Select-- She believes that Aliston can become better at identifying customers who stop making purchases. She believes that Aliston can become better at identifying ways to encourage customers to spend more. She believes that, by focusing on the customers of greatest value, Aliston can drive renewed growth in their business. She believes that Aliston can predict the purchasing behaviour of its customers better

Which of the following CANNOT be concluded from the information presented in Exhibit 3 regarding the sample of customers analyzed? --Select-- Purchasing by customers in their first 90 days is an indicator of their value to Aliston in their first year Quintile 1 are the customers with the lowest profit margin for Aliston The average customer makes between 2 and 3 transactions in the first 90 days since signing up The average one-year customer value is $7.90

What is the correct ranking of the five quintiles in Exhibit 3 according to the average transaction revenue, from lowest to highest? --Select-- 1, 2, 4, 3, 5 1, 2, 3, 4, 5 1, 3, 2, 4, 5 1, 3, 2, 5, 4

If Aliston had driven higher purchasing from the new customers in Exhibit 3 so that the one year value of customers in Quintiles 1 thru 4 were each to increase to the next highest quintile, how much greater would Aliston’s total one year customer value have been?
--Select-- $6.5 million $2.5 million $650,000 $250,000

When comparing the pilot group to the control group, which of the following CAN be determined from the information provided in Exhibit 4 for customers who purchased Electronics in their first transaction?
--Select-- Percentage of total lift in number of transactions represented by each two week time segment Two-week time segment which had the greatest difference in number of transactions Difference in number of customers making transactions Percentage difference in average number of transactions per customer

If 10% of customers in the control group made transactions during the pilot, how many of the customers in the pilot group made transactions during the pilot?
--Select-- 11,700 10,170 5,850 5,085

Which of the following CANNOT be concluded from the information presented in Exhibit 4?
--Select-- Among customers whose first transaction was in ‘Other’, the pilot had greatest impact among those whose first transaction was more recent The pilot had greatest impact among customers whose first transaction was in Electronics The pilot had a positive impact on the number of transactions per customer for customers who made their first transaction 4-6 weeks before emails were sent The pilot had no overall impact on the likelihood of making further transactions among customers whose first purchase was in Clothing/ Apparel

Which of the following data from the pilot period would be LEAST useful to the team in further investigating the impact of the pilot on Aliston’s business?
--Select-- Breakdown of two-week time periods into weekly time periods Breakdown of data in ‘Other’ category to further levels of detail Percentage of pilot group emails that were not delivered and bounced back Average transaction value for pilot group and control group customers

Which of the following is MOST LIKELY to be the reason for the statement by the team member to the Managing Director?
--Select-- Customers may discover that they were not selected for the pilot and may be unhappy about this Customers who receive too many emails from the same company become less likely to open and read them The team are concerned about how well Aliston’s staff executed the pilot The Managing Director is concerned that customers in the control group were neglected

Communication

Cite examples of accomplishments where you have been an excellent communicator. (in English)