Add office photos
Filter interviews by
HCL Group Data Engineer Interview Questions and Answers
Updated
24 Aug 2024
1 interview found
Sort by:
Popular
vaishnavi kale
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Explain your project structure ? View Answers (1)
- Q2. What is mean by dag ? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - No Result
Skills evaluated in this interview
Interview questions from similar companies
Sashikanta Parida
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (3 Questions)
- Q1. What are different type of joins available in Databricks? View Answers (1)
- Q2. How do you make your data pipeline fault tolerant? View Answers (1)
- Q3. What is AutoLoader? View Answers (1)
2
Technical Round (2 Questions)
- Q1. How do you connect to different services in Azure? View Answers (1)
- Q2. What are linked Services? View Answers (1)
Rutuja Bhagat
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (7 Questions)
- Q1. Difference between bigtable and bigquery. View Answers (1)
- Q2. How to remove duplicate rows from bigquery? find the month of a given date in bigquery. View Answers (1)
- Q3. What operator is used in composer to move data from gcs to bq View Answers (1)
- Q4. Write a code for this - input = [1,2,3,4]
output = [1,4,9,16] View Answers (1)
- Q5. Dataflow vs dataproc. View Answers (1)
- Q6. Architecture of bq. Query optimization techniques in bigquery. View Answers (1)
- Q7. RDD vs dataframe vs dataset in pyspark View Answers (1)
Lakshmi Narayana
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Explain adf questions in detail View Answers (1)
- Q2. Project related questions Add Answer
2
Technical Round (2 Questions)
- Q1. Project data related questions Add Answer
- Q2. Databricks and SQL interview questions Add Answer
Anonymous
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Jun 2024.
1 Interview Round
1
One-on-one Round (20 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Project Architecture Add Answer
- Q3. Rate yourself out of 5 in Pyspark , Python and SQL View Answers (1)
- Q4. How to handle duplicates in python ? View Answers (1)
- Q5. Methods of migrating Hive metdatastore to unity catalog in Databricks ? View Answers (1)
- Q6. Read a CSV file from ADLS path ? View Answers (1)
- Q7. There was a table provided on coding screen and asked to write different programs and SQL queries from the table and tell the approach you are taking ? Like age...read more Add Answer
- Q8. How many stages will create from the above code that I have written View Answers (1)
- Q9. Narrow vs Wide Transformation ? View Answers (1)
- Q10. What are action and transformation ? View Answers (1)
- Q11. What happens when we enforce the schema and when we manually define the schema in the code ? View Answers (1)
- Q12. What all the optimisation are possible to reduce the overhead of reducing the reading part of large datasets in spark ? View Answers (2)
- Q13. Write a sql query to find the name of person who logged in last within each country from Person Table ? View Answers (1)
- Q14. Difference between List and Tuple ? View Answers (1)
- Q15. Difference between Rank , Dense Rank and Row Number and when we are using each of them ? View Answers (1)
- Q16. What is List Comprehension ? View Answers (2)
- Q17. Tell me about the performance optimization done in your project ? Add Answer
- Q18. Difference between the interactive cluster and job cluster ? View Answers (1)
- Q19. How to add a column in dataframe ? How to rename the column in dataframe ? View Answers (1)
- Q20. Difference between Coalesce and Repartition and In which case we are using it ? View Answers (2)
Interview Preparation Tips
Topics to prepare for Accenture Data Engineer interview:
- Spark
- Databricks
- SQL
- Python
- ETL
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Walk-in
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Difference between rank and dense_rank, Left vs Left anti join View Answers (1)
- Q2. Python list comprehension, SQL query Add Answer
2
Behavioral Round (1 Question)
- Q1. Project related questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - No response from HR, even after clearing technical and managerial rounds
Skills evaluated in this interview
Abhishek Paithankar
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Aptitude Test Round
Aptitude test involved with quantative aptitude, logical reasoning and reading comprehensions.
2
Technical Round (2 Questions)
- Q1. Tell me your introduction. Add Answer
- Q2. Tell me about your skills. View Answers (1)
3
HR Round (2 Questions)
- Q1. Are you ready relocate,? View Answers (1)
- Q2. Document verification Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - If you are fresher first prepare for aptitude, because once aptitude get cleared you will get selected from the large compitition and then focus on your technical knowledge and managerial skills about the company.
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. About python, sql, pyspark Add Answer
- Q2. Spark Architecture. Add Answer
2
HR Round (2 Questions)
- Q1. When can you join. View Answers (1)
- Q2. . Add Answer
Aniket Ramgiri
Interview experience
Bad
Difficulty level
Easy
Duration
-
Result
-
I applied via Recruitment Consulltant and was interviewed in Oct 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. General Data Warehousing questions like explain your pipeline, how you implemented scd2? Add Answer
- Q2. SQL questions like increment top 5th salary by 10k, last day of month, etc. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Try not to join, doesn't look like a good place based on the interviewer attitude. He was in a rush to finish the interview and run away. He kept firing questions at me. Very bad experience.
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I was interviewed in Jun 2024.
1 Interview Round
1
Technical Round (13 Questions)
- Q1. How to remove Duplicates in Data frame using pyspark? View Answers (1)
- Q2. What is Broadcast join ? How is this useful View Answers (1)
- Q3. What is Re-Partition and Coalesce? How are these used? View Answers (1)
- Q4. Write Python code to Extract Pincode from Address Field in Dataframe using Pyspark? View Answers (1)
- Q5. Write a SQL to get Student names who got marks>45 in each subject from Student table View Answers (1)
- Q6. How to Enable Hive support in spark? View Answers (1)
- Q7. Explain Joins in spark using pyspark View Answers (1)
- Q8. How will you Join if two tables are large in pyspark? View Answers (1)
- Q9. What is df.explain() in pyspark View Answers (1)
- Q10. Explain spark architecture View Answers (1)
- Q11. What Purpose of Lineage graph ? View Answers (1)
- Q12. External Table vs Internal table View Answers (1)
- Q13. Assume below Dataframes DF1 (UserID,Name) DF2 (UserID,PageID,Timestamp,Events) Write code to Join the DF's, Count the No of Events and filter Users with 0 Event...read more View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Practice Pyspark,python and SQL Hands on
Skills evaluated in this interview
HCL Group Interview FAQs
How many rounds are there in HCL Group Data Engineer interview?
HCL Group interview process usually has 1 rounds. The most common rounds in the HCL Group interview process are Technical.
Tell us how to improve this page.
HCL Group Interviews By Designations
- HCL Group Software Engineer Interview Questions
- HCL Group Analyst Interview Questions
- HCL Group Senior Software Engineer Interview Questions
- HCL Group Technical Lead Interview Questions
- HCL Group Lead Engineer Interview Questions
- HCL Group Software Developer Interview Questions
- HCL Group Softwaretest Engineer Interview Questions
- HCL Group Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
31%
less
than the average Data Engineer Salary in India
View more details
|
Software Engineer
3.9k
salaries
|  ₹1.9 L/yr - ₹9.5 L/yr |
|
Technical Lead
3.6k
salaries
| ₹6.8 L/yr - ₹25 L/yr |
|
Senior Software Engineer
3k
salaries
| ₹4 L/yr - ₹14.2 L/yr |
|
Lead Engineer
2.7k
salaries
| ₹4.3 L/yr - ₹13 L/yr |
|
Senior Analyst
2.2k
salaries
| ₹1.6 L/yr - ₹10 L/yr |
Explore more salaries
Compare HCL Group with
HCLTech
Compare
TCS
Compare
Tata Group
Compare
Wipro
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- HCL Group Interview Questions >
- HCL Group Data Engineer Interview Questions
Share an Interview