Sample Answer
On a churn prediction project for about 250k subscription users, the initial dataset was pretty messy. I noticed right away that simple aggregates didn’t line up: active users in the event logs were 15% higher than in our billing system, and around 12% of rows had impossible timestamps (events logged after cancellation). I started with systematic data profiling: null rates, distinct counts by key, cross-table checks, and time-series sanity checks. I fixed issues in layers. First, I standardized IDs and joined against a “source of truth” customer master table, which resolved most duplicates and orphans. Then I applied outlier detection on numeric fields (z-scores and IQR) and capped or excluded clear logging errors. For missing values, I used domain-driven rules (e.g., “no event for 90 days” = inactive) and simple model-based imputation for a few continuous fields. To validate, I re-ran reconciliation against finance reports, did before/after KPI checks, and held back a raw sample to confirm that model lift (AUC) improved from 0.68 to 0.76 without weird behavioral shifts.
Keywords
In your resume you note improving or optimizing [a process, KPI, or metric]. What specific baseline metrics did you start from, what steps did you personally take, and how did you verify that the improvement was due to your changes rather than external factors?
Based on your hydrology and irrigation engineering background, explain how you would estimate the irrigation water requirement for a kharif crop in a semi-arid region of Gujarat. Walk me through each step: from reference evapotranspiration estimation, crop coefficient selection, effective rainfall calculation, to arriving at canal discharge for a given command area.
In your civil engineering studies, what specific design coursework or project work did you complete related to irrigation channels or canals (e.g., design of lined/unlined canals, distributaries, minors)? Describe one such design in detail, including how you determined discharge, permissible velocity, section dimensions, and lining choice for Gujarat-type soil and climate conditions.
Walk me through a recent multi-channel digital marketing campaign you managed end-to-end. How did you set objectives, choose channels, allocate budget, and measure success?
On your resume you mention working on a cross-functional project (e.g., involving multiple teams or stakeholders). Describe a situation from that project where priorities conflicted—how did you navigate the trade-offs and what was the final outcome?