It was okayish, not so difficult questions, medium level, with a bit more focussed on sql. python questions were also asked, and about data warehousing and ETL. Overall experience was cool.
Domande di colloquio [1]
Domanda 1
explain window functions and what functions it has.
Ho presentato la mia candidatura tramite l'università. Ho sostenuto un colloquio presso v4c.ai (Poona)
Colloquio
Totally 2- test rounds, 2 technical rounds, 1 HR round. The process was smooth. The test rounds were kinda difficult. Interviews were easy.It was for the data engineer role based out of Pune.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso v4c.ai (Mumbai) nel mese di gen 2026
Colloquio
Just another scam company with scam openings. I don't understand the purpose behind taking interviews when they don't want any candidates. I have seen this pattern in many companies. There are legitimate HRs, interviewers and 2-3 round of interviews. I cleared all the rounds within a week. After the final round, I didn't get any feedback so I called Sana who was the HR and she said the interviewers have given me a good feedback and toh have been selected. Then comes the complete ghosting. I had sent multiple emails after that resulting in no response. It's been 4 months now. What a useless company.
Domande di colloquio [1]
Domanda 1
Round 1:
How to change Soft delete as hard delete - CDC change logic
How do you handle sudden surge in data
Difference between materialized view, view and temp view
Have you been in a stakeholder meeting?
Dependency management in your ETL tool
How will you get notified when there is an error in pipeline
Difference between data lake, data warehouse and delta lake
How do you handle with duplication of data while ingesting
Round 2:
SQL query optimization methods
What is spark
Which AWS services have you used?
Self Rating in Python and SQL
Other than DE where have you used python?
Round 3:
Primary work, tools used
How do you ensure data quality in your pipelines?
Where do you deploy your code?
Why need of separate dbs, OLTP and OLAP?
Most recent project, use case and tools used
What is Autoloader in Databricks?
How do you manage schema evolution?
Why there was a need of real time streaming in your architecture?
When to use nested queries and CTE?