Premium Employer
i
This company page is being actively managed by
HCLTech Team. If you also belong to the team, you
can get access from
here
HCLTech
Compare
Filter interviews by
HCLTech Ml Data Associate 1 Interview Questions and Answers
Updated
17 Sep 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Walk-in and was interviewed in Mar 2024.
3 Interview Rounds
1
Aptitude Test Round
There are 20 questions from verbal reasoning and 14 is the passing criteria and I got 18 from 20 to clear the first round.
2
Technical Round (2 Questions)
- Q1. Tell me about your project. View Answers (1)
- Q2. Basic concepts of DSA Add Answer
3
HR Round (2 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why you want to join HCL. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Just work on you aptitude first , then technical and most importantly on your communication skills as well.
What people are saying about HCLTech
View All
moonwalker
works at
Infocenter
Help in salary negotiation
I am a servicenow developer(technical lead) with 3.2 years of experience with the current salary of 11 LPA. What should be my expected salary in HCL tech. Currently holding an offer of 15.5 LPA(fixed). So considering HCL's variable+ fixed pay. What should I expect?
Got a question about HCLTech?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (7 Questions)
- Q1. How do you optimize SQL queries? View Answers (1)
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project. View Answers (1)
- Q3. What is SparkContext and SparkSession? View Answers (1)
- Q4. When a spark job is submitted, what happens at backend. Explain the flow. View Answers (2)
- Q5. Calculate second highest salary using SQL as well as pyspark. View Answers (1)
- Q6. 2 types of modes for Spark architecture ? View Answers (1)
- Q7. If you want very less latency - which is better standalone or client mode? View Answers (1)
2
Technical Round (2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset. Add Answer
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and ne...read more Add Answer
Interview Preparation Tips
Topics to prepare for LTIMindtree Data Engineer interview:
- SQL
- pyspark
- ETL
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Can you introduce yourself and describe your current project experience? View Answers (1)
- Q2. Decorators in python View Answers (1)
- Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space? View Answers (1)
- Q4. What are constructors in Python? View Answers (1)
- Q5. Indexing in sql View Answers (1)
- Q6. Why spark works well with parquet files? View Answers (1)
Skills evaluated in this interview
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)
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
2 Interview Rounds
1
HR Round (2 Questions)
- Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine? View Answers (1)
- Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients? View Answers (1)
2
One-on-one Round (2 Questions)
- Q1. Can you explain your project experience related to Advanced Excel and Power BI? View Answers (1)
- Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - If your resume is shortlisted, then there is a higher chance that you will be selected.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Aug 2024.
2 Interview Rounds
1
Technical Round (12 Questions)
- Q1. Tell me about yourself and Project View Answers (1)
- Q2. What was you day-to-day job in your project View Answers (1)
- Q3. Spark Architecture Add Answer
- Q4. How DAG handle Fault tolerance? View Answers (1)
- Q5. What is shuffling? How to Handle Shuffling? View Answers (1)
- Q6. What is the difference between repartition and Coelsce? View Answers (1)
- Q7. How do you handle Incremental data? View Answers (1)
- Q8. What is SCD ?? View Answers (1)
- Q9. Scenerio based questions related to Spark ? Add Answer
- Q10. Two SQL Codes and Two Python codes like reverse a string ? View Answers (1)
- Q11. Find top 5 countries with highest population in Spark and SQL View Answers (1)
- Q12. Using two tables find the different records for different joins View Answers (1)
2
One-on-one Round (7 Questions)
- Q1. What is a catalyst optimiser? How it works? View Answers (1)
- Q2. Tell me about the optimization you used in your project. View Answers (1)
- Q3. Pyspark question related to merging two schemas? Add Answer
- Q4. What is the best approach to finding whether the data frame is empty or not? View Answers (1)
- Q5. Spark Architecture Add Answer
- Q6. How do you decide on cores and worker nodes? View Answers (1)
- Q7. What happens when we enforce schema ? View Answers (1)
Interview Preparation Tips
Topics to prepare for Persistent Systems Senior Data Engineer interview:
- SQL
- Pyspark
- Python
- Spark
- Database
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. All questions based on databricks and some pyspark , python , SQL only. Add Answer
- Q2. Learn windows function implementation in databricks note book. Add Answer
2
HR Round (1 Question)
- Q1. This round about your salary discussion around. Add Answer
Interview Preparation Tips
Topics to prepare for Accenture Senior Data Engineer interview:
- Python
- Pyspark
- SQL
- Databricks
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
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Aug 2024.
2 Interview Rounds
1
Coding Test Round
*****, arjumpudi satyanarayana
2
Technical Round (5 Questions)
- Q1. What is the python language View Answers (1)
- Q2. What is the code problems View Answers (1)
- Q3. What is the python code View Answers (1)
- Q4. What is the project View Answers (1)
- Q5. What is the lnderssip View Answers (1)
Interview Preparation Tips
Topics to prepare for IBM Data Scientist interview:
- Python
- Machine Learning
Skills evaluated in this interview
HCLTech Interview FAQs
How many rounds are there in HCLTech Ml Data Associate 1 interview?
HCLTech interview process usually has 3 rounds. The most common rounds in the HCLTech interview process are Aptitude Test, Technical and HR.
Tell us how to improve this page.
HCLTech Interviews By Designations
- HCLTech Software Engineer Interview Questions
- HCLTech Technical Lead Interview Questions
- HCLTech Lead Engineer Interview Questions
- HCLTech Senior Software Engineer Interview Questions
- HCLTech Senior Analyst Interview Questions
- HCLTech Analyst Interview Questions
- HCLTech Technical Specialist Interview Questions
- HCLTech Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Data Engineer 1 Interview Questions
- Senior Data Analyst Interview Questions
- Ml Data Associate Interview Questions
- Show more
People are getting interviews through
based on 1 HCLTech interview
WalkIn
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Join HCLTech Find your spark and discover what drives you forward
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
22.2k
salaries
|  ₹1.2 L/yr - ₹8 L/yr |
|
Technical Lead
20.6k
salaries
| ₹6.9 L/yr - ₹25 L/yr |
|
Senior Software Engineer
15.4k
salaries
| ₹4 L/yr - ₹16.6 L/yr |
|
Lead Engineer
14.7k
salaries
| ₹4.2 L/yr - ₹14 L/yr |
|
Senior Analyst
13.9k
salaries
| ₹1 L/yr - ₹8.8 L/yr |
Explore more salaries
Compare HCLTech with
TCS
Compare
Wipro
Compare
Accenture
Compare
Cognizant
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 >
- HCLTech Interview Questions >
- HCLTech Ml Data Associate 1 Interview Questions
Share an Interview