Add office photos
Filter interviews by
L&T Technology Services Data Analyst Interview Questions and Answers
L&T Technology Services Data Analyst Interview Experiences
1 interview found
Selected
I applied via campus placement at Centre for Development of Advanced Computing (CDAC) and was interviewed before Apr 2023. There were 2 interview rounds.
(1 Question)
- Q1. Shuffle and merge in Haddop
- Ans.
Shuffle and merge are key processes in Hadoop for distributing data across nodes and combining results.
Shuffle is the process of transferring data from mappers to reducers in Hadoop.
Merge is the process of combining the output from multiple reducers into a single result.
Shuffle and merge are essential for parallel processing and efficient data analysis in Hadoop.
Example: In a word count job, shuffle will group words by...
(1 Question)
- Q1. Why this company?
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
RISHABH Pal
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
The Aptitude Test session accesses mathematical and logical reasoning abilities
(6 Questions)
- Q1. What is Vlookup
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. Some IF else Question in Excel
- Q3. What does your day in your previous organization look like?
- Ans.
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
Reviewing and cleaning large datasets to ensure accuracy
Creating visualizations and reports to communicate insights
Collaborating with team members to identify trends and patterns
Presenting findings to stakeholders in meetings or presentations
- Q4. Could you share the technical skills you possess?
- Ans.
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
Proficient in programming languages such as Python, R, SQL
Skilled in statistical analysis and data modeling techniques
Experience with data visualization tools like Tableau, Power BI
Knowledge of machine learning algorithms and techniques
- Q5. Can you explain what a Pivot Table is?
- Ans.
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.
Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.
Pivot tables are commonly used in Excel and other spreadsheet program...
- Q6. Find the Highest-paid employee in each department along with their salary and department name.
- Ans.
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
Group employees by department
Find the employee with the highest salary in each group
Retrieve the employee's name, salary, and department name
Interview Preparation Tips
- SQL
- Excel
- Problem Solving
- PowerBI
- SQL Queries
Be prepared to discuss past challenges and how did you overcome.
I applied via Job Fair and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. DAX Related Syntax and Codes
- Q2. Data Modelling, SQL, Python
(1 Question)
- Q1. No Response from HR after calling of selection after Round 1
I applied via Job Portal and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. General discussion of background and technical interview availability.Expected Salary,current salary
(8 Questions)
- Q1. Tell me about yourself.
- Q2. Which project have you recently worked on?
- Q3. How much experience do you have in python and R?
- Ans.
I have 3 years of experience in Python and 2 years in R.
3 years of experience in Python, used for data cleaning, analysis, and visualization.
2 years of experience in R, utilized for statistical analysis and data modeling.
Proficient in using libraries like pandas, numpy, matplotlib in Python and ggplot2, dplyr in R.
- Q4. What project have you worked on in R programming?
- Ans.
I have worked on a project in R programming analyzing customer churn for a telecommunications company.
Used R programming to clean and analyze customer data
Created visualizations to identify patterns and trends in customer behavior
Built predictive models to forecast customer churn rates
Collaborated with stakeholders to present findings and recommendations
- Q5. Which databases have you worked on?
- Ans.
I have worked on databases such as MySQL, SQL Server, and MongoDB.
MySQL
SQL Server
MongoDB
- Q6. Given a list of strings, find the string matching a particular pattern.
- Ans.
Find a string matching a specific pattern in a list of strings.
Use regular expressions to search for the pattern in each string.
Iterate through the list of strings and apply the pattern matching logic.
Return the string that matches the pattern, if found.
Example: List of strings - ['apple', 'banana', 'cherry'], pattern - 'ba' would return 'banana'.
- Q7. Given a list of dictionary, find the dictionary which has the count of key highest among all the dictionaries. eg: [{a:5},{b:2}.......] Now here 5 is the highest key value so it should be printed.
- Ans.
Find the dictionary with the highest count of keys in a list of dictionaries.
Iterate through the list of dictionaries and keep track of the dictionary with the highest count of keys.
Use a loop to count the keys in each dictionary and compare it with the current highest count.
Return the dictionary with the highest count of keys.
- Q8. Do you have experience in converting python scripts to R?
- Ans.
Yes, I have experience in converting Python scripts to R.
I have converted several Python scripts to R for data analysis projects.
I am proficient in both Python and R programming languages.
I can provide examples of projects where I have successfully converted Python scripts to R.
Interview Preparation Tips
- Python
- R programming
- Database
- Lists
- Dictionaries
- Data Structures
Focus on accessing elements from different structures and performing basic operations on them.
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Jun 2024. There was 1 interview round.
(7 Questions)
- Q1. I'm changing my domain because I don't see much scope for growth in my current domain and I want to make advantage of new opportunities for learning, creativity and success. Additional, I believe that the ...
- Q2. I understand that being asked to work for an extended number of hours comes with a good reason in the first place, so I'm ok with it.
- Q3. Over the year I have really upskilled my self. I believe based on the market standards for this particular role and my experience and skill set a salary range between 10000- 35000 would be fair and appreci...
- Q4. Can you share more about the day to day responsibilities of this role?
- Q5. If I am hired for this role, what would you want me to a achieve in my first two months?
- Q6. No ma'am certainly not. Before coming here, I read the job description thoroughly and I have the right skills and qualification required for the role.
- Q7. I believe a change in work environment with stimulate my creativity and drive for success.
Interview Preparation Tips
amol jadhav
(2 Questions)
- Q1. Excel Assignment
- Q2. SQL assignment : joints , data extraction
Data Analyst Interview Questions & Answers
NTT Data Information Processing Services
Anonymous
posted on 24 Sep 2024
(2 Questions)
- Q1. Self introduction
- Q2. What is mean by aml
- Ans.
AML stands for Anti-Money Laundering, which refers to a set of laws, regulations, and procedures designed to prevent criminals from disguising illegally obtained funds as legitimate income.
AML is a regulatory framework used by financial institutions to detect and prevent money laundering activities.
It involves monitoring customer transactions and reporting any suspicious activity to authorities.
Examples of AML measures...
Selected
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basis HR questions
- Q2. Answer confidently
(2 Questions)
- Q1. Based on previous work
- Q2. Answer correctly what you had worked in your previous work
Interview Preparation Tips
Data Analyst Interview Questions & Answers
Sutherland Global Services
Anonymous
posted on 11 Aug 2024
I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. Interesting facts about ourselves
- Q2. Introduced about ourselves
Rubesh Sekar
(1 Question)
- Q1. How SQL DB works
- Ans.
SQL DB works by storing and managing data in a structured format using tables and relationships.
SQL DB uses tables to store data in rows and columns.
It allows for querying data using SQL commands like SELECT, INSERT, UPDATE, DELETE.
Relationships between tables can be established using foreign keys.
Indexes can be used to optimize query performance.
ACID properties ensure data integrity and consistency.
Skills evaluated in this interview
L&T Technology Services Interview FAQs
Tell us how to improve this page.
L&T Technology Services Interviews By Designations
- L&T Technology Services Senior Engineer Interview Questions
- L&T Technology Services Technical Lead Interview Questions
- L&T Technology Services Associate Engineer Interview Questions
- L&T Technology Services Design Engineer Interview Questions
- L&T Technology Services Software Engineer Interview Questions
- L&T Technology Services Engineer Interview Questions
- L&T Technology Services Senior Software Engineer Interview Questions
- L&T Technology Services Graduate Engineer Trainee (Get) Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
L&T Technology Services Data Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Senior Engineer
5.3k
salaries
|  ₹5 L/yr - ₹17 L/yr |
|
Engineer
4.4k
salaries
| ₹1 L/yr - ₹8.9 L/yr |
|
Technical Lead
2k
salaries
| ₹8.2 L/yr - ₹26.9 L/yr |
|
Project Lead
1.6k
salaries
| ₹6 L/yr - ₹22.1 L/yr |
|
Senior Software Engineer
1.4k
salaries
| ₹4.8 L/yr - ₹18.2 L/yr |
TCS
Infosys
Wipro
Tech Mahindra
Calculate your in-hand salary
- Home >
- Interviews >
- L&T Technology Services Interview Questions >
- L&T Technology Services Data Analyst Interview Questions
