Sun Life Financial Data Engineer Interview Questions and Answers

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

Find an odd occurring number among even occurring numbers.

• Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

• Iterate through the array and XOR each element with the result variable.

• The final result will be the odd occurring number.

Print the spiral order of a binary tree and matrix.

• For binary tree, use level order traversal and alternate direction for each level.

• For matrix, use four pointers to traverse in spiral order.

• Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

• Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

Finding pairs in an array with a given sum.

• Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

• Use a hash table to store the elements of the array and their indices for faster lookup.

• If there are multiple pairs with the same sum, return any one of them.

• If no pair is found, return null or an empty array.

Find total number of k element with given avg in an array in minimum time complexity.

• Use sliding window technique to traverse the array in O(n) time complexity.

• Maintain a sum variable to keep track of the sum of elements in the window.

• If the sum of elements in the window is equal to k times the given avg, increment the count.

• Move the window by subtracting the first element and adding the next element in the array.

Printing non-boundary elements of a binary tree

• Traverse the tree in any order (preorder, inorder, postorder)

• Check if the current node is not a boundary node (not the first or last node in its level)

• If it is not a boundary node, print its value

• Recursively traverse its left and right subtrees

I cannot provide investment advice, but here are five companies that have shown strong financial performance in recent years.

• Apple - consistently high revenue and profit margins

• Amazon - dominant player in e-commerce and cloud computing

• Microsoft - strong growth in cloud computing and enterprise software

• Alphabet (Google) - diversified revenue streams and strong advertising business

• Visa - dominant player in the payments i

The Brexit vote could have both positive and negative effects on the Indian economy.

• Positive effects: Increased trade opportunities with the UK, potential for attracting foreign investments from companies relocating from the UK.

• Negative effects: Uncertainty in global markets leading to volatility in exchange rates, potential decline in exports to the UK.

• Example: Indian IT companies may face challenges due to stricter i...read more

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.

To find the frequency of each word in a sentence.

• Split the sentence into words

• Create a dictionary to store word frequency

• Iterate through the words and update the dictionary

• Return the dictionary