TresVista Data Engineer Interview Questions and Answers

Data manipulation using pandas and SQL

• Pandas is a Python library used for data manipulation and analysis

• SQL is a language used for managing relational databases

• Pandas can read data from SQL databases using the read_sql() function

• Data can be filtered, sorted, grouped, and aggregated using pandas functions

• SQL queries can be executed using pandas' read_sql_query() function

Amortization is the process of spreading out a loan into smaller, regular payments over a period of time.

• It is used to pay off a debt over time with regular payments

• Each payment includes both principal and interest

• The amount of interest decreases over time as the principal is paid off

• Examples include mortgages, car loans, and student loans

WASO is Wake After Sleep Onset, TSO is Total Sleep Time, and EPS is Earnings Per Share.

• WASO is the amount of time spent awake after initially falling asleep.

• TSO is the total amount of time spent sleeping, including both REM and non-REM sleep.

• EPS is a financial metric that represents the portion of a company's profit allocated to each outstanding share of common stock.

• WASO and TSO are commonly used in sleep studies, whi

The financial statements (BS, IS, CF) have common elements such as assets, liabilities, equity, revenue, expenses, and cash flows.

• Assets: resources owned by the company

• Liabilities: obligations owed by the company

• Equity: residual interest in the assets of the company

• Revenue: income generated by the company

• Expenses: costs incurred by the company

• Cash flows: inflows and outflows of cash

A stock split increases the number of shares outstanding and decreases the price per share, but does not affect the market capitalisation.

• Stock split does not affect the total value of the company

• Market capitalisation remains the same after a stock split

• Stock split increases the number of shares outstanding and decreases the price per share

• For example, if a company has 1 million shares outstanding and the stock splits ...read more

Cash flow statements have three main components: operating activities, investing activities, and financing activities.

• Operating activities: cash inflows and outflows from the company's core business operations.

• Investing activities: cash inflows and outflows from buying or selling long-term assets.

• Financing activities: cash inflows and outflows from borrowing or repaying debt, issuing or buying back stock, and paying di...read more

EPS is calculated by dividing the company's net income by the number of outstanding shares.

• EPS = Net Income / Outstanding Shares

• Net Income is the company's total earnings after expenses and taxes

• Outstanding Shares are the total number of shares issued by the company

• EPS is an important metric for investors to evaluate a company's profitability

• Higher EPS indicates better profitability and potential for higher dividends