Trendlyne Technologies Senior Research Analyst Interview Questions and Answers for Experienced

Q1. Joins, SQL query execution
Add your answer
Q2. Simple Sals Question - SQL
Add your answer

Q1. Questions based on the understanding of joins in sql
Add your answer
Q2. Convert row to columns using sql
Ans. 
Use SQL pivot function to convert rows to columns
• Use the PIVOT function in SQL to convert rows into columns

• Specify the columns you want to pivot on and the values you want to display in the new columns

• Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name
Answered by AI
Add your answer

Q1. Joins, case when
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
• Joins are used to retrieve data from multiple tables based on a related column

• Case when is used to perform different actions based on different conditions in SQL queries

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...read more
Answered by AI
Add your answer

Q1. Result of different sql joins
Ans. 
SQL joins combine data from two or more tables based on a related column between them.
• Inner join returns rows that have matching values 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 all rows when there is a match in either left or right table
Answered by AI
Add your answer

Q1. What do you understand about mutual funds
Ans. 
Mutual funds pool money from multiple investors to invest in diversified portfolios of stocks, bonds, or other securities.
• Mutual funds are managed by professional fund managers who make investment decisions on behalf of investors.

• They offer diversification, reducing risk by spreading investments across various assets, e.g., a stock fund may invest in 50 different companies.

• Investors can choose from different types of m...read more
Answered by AI
Add your answer
Q2. Take me through your previous experiences
Ans. 
I have diverse experiences in project management, client relations, and team leadership across various industries.
• Managed a team of 10 in a successful product launch, increasing sales by 30% within the first quarter.

• Developed strong client relationships, resulting in a 25% increase in repeat business over two years.

• Led cross-functional teams to streamline processes, reducing project delivery time by 15%.
Answered by AI
Add your answer
Q3. Why do you want to choose groww
Ans. 
I am drawn to Groww for its innovative approach to finance and commitment to empowering users through technology and education.
• User-Centric Approach: Groww prioritizes user experience, making investing accessible to everyone, as seen in their intuitive app design.

• Educational Resources: The platform offers extensive educational content, helping users make informed financial decisions, like their investment courses.

• Innov...read more
Answered by AI
Add your answer

Q1. Tell me about yourself, what is your role in your company, list of the situation where you have under gone difficult situation.
Add your answer

Given a sample data to create a dashboard

Q1. About salary package
Add your answer
Q2. How work and home can be managed?
Ans. 
Work and home can be managed by setting boundaries, prioritizing tasks, delegating responsibilities, and practicing self-care.
• Set clear boundaries between work and home life to maintain a healthy balance.

• Prioritize tasks based on importance and deadlines to avoid feeling overwhelmed.

• Delegate responsibilities at work and home to lighten the load and prevent burnout.

• Practice self-care activities such as exercise, meditat...read more
Answered by AI
Add your answer

Q1. Start to end title search process
Ans. 
The title search process involves researching property records to ensure the seller has the legal right to sell the property.
• Obtain the property address and legal description

• Search public records for any liens, judgments, or other encumbrances

• Verify the seller's ownership of the property

• Review the chain of title to ensure a clear ownership history

• Prepare a title report outlining any issues found
Answered by AI
Add your answer
Q2. Liens and it's types
Ans. 
Liens are legal claims on assets to secure payment of a debt or obligation.
• Liens can be voluntary or involuntary

• Types of liens include mechanic's liens, tax liens, and judgment liens

• Liens can be placed on real property, personal property, or financial assets
Answered by AI
Add your answer
Q3. Judgment and it's types
Ans. 
Judgment refers to the ability to make decisions or form opinions objectively and wisely. Types include intuitive judgment, rational judgment, emotional judgment, and moral judgment.
• Intuitive judgment is based on instinct or gut feeling.

• Rational judgment involves logical reasoning and evidence-based decision-making.

• Emotional judgment is influenced by feelings and emotions.

• Moral judgment is based on ethical principles a...read more
Answered by AI
Add your answer