Ekart Logistics Jr. Data Scientist Interview Questions and Answers

Q1. Sql based questions in first round and increased level in next rounds
Add your answer
Q2. Simple python questions
Add your answer
Q3. Guessestimate- process matters not answers
Add your answer

Q1. Hard SQL question
Add your answer

Q1. Sql based questions asked
Add your answer
Q2. Fit for the role
Add your answer

Q1. What is Bert and transformer
Ans. 
Bert and transformer are models used in natural language processing for tasks like text classification and language generation.
• Bert (Bidirectional Encoder Representations from Transformers) is a transformer-based model developed by Google for NLP tasks.

• Transformer is a deep learning model architecture that uses self-attention mechanisms to process sequential data like text.

• Both Bert and transformer have been widely use...read more
Answered by AI
Add your answer
Q2. NLP pre processing techniques
Ans. 
NLP pre processing techniques involve cleaning and preparing text data for analysis.
• Tokenization: breaking text into words or sentences

• Stopword removal: removing common words that do not add meaning

• Lemmatization: reducing words to their base form

• Normalization: converting text to lowercase

• Removing special characters and punctuation
Answered by AI
Add your answer

Q1. Basic questions
Add your answer
Q2. Strength weakness
Add your answer

Python test to check basic understanding of algo and classs

Q1. Discussion around project and technical round on ML
Add your answer

Q1. Basic culture check question and salary discussion expectation.
Add your answer

Q1. SQL questions regarding window functions
Add your answer
Q2. Calc retained revived new customer per month basis what are joins in sql what is dense rank
Ans. 
To calculate retained, revived, and new customers per month basis, joins in SQL and dense rank are used.
• To calculate retained, revived, and new customers per month basis, you would typically use SQL queries to join different tables containing customer data.

• Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Dense rank is a function in SQL that assigns a rank to each row ...read more
Answered by AI
Add your answer
Q3. How sql query work behind the scenes
Ans. 
SQL queries work by parsing and executing commands to retrieve data from databases.
• SQL query is written in a specific syntax to communicate with databases.

• The query is parsed by the database management system to understand the command.

• The database engine then executes the query to retrieve the requested data.

• Queries can involve selecting, updating, inserting, or deleting data from tables.

• Example: SELECT * FROM table_na
Answered by AI
Add your answer

Tv commercial case study regarding if we run campaign of product over television how can attribute it to spike or increase in tration which we see in our data.

Q1. Cultural fit round
Add your answer

Q1. Basic ML questions you can get those on any website by searching ML/Ds question
Add your answer
Q2. Some deep question on python like unpacking in python etc
Add your answer

How to improve the customer experience in OYO and How to maximise the business impact for a hotel

Scrape data from booking.com for Bangalore hotels for 10th Dec’19 to 15th Dec’19 and create a dashboard for OYO Vs Non-OYO hotels comparison!!

Q1. Tell me about your Salary Expectations
Add your answer
Q2. When can I join OYO and what are the relocation help is needed
Add your answer

15 MCQ, 2 coding round

Q1. What is PCA explain eigen values
Add your answer
Q2. How chatbot works really
Add your answer