Trantor Underwriter Interview Questions and Answers

Aptitude and combined coding tests

Q1. Design a parking app or design a web or mobile app where farmers can directly sell their produce
Ans. 
Design a web/mobile app for farmers to directly sell their produce.
• Create a user-friendly interface for farmers to list their produce

• Include features for farmers to set prices and quantities

• Implement a search function for buyers to find specific produce

• Include a secure payment system for transactions

• Allow farmers to track their sales and manage inventory
Answered by AI
Add your answer

Q1. You have to explain the design of your previous round
Add your answer

Worst experience company is not so good

Q1. What is object oriented programming
Ans. 
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
• OOP focuses on creating objects that interact with each other to solve problems

• Encapsulation, inheritance, and polymorphism are key principles of OOP

• Examples of OOP languages include Java, C++, and Python
Answered by AI
Add your answer
Q2. Questions on data structute
Add your answer

Aptitude test :Numerical,Logical and Behavioral

Group discussion - Conducted among 6-12 people

Q1. Introduction,Guesstimates & basic programming
Add your answer

Q1. Project explanation:Final year project
Add your answer

Q1. General HR discussion: Intro,Reasons for joining here
Add your answer

There were 48 questions to be done in 60 minutes.
the platform used was below average.
about 1400 gave the test

The Next round was a GD.
about 250 were shortlisted.
it was held in groups of 10 - 13.
there were 2 Panelists observing the body language, the fluency and time you speak for.
It is very important that you either start or conclude the GD.
leaves a good impression.

Q1. Tell me about yourself
Add your answer
Q2. What is Data Analysis?
Ans. 
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information.
• It involves collecting and organizing data

• It includes statistical analysis and visualization

• It helps in making informed decisions

• Examples include market research, financial analysis, and scientific research
Answered by AI
Add your answer
Q3. SQL Queries using Joins and sub-queries
Ans. 
SQL Queries using Joins and sub-queries
• Joins are used to combine rows from different tables based on a related column

• Sub-queries are queries nested within another query

• Joins and sub-queries can be used together to retrieve specific data from multiple tables
Answered by AI
View 1 more answer
Q4. Many questions about projects mentioned in the resume.
Add your answer
Q5. Estimation and probability questions were asked to see the way you approach a question logically.
Add your answer

Q1. Tell me about Yourself
Add your answer
Q2. Again Questions based on resumes
Add your answer
Q3. Some Regular HR Questions like why latent view, where to do you yourself in 5 years.....etc.
Add your answer
Q4. Any questions for me?
Add your answer

Topics will be mainly SQL and few python questions. Duration-3min to 1hr

Q1. What is CLT theorem and what are its uses
Ans. 
CLT theorem states that the distribution of sample means approaches a normal distribution as sample size increases.
• Central Limit Theorem (CLT) is a fundamental concept in statistics that states that the distribution of sample means approaches a normal distribution as the sample size increases.

• It is used in hypothesis testing, confidence intervals, and in estimating population parameters.

• CLT is essential in making infer...read more
Answered by AI
Add your answer
Q2. Asked to write SQL queries which uses join and window functions
Add your answer
Q3. Explain ML Data preparation and EDA steps in detail. What are major steps in preprocessing
Ans. 
ML data preparation involves cleaning, transforming, and organizing data for analysis. EDA involves exploring and visualizing data to understand its characteristics.
• Data cleaning: removing missing values, handling outliers, and dealing with duplicates

• Data transformation: encoding categorical variables, scaling numerical features, and creating new features

• Data organization: splitting data into training and testing sets,...read more
Answered by AI
Add your answer

Q1. Mainly interviewer checked how sound I was in different concepts like statistics, ML
Add your answer
Q2. Asked simple DL questions
Add your answer
Q3. Guestimates- like how much milk is consumed in your city on average. Give an estimate and show your structured way of arriving at that value
Add your answer

Q1. Why you want to join our comany?
Add your answer
Q2. What made you leave your previous organization
Add your answer
Q3. Salary negotations
Add your answer

Q1. SQL based questions
Add your answer
Q2. Logic based questions
Add your answer

Q1. Situation based questions
Add your answer
Q2. Questions related to company
Add your answer

4 SQL questions, complexity 7/10

Q1. Previous projects
Add your answer
Q2. In and around ML models
Add your answer

Q1. Usual, simple behavioural
Add your answer
Q2. Expected package
Add your answer