I applied through a recruiter. The process took 1 week. I interviewed at HCLTech (New Delhi) in Aug 2024
Interview
Started with 2 rounds. Technical and Management one.
Round 1 -
Basic Python, SQL, Data Engineering, toolkit questions.
Round 2 -
System oriented data pipelines related questions.
Was hiring for some offshore client.
Interview questions [1]
Question 1
Dictionary based Python questions, basic SQL aggregations, JOINs, etc
It was first round of interview, and the interviewer started with direct round of questioning , rather than any introduction. questions asked on was scheduling, python coding.databricks and py spark.
Interview questions [1]
Question 1
how will you schedule job that runs 3 days a week .
I applied online. I interviewed at HCLTech (Bengaluru)
Interview
Interview was for 1 hours. Python and sql was mostly
Some theory based questions also asked about spark and hadoop.
Sql was easy to moderate.overall moderate interview. Eventhough selected in round 1, hr didnt contacted after. Sheduled for round 2 ,but cancelled and never called again.
Interview questions [1]
Question 1
Moving average in sql and pyspark.
One python coding in string i think