I applied online. I interviewed at HCLTech (Bangalore Rural) in Oct 2024
Interview
Initial Screening:
The process usually begins with an initial screening call with a recruiter or HR representative.
They assess your qualifications, experience, and whether your profile matches the role.
Expect questions about your resume, work experience, current and expected salary, and notice period.
Interview questions [1]
Question 1
Data Modeling and Database Design:
Explain the difference between OLTP and OLAP databases.
How do you design a data warehouse? What are the key components?
What are the different types of schemas in data warehousing (e.g., star schema, snowflake schema)?
I applied through a recruiter. The process took 5 days. I interviewed at HCLTech
Interview
The interview terrible. The interviewer was not prepared and started reading CV in front of me. The vibe was very "I know it all and I can prove that you don't".
Attended Hackathon. given batch, stream pipeline scenario to develop in GCP platform and should find out metrics out of data within 5-6 hours. later based on the results. on the same day, client interview happens.
Interview questions [1]
Question 1
previous year project architecture?
about WIF credentials creation
it was very nice experience. Mosty architectural questions and scenario based coding Sql and pyspark. Spark architecture and conceptual questions. It was not that easy but a nice interview.
2nd round also focus on Project related stuffs along with data modelling and cicd
Interview questions [1]
Question 1
Azure Databricks architectural questions along with coding assessment