Morgan Stanley Interview Experience | 1.5 Years Experienced
Coding Round:
Round 1:
- Find occurrences of a given element in a long sorted array
- Find the max element in an unsorted array.
- Bubble sort.
- Difference between class, package, module
- Iterators, mutable and immutable
- Find the missing number in the array
- Map and filter in python
- Joins
- Get nth highest salary from table SQL query given table has salary, name
- Get Max salary for each day in table given table(name, salary, date)
Round 2:
- Inheritance. Multiple inheritances in python?
- Polymorphism – Is runtime polymorphism is possible in python?
- Functional overloading in python? Using *Args as a function argument
- Decorators. How do you define it?
- Generators in python? Read file using generator without loading completely in memory
- Magic functions
- Solid Design principles
- Given an order and items write class diagrams – order has items and payment method
- Given employee table, find nth largest salary
- Given two tables, one employee(has employee_id and salary) and other relation(which has employee_id, manager_id), find those employees which have salary greater than their manager
- Given a gender column in table update male with female and vice versa
- Get the last 10 lines of a file using the Unix command
- Given two commands as pip command1 | command2, let command fails, what will be the result
- Find a particular pattern from a file(cat and grep command)
- Get line numbers 50 to 100 from a file
Round 3:
- Detailed project discussion
- https://www.w3wiki.net/pascal-triangle/
- Given a particular row and column for a triangle, get its actual value(You cannot create a whole triangle to get this value) – use recursion
- OOPS, concept, pillars of OOPS – inheritance, polymorphism, abstraction, encapsulation. Explain runtime and compile-time polymorphism, Is runtime polymorphism possible in python?
- Given a filename, table name, DB name, and DB vendor name(Oracle, MySQL) and two functions import and export design class diagram which should be extensible
- Given two tables, employee(id, name, gender,department_id) and department(id, name),
- i) Change the gender of male to female and vice versa
- ii) Get count of all employees from each department
Round 4(Managerial):
- Detailed Project discussion.
- Tell me your weakness and strengths. Give Example for that
- What are Morgan Stanley’s core values? Explain them
- What are unit and system testing?
- How will you build an automation framework?
- What does culture signify in a firm? If you are building your own company, what things you should keep in mind
- What do you like about the role which we are offering(mine was python dev)
- Why Morgan Stanley?
Contact Us