Envirotech Services Interview Questions and Answers for Experienced

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.

Corporate actions are events initiated by a company that can affect its stock price and shareholders.

• Types of corporate actions include dividends, stock splits, mergers and acquisitions, spin-offs, and rights issues.

• Dividends are payments made to shareholders from a company's profits.

• Stock splits increase the number of shares outstanding while decreasing the price per share.

• Mergers and acquisitions involve the combinat...read more

Swift is a messaging system used for financial transactions. It has different types and fields for message processing.

• Swift messages are categorized into 5 types - MT0xx, MT1xx, MT2xx, MT3xx, and MT9xx

• Each type has its own set of fields for message processing

• For example, MT103 is used for Single Customer Credit Transfer and has fields like Sender's Reference, Receiver's Reference, Amount, Currency, etc.

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