Tip 1 : Data structure
Tip 2 : Libraries in python panda, NumPy
Tip 3 : Sql and PlSql scripts
Tip 1 : Keep the resume short
Tip 2 : Highlight imp technology, contribute and add project details and your responsibility and role
Data Structure based round
Eda case study on insurance data
Visualise the data and write down the important points
Cleaned and analysed the data and performed some question and created graphs using matplotlib


‘RAILWAY_SYSTEM’() is a function that initializes your data structures.
‘CHECK_IN’( ‘PASS_ID’,’ STATION’, TIME) represents that passenger with passenger ID ‘PASS_ID’ checks in at the station named ‘STATION’ at time ‘TIME’.
A customer can only be checked into one place at a time.
‘CHECK_OUT’( ‘PASS_ID’,’ STATION’, TIME) represents that passenger with passenger ID ‘PASS_ID’ checks out at the station named ‘STATION’ at time ‘TIME’.
‘GET_AVERAGE_TIME(SOURCE, DEST) returns the average time it takes to travel from SOURCE to DEST.
The average time is computed from all the previous traveling times from SOURCE to DEST that happened directly, meaning a check-in at SOURCE followed by a check out from DEST.
If the functions calls are as follows:
CHECK_IN(1,‘Delhi’,10)
CHECK_OUT(1,‘Noida’,20)
GET_AVERAGE(‘Delhi’,’ Noida’)
CHECK_IN(5,‘Delhi’,12)
CHECK_OUT(5,‘Noida’,17)
GET_AVERAGE(‘Delhi’,’ Noida’)
So, the answers for the GET_AVERAGE calls will be 10 and 7.5 respectively.
For the first call, there is only one trip between Delhi and Noida, so the average is 10.
For the second call, there are two between these stations, so the average is (10+5)/2 = 7.5
It was a system design round. A simple question of system design was asked
Insurance life cycle and loan life cycle / Pipeline design
Practice some system design problem

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What is recursion?