Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso HCLTech (Bangalore Rural) nel mese di ott 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 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)?
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 5 giorni. Ho sostenuto un colloquio presso HCLTech
Colloquio
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".
Ho presentato la mia candidatura di persona. Ho sostenuto un colloquio presso HCLTech
Colloquio
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.
Domande di colloquio [1]
Domanda 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
Domande di colloquio [1]
Domanda 1
Azure Databricks architectural questions along with coding assessment