Interview Questions

Harshi B. - "SELECT DISTINCT title, ROUND(AVG(rating) over (partition by title),1) avg_rating, ROUND(AVG(rating) over (partition by genre),1) genre_rating FROM rating r JOIN movie m ON r.movieid=m.movieid ORDER by 1"See full answer

Rose G. - "I'm working on a Health Data Warehouse product, that would allow smoother medical research is a highly regulated environment, in France. 0 - In the Healthtech world, Government Regulations have to be taken into account. In my product's case, they work in our favor as procedures for medical research were extremely complex and limited, and the government recently allowed a new regulatory environment: the HDW. There is always a risk though that the government itself places itself as a competitor"See full answer

Jax H. - "Let’s pick SFO (because it's a stupid choice.. probably easier if you pick a smaller airport) We know each passenger has to go through the scan at least once We can assume 10% of passengers go through twice People only go through scans when they depart but not when they arrive International planes are bigger so carry more people so need to calculate separately Approach Estimate how many gates there are Estimate airport operation hours Estimate the numbe"See full answer

Rasika D. - "Message queue is like a buffer. Its has 3 parts: Producer -> which creates a message and sends it to the queue. Queue -> which acta like a buffer pipe and stores the message. Subscriber -> which processes and releases messages one by one in FIFO manner."See full answer

Shin K. - "First of all, there are different industries with different business in security measures which influence trends in the security industry as information they store and infrastructure they have are not the same. In this exercise, I'll take a look at the security industry in general and talk about the biggest trends from the perspectives of "lines of defense" for software in particular in: identify, data (on client and server side) and infrastructure. There are several topics associated with each"See full answer

Nitesh N. - "I would ask/investigate the following: Is this our core competancy of our company How long would it take to develop it in house and how much would it cost what will be the time to market of this feature or service when developed in house what is long term vision of this solution - do we expect that this will grow into becoming a major revenue stream for the company in future and the future of the company will be tied to it? What is our track record as a company building such a sol"See full answer

Lucas G. - "Because testing many engagement metrics at once increases the risk of finding effects that aren't real (the 'multiple comparisons problem'), you must adjust your criteria for statistical significance. For social media data, the Benjamini-Hochberg procedure is often a practical choice as it controls the rate of false discoveries (FDR) while still allowing you to detect genuine changes; however, the ideal adjustment method will vary depending on your specific number of metrics (e.g., use Bonferron"See full answer

Atharva P. - "Problem: Facebook Jobs has seen a 20% increase in job listings, but employer response time to applicants has decreased by 20%. Goal: Investigate and address the decrease in employer response time. Assumptions and Clarifying Questions: Scope: Is this issue internal to Facebook or affecting external users? Timeline: Analyzing data from the past 6 months is assumed to be sufficient. Response Time Definition: Clarify the precise definition of "response time" (e.g."See full answer

Dhruv M. - "Thankyou for asking me this answer. What makes me unique in data analytics is my ability to blend technical skills with a strong business mindset. I don’t just focus on building dashboards or running analyses-I always tie the insights back to real business impact. During my internship at Quantara Analytics, for example, I didn’t just track supplier KPI's. I redesigned the reporting process, which cut manual work by 60% and improved decision-making. I’m also proactive about learning tools like Po"See full answer

Coco H. - "These works often aren't comparable, so that I'd use a balanced portfolio of 20%-30% engineering needs and 70%-80% user needs to satisfy both sides. However, this is only a starting point, if engineering requests more than this baseline then I would use ROI to prioritize."See full answer

Gourav G. - "Skeleton: Mission Goals and User segmentation User journey Metrics Pain points and opportunities experimentation Starting with Twitter's mission, "the power to create and share ideas and information without barriers", we are looking to empower people to be both consumers and creators. However, for the sake of this discussion, I want to focus on the consumer sides. As mentioned, our goal is to focus on user growth. But I want to understand if we are looking to acquire more 1s"See full answer

Aneesha K. - "Test case is wrong. It expects to sort in asc order of month_year. -- Write your query here SELECT strftime('%Y-%m', createdat) AS monthyear, COUNT(DISTINCT userid) AS numcustomers, COUNT(t.id) AS num_orders, SUM(price * quantity) AS order_amt FROM transactions t INNER JOIN products p ON t.product_id = p.id GROUP BY month_year ORDER BY month_year ; "See full answer