I applied online. I interviewed at HCLTech (Bengaluru) in Jul 2024
Interview
The interview process at HCLTech for an Azure Data Engineer position (with 5-7 years of experience) consists of two rounds:
Round 1: You can expect questions on SQL, Python, and Spark internals, with difficulty ranging from easy to medium.
Round 2: This round will focus on your project experience, particularly questions related to building end-to-end data platforms.
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)?
Easy but HR were very unresponsive which will delay tha interview proces which has 3 rounds in total ( 2 tech and 1 hr) overall average experience with overall process and offer details.
Interview questions [1]
Question 1
Spark related questions with respect to architecture