1st round mcq 1 hour 50 que on sql. 2nd round python interview 30-40 min (technical). then document collection and when i was submitting the documents in the afternoon, i got the email offer has been revoked . really what is going on don't know . totally the waste of time and efforts and later sent an email to hr and their other teams but they didn't responded be back. they have done same thing with many people u can find that on reddit, quora etc. don't resign from your company till their hr gives you in written over the email that offer if final and they will not revoke it.
I applied online. I interviewed at Accenture (Pune) in Dec 2025
Interview
The interview process consisted of 1–2 technical rounds focused mainly on Python, SQL, BigQuery, and Airflow. Questions were mostly hands-on and scenario-based, covering data transformations, joins, JSON handling, partitioning vs clustering, and workflow orchestration concepts. The interviewer also asked basic PySpark and Pandas questions, along with conceptual questions on data warehousing (e.g., Redshift, MPP). Overall, the discussion was practical, conversational, and implementation-focused rather than theory-heavy.
Interview questions [1]
Question 1
All techincal questions were asked and they are listed below
What is UNNEST in BigQuery?
How do you unnest JSON in BigQuery?
What is PythonOperator in Airflow?
What are custom Python functions in Airflow?
What is clustering vs partitioning in BigQuery?
What is a cron job in Airflow?
What is XCom push in Airflow?
What is a DAG in Airflow?
What are dependencies in Airflow?
What is Redshift?
What is MPP architecture?
What is a function in Airflow?