Alstom Transportation Senior Analyst Interview Questions and Answers

General apti (maths) + english

Q1. Introduce yourself
Add your answer
Q2. You had 100% marks in 10th but only 65% in 12th. why what happened
Add your answer

Q1. Find tree node from leet code
Ans. 
Finding a tree node from LeetCode involves traversing a tree data structure to locate a specific node.
• Use depth-first search (DFS) or breadth-first search (BFS) to traverse the tree and find the target node.

• Implement a recursive function to search for the node in the tree structure.

• Consider using a stack or queue data structure to keep track of nodes to visit next.

• Check if the current node is the target node, if not, r...read more
Answered by AI
Add your answer
Q2. Guesstimates on how to fill 4lts jar with just three jars, the popular guesstimets
Add your answer

Q1. Why do you want to work here ?
Ans. 
I am impressed by the company's commitment to innovation and data-driven decision making.
• I admire the company's reputation for using cutting-edge technology in data analysis.

• I am excited about the opportunity to work with a talented team of data analysts.

• I believe my skills and experience align well with the company's goals and values.
Answered by AI
Add your answer
Q2. Why would you be a good fit
Ans. 
I have a strong background in data analysis, excellent problem-solving skills, and a passion for utilizing data to drive business decisions.
• I have a Bachelor's degree in Statistics and experience working with various data analysis tools such as Python, R, and SQL.

• I have a proven track record of successfully analyzing complex data sets and providing actionable insights to stakeholders.

• I am detail-oriented, organized, an...read more
Answered by AI
Add your answer

General engineering discussion about materials

Q1. It's a technical presentation about your project
Add your answer

Basic Business Aptitude

GD on any topic among a group of 5-10.

Q1. Have you ever worked in Siebel CRM or SAP?
Add your answer

Q1. Current Experience
Add your answer
Q2. Location Preference
Add your answer

Q1. What are joins and its types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer