I applied through a recruiter. I interviewed at DeepIntent (Pune) in Aug 2025
Interview
The interview consisted of three technical rounds. During the first round, I was asked about my projects and my resume was thoroughly reviewed. The second round included two medium-level SQL questions and a request to write a sample Python script for XGBoost modeling. The third and final round was with the CTO. Ultimately, I was told that my lack of experience in big data.
Interview questions [1]
Question 1
I have a table with date, campaignid, and impression columns. I need to write a SQL query to return campaignid, date, impression, and the percentage of daily impressions for each campaign.