Open Financial Technologies Private Limited Senior Data Analyst Interview Questions and Answers

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Sql and pandas problems along mcqs on ML

Q1. Linear Regression
Add your answer
Q2. Basic Neural Network Implementation
Add your answer

Q1. Question about working of BERT
Add your answer
Q2. Word2vec explanation
Ans. 
Word2vec is a technique used to create word embeddings by training a neural network on a large corpus of text.
• Word2vec is a shallow neural network model that learns to represent words as vectors in a continuous vector space.

• It captures semantic relationships between words by placing similar words close together in the vector space.

• There are two main architectures for Word2vec: Continuous Bag of Words (CBOW) and Skip-gr...read more
Answered by AI
Add your answer

45 min , 45 questions

Q1. Technical question( PowerBI, data science)
Add your answer
Q2. Behaviourial question
Add your answer

Hackerrank test mostly on python and sql

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

Q1. Projects Mentioned in Resume
Add your answer
Q2. Related to Python, Pyspark
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.