J'ai postulé en ligne. J'ai passé un entretien chez HCLTech (Bangalore Rural) en oct. 2024
Entretien
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.
Questions d'entretien [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)?
J'ai postulé via un recruteur. Le processus a pris 5 jours. J'ai passé un entretien chez HCLTech
Entretien
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".
J'ai postulé en personne. J'ai passé un entretien chez HCLTech
Entretien
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.
Questions d'entretien [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
Questions d'entretien [1]
Question 1
Azure Databricks architectural questions along with coding assessment