Osfin.ai Interview Questions, Process, and Tips

Youll get hacker rank link for sql test pretty decent questions from leetcode and hackerrank were asked like easy ones

Technical round questions based on sql

Computer aptitude and aruthmetic aptitude were asked

Q1. What are indexes
Ans. 
Indexes are data structures that improve the speed of data retrieval operations in databases.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on columns in a database table to speed up SELECT queries.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer
Q2. Questions on joins
Add your answer
Q3. What is ETL and do you know where it us used
Ans. 
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a usable format, and load it into a data warehouse.
• Extract: Data is extracted from different sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, formatted, and transformed into a consistent structure.

• Load: The transformed data is loaded into a data warehouse for analysis and reportin...read more
Answered by AI
Add your answer

Q1. Do you know regex
Ans. 
Yes, I am familiar with regex and have experience using it for data analysis.
• Regex stands for regular expressions and is used for pattern matching in text data

• It allows for searching, extracting, and manipulating text based on specific patterns

• Example: using regex to extract email addresses from a dataset
Answered by AI
Add your answer
Q2. After that technical question they asked general hr questions and salary discussions
Add your answer

Q1. Root Cause Analysis for Sales down
Ans. 
Sales down root cause analysis involves identifying factors impacting sales performance.
• Review sales data to identify trends and patterns

• Analyze market conditions and competitive landscape

• Evaluate sales strategies and tactics

• Assess product pricing and positioning

• Consider external factors such as economic conditions or industry changes
Answered by AI
Add your answer
Q2. Product Design of uber for kids
Ans. 
Uber for kids is a safe and convenient transportation service designed specifically for children.
• Ensure background checks for drivers and implement strict safety protocols.

• Provide options for parents to track their child's ride in real-time.

• Offer child-friendly vehicles equipped with car seats and entertainment options.

• Allow parents to schedule rides in advance and set pick-up and drop-off locations.

• Implement a rating
Answered by AI
Add your answer

Q1. Easy array based coding question
Add your answer
Q2. About yourself and experience
Add your answer
Q3. JavaScript single thread or multi thread
Add your answer

To perform reconciliation using SQL and excel

Reasoning questions and some sql question

Q1. How to handle date different date formats
Ans. 
Handle date different date formats by standardizing them using a common format
• Identify all the different date formats present in the dataset

• Convert all dates to a common format (e.g. YYYY-MM-DD)

• Use libraries like pandas in Python to parse and standardize dates

• Handle missing or incorrect dates by setting them to a default value
Answered by AI
Add your answer
Q2. Regarding regex
Add your answer

Data analysis of a dataset, based on reconciliation.

Q1. - Explain different tools you have used before - Questions based on Excel and SQL
Add your answer

Q1. General organizational fit
Add your answer
Q2. Puzzle and guesstimates were asked.
Add your answer

Topic - Mysql and joins