Interview Questions

Tim F. - "One project that stands out involved building a customer segmentation dashboard for our marketing team using Power BI. The goal was to help them target campaigns more effectively by segmenting customers based on purchase behavior and demographics. Early in the project, I noticed significant data quality issues in the source tables coming from our CRM system. There were missing values in key fields like customer age and region, duplicate customer IDs, and inconsistencies in how product categories"See full answer

Kevin T. - "When a stakeholder’s request is ambiguous, I start by clarifying the goal and defining what “success” looks like. I ask targeted questions to understand the business problem, the timeframe, the scope/location, and who the analysis is for. Then I confirm definitions (metrics, segments, filters), agree on the expected output format, and restate the request back to them in one sentence before I begin."See full answer

Chetak C. - "Probability that one of the coupons is used = 1 - Probability that no coupon is used = 1 - nC0 p^0 * (1-p)^n = 1 -(1-p)^n"See full answer

Santhiya V. - "The single forward slash xpath is called the absolute xpath. The double forward slash is called the relative xpath. The double forward slash xpaths are the most preferrable ones as it directly points to the object by its name, id, label etc."See full answer

Sampada J. - "How Much Oil Does the U.S. Import (In Barrels Per Year)? Note: focusing solely on oil used for car gasoline, excluding cooking oil and other uses. Step 1: Estimate Total Cars in the U.S. U.S. Population: 300 million Adults with Driver’s Licenses (DLs): 60% of the population are adults who drive 300M × 0.6 = 180M adults with DLs Car Ownership: Assume 90% of adults with DLs own cars 180M × 0.90 = 160M cars Note: We are disregarding electric cars, buses"See full answer

Exponent - "You should be able to identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! Ask cl"See full answer

Georgi S. - "Predicting user behavior generally is hard, unless you incorporate in all your product changes some kind of psychology based trigger or make behavior science-driven changes. For example creating scarcity like Booking.com who tell you that the rooms are about to be booked by someone else, or that others are looking at the property or booking actively today. Otherwise you'd have to rely on A/B testing and feature flags to release and measure the impact of product updates. A/B testing is a statis"See full answer

Anonymous Unicorn - "input = [ {"topic": 1, "chapter": 1, "section": 1}, {"topic": 2, "chapter": 2, "section": 1}, {"topic": 3, "chapter": 2, "section": 2}, {"topic": 4, "chapter": 1, "section": 1}, {"topic": 5, "chapter": 1, "section": 1}, {"topic": 6, "chapter": 2, "section": 2}, {"topic": 7, "chapter": 2, "section": 2}, {"topic": 8, "chapter": 2, "section": 3}, ] expected_output = [ {'chapter': 1, 'sections': [ {'section': 1, 'topics': [ {'top"See full answer

Ramagiri P. - "Medallion architecture is a layered data architecture used in lakehouse systems. Data flows through Bronze, Silver, and Gold layers where each layer improves data quality. Bronze stores raw data, Silver contains cleaned and validated datasets, and Gold provides aggregated business-ready data for analytics and reporting bronzedf = spark.read.json("/landing/apidata") bronze_df.write.format("delta").save("/bronze/users")"See full answer

Luke P. - "A full stack developer could be summarized as the person who both writes the APIs and consumes the APIs. They are familiar with Databases/Data-layer services, middle-layer/application services and business logic, and finally familiar with the consumers whether front-end applications/UIs or other systems. They can understand the trade-offs up and down the stack, where to adjust along the service-call-path. Ideally they are comfortable programming both async calls (front end javascript promises, e"See full answer