Piramal Capital Housing Finance Data Analyst Interview Questions and Answers

Q1. SQL related PL SQL , Stored PRocedures
Add your answer

Q1. It was more related to my projects
Add your answer
Q2. Asked questions on PCA,KNN and Elbow method .
Add your answer

Q1. Asked SVM and Logistic regression, their applications and real life uses
Add your answer
Q2. Matrix formation of a knockout Tournament
Add your answer

Q1. SQL Basics and Good Communication
Add your answer
Q2. Structured Profile Summary
Add your answer

Q1. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of a particular column in a database table to their physical storage locations on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that satisfy a certain condit...read more
Answered by AI
Add your answer

Pandas and SQL questions and some business case

Q1. The head of the vertical took interview, explained role and asked about my experience.
Add your answer
Q2. What project did you work on?
Add your answer

Q1. A senior data scientist asked technical questions on my experience.
Add your answer
Q2. What is the advantage or lstm over rnn.
Ans. 
LSTM has better memory retention than RNN.
• LSTM can remember long-term dependencies better than RNN.

• LSTM has a gating mechanism that controls the flow of information.

• LSTM can handle vanishing gradient problem better than RNN.

• LSTM is more suitable for tasks that require long-term memory, such as speech recognition and language translation.
Answered by AI
Add your answer
Q3. What is multicollinearity and what are its effects?
Ans. 
Multicollinearity is a phenomenon where two or more independent variables in a regression model are highly correlated.
• It can lead to unstable and unreliable estimates of regression coefficients.

• It can make it difficult to determine the individual effect of each independent variable on the dependent variable.

• It can also result in inflated standard errors and p-values, making it difficult to identify statistically signif...read more
Answered by AI
Add your answer

Q1. What is Ram? What is Rom?
Ans. 
RAM stands for Random Access Memory, a type of computer memory that can be accessed randomly. ROM stands for Read-Only Memory, a type of memory that stores data permanently.
• RAM is volatile memory used by the computer to store data and program instructions temporarily.

• ROM is non-volatile memory that stores firmware and cannot be easily modified or deleted.

• RAM is faster but loses data when power is turned off, while ROM ...read more
Answered by AI
View 1 more answer
Q2. Which language understand the computer?
Ans. 
Computers understand machine language, which is a set of binary codes representing instructions that the computer can execute.
• Computers understand machine language, which consists of binary code representing instructions.

• High-level programming languages like Python, Java, C++ are used to write code that is then translated into machine language.

• Compilers and interpreters are used to convert high-level code into machine
Answered by AI
View 1 more answer

Q1. What is the machine language?
Ans. 
Machine language is the lowest-level programming language that directly corresponds to instructions executed by a computer's CPU.
• Machine language consists of binary code representing instructions that can be executed by a computer's central processing unit (CPU)

• It is the lowest-level programming language and is specific to the type of CPU being used

• Machine language is difficult for humans to read and write, as it is co...read more
Answered by AI
View 1 more answer

Q1. What does BIOS works for?
Ans. 
BIOS works as a firmware that initializes hardware components during the boot process of a computer.
• BIOS stands for Basic Input/Output System

• It is responsible for initializing and testing hardware components like the CPU, memory, and storage devices

• BIOS also provides the necessary instructions for the operating system to boot up

• It is stored on a ROM chip on the motherboard
Answered by AI
View 1 more answer

Q1. Basic Machine Learning Question
Add your answer
Q2. Ask about Previous work or project
Add your answer

A coding test is an assessment used to evaluate a candidate's programming skills and problem-solving abilities. It typically involves solving problems using code within a specified time frame, often through platforms like HackerRank or LeetCode. The tests assess language proficiency, coding efficiency, and logical thinking.

An aptitude test is an assessment designed to evaluate a person's ability to perform specific tasks and react to a range of different situations. It measures cognitive abilities, problem-solving skills, logical reasoning, and sometimes specific skill sets relevant to a job or educational setting. These tests are commonly used in hiring processes, educational admissions, and career guidance.