Infotact Solutions Data Analyst Intern Interview Questions and Answers

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

First round was a coding test online with screen monitoring

Q1. Hacker rank code for no reason for de
Ans. 
The question is unclear and requires further clarification.
• Request for more information on the specific requirements of the code.

• Ask for clarification on the purpose of the code.

• Determine the programming language to be used.
Answered by AI
Add your answer
Q2. Python sort element of string array by alphabet weightage and resolve all 23 test cases that nobody can
Ans. 
Sort string array elements by alphabet weightage in Python and pass 23 test cases.
• Use the sorted() function with key parameter to sort elements by weightage

• Define a function to calculate weightage of each character

• Test the function with various test cases to ensure accuracy
Answered by AI
Add your answer

Q1. Spark, AWS, Python
Add your answer

Q1. Python, SQL, Spark
Add your answer

Q1. Salary discussion
Add your answer

Q1. General Interview
Add your answer

BASIC PYTHON AND SQL

Q1. Questions based on past experience
Add your answer
Q2. My roles and responsibilities
Add your answer

Q1. Easy HR questions
Add your answer

You will receive a test link in which you will have 4 mcq ,1 python problem and 1 sql question

Q1. This was also coding round on hackerrank with one moderator
Add your answer

Python, SQL questions were in the initial round of hiring process.

Q1. ML, DL & knowledge about Cloud were main focus of the interview.
Add your answer
Q2. Questions around your resume
Add your answer

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer