Motive Data Engineer interview questions

The interview process consisted of 5 rounds. 1. HR Screening Round Initial discussion about my background, experience, and why I was looking for a change. 2. Hiring Manager Round A deep dive into my previous projects and responsibilities. The discussion included scenario-based questions around data pipelines, data processing, and problem-solving approaches. 3. Technical Round (SQL / ETL) This round involved writing a SQL query to calculate a KPI/metric. There were also questions about Spark concepts and CI/CD deployment practices. 4. Stakeholder Round Focused on how I communicate with different stakeholders and end users, requirement gathering, and some data modeling concepts. 5. Top Grading Round A discussion with the Director of Analytics about my previous projects and overall experience. Outcome: After completing all rounds, I did not receive any update for around 15 days. I had to follow up with HR around 4-5 times to check the status of my application. HR mentioned that the consolidated feedback was not positive, but no specific feedback was provided. Overall, the interview discussions felt positive during the process, so the final outcome was a bit surprising.