10+ Sri Lakshmi Textiles Interview Questions and Answers

I analyse credit metrics of a firm by evaluating financial statements, debt levels, profitability, liquidity, and industry trends.

• Reviewing financial statements to assess revenue, expenses, and profitability

• Analyzing debt levels and debt-to-equity ratios to evaluate financial leverage

• Assessing liquidity ratios such as current ratio and quick ratio to determine short-term solvency

• Examining industry trends and economic factors that may impact the firm's creditworthiness

Contractual obligations are legally binding agreements between parties, while structural obligations are inherent responsibilities within a system or organization.

• Contractual obligations are based on agreements between parties, often outlined in contracts or agreements.

• Structural obligations are inherent responsibilities within a system or organization, such as following policies and procedures.

• Contractual obligations can be enforced through legal action if not fulfilled, whi...read more

Options and futures are both derivative contracts, but differ in terms of their obligations and flexibility.

• Options give the holder the right, but not the obligation, to buy or sell an asset at a predetermined price within a specified time period.

• Futures, on the other hand, require both parties to fulfill the contract at a future date, regardless of market conditions.

• Options provide more flexibility as they allow investors to choose whether or not to exercise the contract.

• Fut...read more

NAV stands for Net Asset Value, GAV stands for Gross Asset Value, Hedge Funds are investment funds that use various strategies to generate returns, and the most important financial statement is the balance sheet.

• NAV is the value of a fund's assets minus its liabilities, calculated on a per-share basis.

• GAV is the total value of a fund's assets before accounting for expenses or fees.

• Hedge Funds are alternative investments using pooled funds that employ different strategies to e...read more

Monitor overnight data load job in Snowflake

• Set up alerts and notifications for job completion or failure

• Check job logs for any errors or issues

• Monitor resource usage during the data load process

• Use Snowflake's query history to track job progress

• Implement automated retries in case of failures

Use SQL functions like SUBSTRING and CHARINDEX to split staged data's row into separate columns

• Use SUBSTRING function to extract specific parts of the row

• Use CHARINDEX function to find the position of a specific character in the row

• Use CASE statements to create separate columns based on conditions

Hedge funds, futures, and options are financial instruments used for investment and risk management in the stock market.

• Hedge funds are investment funds that use various strategies to generate high returns for investors.

• Futures are financial contracts that obligate the buyer to purchase an asset or the seller to sell an asset at a predetermined price on a specified future date.

• Options are financial contracts that give the buyer the right, but not the obligation, to buy or sel...read more

Equity represents ownership in a company while debt represents borrowed money that needs to be repaid with interest.

• Equity represents ownership in a company while debt represents borrowed money that needs to be repaid with interest.

• Equity holders have a share in the profits and losses of the company while debt holders receive fixed interest payments.

• Equity is riskier than debt as the returns are not guaranteed while debt is less risky as the interest payments are fixed.

• Exampl...read more

Design a database schema for Employees and Salaries

• Create an Employees table with columns like employee_id, name, department_id, etc.

• Create a Salaries table with columns like employee_id, salary_amount, start_date, end_date, etc.

• Use foreign keys to establish relationships between the two tables

Use SQL query to find employee with 2nd highest salary

• Use ORDER BY and LIMIT in SQL query

• Select the salary column and use DESC to get highest salary first

• Skip the first row using OFFSET 1 to get the second highest salary