Shell Infotech Account Assistant Interview Questions and Answers

Q1. What is your name
Add your answer

Test was conducted on basic programming languages that consists of mcqs and coding questions

10-12 people are made into grps and are given a topic everyone has to support or oppose that particular topic within given time

Q1. Asked to write codes for given programs and also asked some puzzles and keywords and their uses in python like break , pass, continue, and slicing operation etc...
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Tell me about yourself.
Add your answer
Q5. Everything went very well , main thing you require is communication skills. Hr is very friendly and even cracked jokes in middle. He asked about the movie I have seen lately and asked me to explain the sto...read more
Add your answer

Prepare well on Python, SQL and be good at solving analytical problems

Q1. Mostly based on your resume, prepare to answer whatever you kept on resume. Still prepare well on Python, SQL... Go through AWS/Datawarehouse concepts if role is Data Engineering position
Add your answer

Q1. Lightly on Technical side, Mostly on testing how you're able to solve business problems
Add your answer

They asked few questions related to SQL.

Q1. They'll ask questions related to whatever you have given in your resume.
Add your answer

Q1. They ask general questions about yourself.
Add your answer

4 SQL questions, complexity 7/10

Q1. Previous projects
Ans. 
I worked on various projects involving data analysis, market research, and process optimization across different industries.
• Conducted a market analysis project for a tech startup, identifying key trends and customer preferences.

• Developed a predictive model for sales forecasting using historical data, improving accuracy by 20%.

• Collaborated with cross-functional teams to streamline reporting processes, reducing time spen...read more
Answered by AI
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

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
Ans. 
Estimate the average milk consumption in a city using population and consumption per person.
• Determine the population of the city. For example, if the city has 1 million residents.

• Estimate average milk consumption per person. For instance, if each person consumes about 1 liter of milk per week.

• Calculate total weekly consumption: 1 million people * 1 liter = 1 million liters per week.

• Convert weekly consumption to monthly...read more
Answered by AI
Add your answer

Q1. Why you want to join our comany?
Add your answer
Q2. What made you leave your previous organization
Ans. 
I left my previous organization to seek new challenges and opportunities for professional growth in a dynamic environment.
• Desire for career advancement: I wanted to take on more responsibilities and leadership roles.

• Seeking new challenges: I felt that I had reached a plateau in my previous position and wanted to explore new areas.

• Cultural fit: I was looking for an organization whose values and culture aligned more clos...read more
Answered by AI
Add your answer
Q3. Salary negotations
Add your answer