Transsion Analyst Interview Questions and Answers

Join in SQL is used to combine rows from two or more tables based on a related column between them.

• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

Primary key is a unique identifier for each record in a database table.

• Primary key ensures each record in a table is uniquely identified

• It must contain unique values and cannot have NULL values

• Primary key can be a single column or a combination of columns

• Example: 'ID' column in a 'Users' table can be a primary key

I chose V Guard because of its strong reputation in the industry and this position because of my passion for financial analysis.

• V Guard is a well-established company known for its quality products and strong financial performance.

• I have always been interested in financial analysis and believe this position will allow me to utilize my skills and knowledge effectively.

• I am impressed by V Guard's commitment to innovation ...read more

Deferred tax is a concept where taxes are paid or received in a future period for transactions that have already occurred.

• Deferred tax arises due to differences in accounting and tax rules

• It can be a liability or asset on the balance sheet depending on the situation

• Examples include depreciation and inventory valuation differences

The Key Result Areas (KRAs) of my previous company included data analysis, reporting, and visualization to support decision-making processes.

• Analyzing large datasets to identify trends and patterns

• Creating reports and dashboards to communicate insights to stakeholders

• Collaborating with cross-functional teams to gather data requirements

• Automating data collection and processing tasks using tools like SQL and Python

ROI measures return on investment while ROIC measures return on invested capital.

• ROI is calculated by dividing net profit by total investment while ROIC is calculated by dividing operating income by invested capital.

• ROI is a profitability ratio while ROIC is an efficiency ratio.

• ROI is used to evaluate the success of a specific investment while ROIC is used to evaluate the efficiency of a company's use of capital.

• Exampl...read more