London Stock Exchange Group
60+ Mil Power Converter Technologies India Interview Questions and Answers
Q1. What is money market? explain types of fixed income.
Money market is a segment of the financial market where short-term borrowing and lending takes place. Fixed income refers to investments that provide a fixed return.
Money market deals with short-term borrowing and lending
Fixed income investments provide a fixed return
Types of fixed income include government bonds, corporate bonds, municipal bonds, and certificates of deposit
Money market instruments include treasury bills, commercial paper, and repurchase agreements
Q2. Tell me about primary and secondary market .
Primary market is where new securities are issued and sold for the first time, while secondary market is where existing securities are traded among investors.
Primary market involves the issuance of new securities by companies or governments.
Investors purchase these new securities directly from the issuer.
Examples of primary market transactions include initial public offerings (IPOs) and bond issuances.
Secondary market is where previously issued securities are bought and sold....read more
Q3. What is money market instruments
Money market instruments are short-term, low-risk securities that provide liquidity to the financial system.
Money market instruments are typically issued by governments, corporations, and financial institutions.
Examples include treasury bills, commercial paper, certificates of deposit, and repurchase agreements.
They are considered low-risk because they have a high credit rating and a short maturity period.
Money market instruments are used by investors to park their funds temp...read more
Q4. Tell us other stock exchange around the world?
Some other stock exchanges around the world include the London Stock Exchange, Tokyo Stock Exchange, and Hong Kong Stock Exchange.
London Stock Exchange
Tokyo Stock Exchange
Hong Kong Stock Exchange
Q5. Tell me about derivatives and types of derivatives.
Derivatives are financial contracts that derive their value from an underlying asset or security.
Types of derivatives include futures, options, swaps, and forwards.
Futures are contracts to buy or sell an asset at a predetermined price and date.
Options give the holder the right, but not the obligation, to buy or sell an asset at a predetermined price and date.
Swaps involve exchanging cash flows based on different financial instruments.
Forwards are similar to futures, but are c...read more
Q6. Explain to me a program written in Java that has a UI to take inputs of two integers and send them to a server to add them up. What are the tech stacks that you would preferably use?
Q7. What is capital market
Capital market is a financial market where long-term securities like stocks, bonds, and other financial instruments are traded.
Capital market is a platform for companies to raise long-term funds from investors.
It includes both primary and secondary markets.
Investors can buy and sell securities like stocks, bonds, and debentures in the capital market.
The capital market is regulated by the Securities and Exchange Board of India (SEBI) in India.
Examples of capital markets includ...read more
Q8. What is IPO and give me Example
IPO stands for Initial Public Offering, which is the first time a company sells its stock to the public.
IPO is a way for companies to raise capital by offering shares of their stock to the public for the first time.
Investors can buy these shares and become part owners of the company.
Examples of successful IPOs include Facebook, Alibaba, and Uber.
Q9. 2. what are affiliated, subsidiaries?
Affiliated and subsidiaries are related companies that are connected to a parent company.
Affiliated companies are those that are closely related to a parent company, often through shared ownership or control.
Subsidiaries are companies that are controlled by another company, known as the parent company.
Affiliated and subsidiaries often share resources, branding, and strategic goals with the parent company.
Examples of affiliated and subsidiaries include Google and its parent co...read more
Q10. Do you understand financial statements?
Yes, I understand financial statements.
I have a strong understanding of financial statements and their components.
I am familiar with the balance sheet, income statement, and cash flow statement.
I can analyze financial statements to assess a company's financial health and performance.
I have experience interpreting financial ratios and trends.
I can identify key financial indicators and make informed decisions based on the information provided.
Q11. Why is necessary for a balance sheet to tally
A balance sheet must tally to ensure accuracy in financial reporting and to provide a clear snapshot of a company's financial position.
Tallying the balance sheet ensures that assets equal liabilities plus equity, providing a true financial picture.
It helps in identifying errors or discrepancies in financial records.
Tallying the balance sheet is crucial for accurate financial reporting and decision-making.
Investors, creditors, and other stakeholders rely on a balanced balance ...read more
Q12. What is derivatives
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage.
Common types of derivatives include options, futures, forwards, and swaps.
Derivatives allow investors to take positions on the price movements of assets without owning the assets themselves.
They are often used by financial institutions, corporations, and individual investors to manage risk or to speculate on ma...read more
Q13. What is hedging
Hedging is a risk management strategy used to offset potential losses by taking an opposite position in a related asset or security.
Hedging involves making an investment to reduce the risk of adverse price movements in an asset.
It is commonly used in financial markets to protect against potential losses.
Examples of hedging include buying a put option to protect against a decline in the price of a stock or using futures contracts to lock in a future price for a commodity.
Hedgi...read more
Q14. What is mutual fund
A mutual fund is a type of investment vehicle consisting of a portfolio of stocks, bonds, or other securities, managed by a professional fund manager.
Mutual funds pool money from multiple investors to invest in a diversified portfolio of securities.
Investors buy shares of the mutual fund, which represent their ownership in the fund's holdings.
Mutual funds are managed by professional portfolio managers who make investment decisions on behalf of the investors.
They offer diversi...read more
Q15. What OOPS concepts are implemented in my project
Encapsulation, Inheritance, Polymorphism, Abstraction
Encapsulation: Data hiding and bundling of data with methods. Example: Using private variables and public methods.
Inheritance: Reusing code and creating a hierarchy of classes. Example: Subclass inheriting properties and methods from a superclass.
Polymorphism: Ability to present the same interface for different data types. Example: Method overloading and overriding.
Abstraction: Hiding complex implementation details and show...read more
Q16. What data structures are good for certain scenarios
Different data structures are suitable for different scenarios based on their characteristics and operations.
Arrays are good for storing a collection of elements with constant time access to individual elements.
Linked lists are good for frequent insertions and deletions at any position in the list.
Hash tables are good for fast lookups and insertions based on key-value pairs.
Trees are good for hierarchical data representation and efficient searching.
Graphs are good for represe...read more
Q17. What are the performance tuning options in snowflake?
Performance tuning options in Snowflake include clustering, materialized views, query profiling, and resource monitoring.
Use clustering keys to organize data for faster query performance
Create materialized views to pre-aggregate data and improve query speed
Utilize query profiling to identify and optimize slow queries
Monitor resource usage to ensure efficient query execution
Q18. Difference between Structure and object oriented languages
Structure languages focus on procedures and functions, while object-oriented languages focus on objects and classes.
Structure languages use functions and procedures to manipulate data
Object-oriented languages use objects and classes to encapsulate data and behavior
Structure languages are more procedural in nature, while object-oriented languages are more modular and reusable
Examples of structure languages include C and Pascal
Examples of object-oriented languages include Java ...read more
Q19. Explain of OOPS concepts and their real life examples.
OOPS concepts are fundamental to object-oriented programming and include inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: A child class inherits properties and behaviors from a parent class. Example: Animal class can be a parent class with child classes like Dog and Cat inheriting its attributes.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: A car object encapsulates data like speed and methods like acceler...read more
Q20. System architecture diagram for web application project.
The system architecture diagram for a web application project visually represents the components and their interactions.
Include components like client-side interface, server-side application, database, and external services
Show how these components communicate with each other
Consider scalability, security, and performance in the design
Use standard symbols and notations for clarity
Q21. What is MOU ?
MOU stands for Memorandum of Understanding, a non-legally binding agreement between two or more parties outlining the terms and details of their cooperation.
MOU is a formal agreement between parties that outlines the terms and details of their cooperation.
It is often used in business, government, and international relations.
MOUs are typically non-legally binding but can serve as a precursor to a formal contract.
They are commonly used to establish partnerships, collaborations,...read more
Q22. Introduction Expectation from companies
Companies are expected to have a clear introduction that highlights their values and goals.
A clear and concise introduction that highlights the company's values and goals
Introduction should be engaging and informative
Introduction should give a brief overview of the company's history and achievements
Examples: Apple's introduction on their website, Google's introduction on their About page
Q23. What is static keyword and it's usage.
The static keyword in programming is used to declare variables, functions, or classes that retain their values or state throughout the program's execution.
Static variables retain their values between function calls
Static functions can only be accessed within the same file
Static classes cannot be instantiated and have limited visibility
Static keyword can also be used in C++ to declare class members shared among all instances
Q24. Who gives the annual report of the companies
The annual report of companies is typically prepared by the management team and approved by the board of directors.
The management team of a company is responsible for preparing the annual report.
The annual report is then approved by the board of directors before being released to shareholders and the public.
The annual report includes financial statements, management discussion and analysis, and other relevant information about the company's performance.
Investors, analysts, an...read more
Q25. How do you structure and go about approaching a problem?
I approach problems by breaking them down into smaller parts and analyzing each part systematically.
Identify the problem and define the desired outcome
Gather relevant information and data
Break down the problem into smaller parts
Analyze each part systematically
Brainstorm potential solutions
Evaluate and select the best solution
Implement the solution and monitor its effectiveness
Q26. Agile methodologies and day to day operations
Agile methodologies are integrated into day to day operations for efficient software development.
Agile methodologies promote collaboration and flexibility in development
Daily stand-up meetings keep the team updated on progress and any roadblocks
Sprints allow for focused development and frequent feedback
Continuous integration and testing ensure quality and catch issues early
Retrospectives provide opportunities for reflection and improvement
Q27. Managing the Technology risk in an organization with proper remediation requirements. Third-party risk questionnaire and Documentations.
Managing technology risk in an organization involves implementing proper remediation requirements and utilizing third-party risk questionnaires and documentation.
Identify and assess technology risks within the organization
Develop and implement remediation requirements to mitigate identified risks
Establish a process for evaluating and managing third-party risks
Create a comprehensive third-party risk questionnaire to assess the security practices of vendors and partners
Maintain...read more
Q28. OOP concepts and examples from your coding experience
OOP concepts like inheritance, encapsulation, and polymorphism are essential in software development.
Inheritance: Creating subclasses that inherit properties and behaviors from a parent class.
Encapsulation: Bundling data and methods within a class to restrict access from outside.
Polymorphism: Objects of different classes can be treated as objects of a common superclass.
Example: Creating a class 'Animal' with subclasses like 'Dog' and 'Cat' inheriting from it.
Q29. How due diligence and compliance can effect the financial research
Due diligence and compliance play a crucial role in ensuring the accuracy and legality of financial research.
Due diligence involves thorough research and analysis to verify the accuracy of financial information.
Compliance ensures that all research and analysis adhere to relevant laws and regulations.
Failure to conduct proper due diligence or comply with regulations can lead to inaccurate research and legal consequences.
Examples of compliance in financial research include foll...read more
Q30. Explain which methodology you use for Process mapping documentation
I use the BPMN (Business Process Model and Notation) methodology for process mapping documentation.
BPMN is a widely accepted standard for process modeling and documentation.
It provides a graphical representation of processes using various symbols and notations.
BPMN allows for clear visualization of process flows, activities, decisions, and interactions.
It helps in identifying bottlenecks, inefficiencies, and areas for improvement in a process.
BPMN diagrams can be easily under...read more
Q31. Difference between Financial Instruments, asset classes etc
Financial instruments are tradable assets that represent a legal agreement between two parties to buy or sell an asset at a predetermined price and time.
Financial instruments include stocks, bonds, options, futures, and derivatives.
Asset classes are groups of financial instruments that share similar characteristics and behave similarly in the market.
Examples of asset classes include equities, fixed income, commodities, and real estate.
Asset allocation involves dividing an inv...read more
Q32. Depreciation and amortization difference
Depreciation is for tangible assets, while amortization is for intangible assets.
Depreciation is the allocation of the cost of tangible assets over their useful life.
Amortization is the allocation of the cost of intangible assets over their useful life.
Depreciation is typically used for assets like buildings, machinery, and vehicles.
Amortization is used for assets like patents, copyrights, and trademarks.
Q33. What is book keeping
Bookkeeping is the process of recording financial transactions and maintaining financial records for a business.
Involves recording all financial transactions of a business
Includes organizing and categorizing transactions
Helps in tracking income, expenses, and overall financial health of the business
Q34. What is depreciation
Depreciation is the allocation of the cost of an asset over its useful life.
Depreciation is a non-cash expense that reduces the value of an asset over time.
It reflects the wear and tear, obsolescence, or decrease in value of the asset.
Common methods of calculating depreciation include straight-line, double declining balance, and units of production.
Example: A company purchases a delivery truck for $50,000 with a useful life of 5 years. Using straight-line depreciation, the an...read more
Q35. How do you load data from JSON?
Data can be loaded from JSON using Snowflake's COPY INTO command.
Use the COPY INTO command in Snowflake to load data from JSON files.
Specify the file format as JSON in the COPY INTO command.
Map the JSON attributes to the columns in the target table.
Example: COPY INTO target_table FROM 's3://bucket_name/file.json' FILE_FORMAT = (TYPE = 'JSON');
Q36. Data migration from on prem to cloud data warehouse.
Data migration from on-premises to cloud data warehouse involves transferring data from local servers to a cloud-based storage solution.
Assess current data sources and structures on-premises
Select appropriate cloud data warehouse solution (e.g. Snowflake)
Plan data migration strategy including data extraction, transformation, and loading (ETL)
Test data migration process thoroughly before full implementation
Monitor and optimize data migration performance
Q37. Financial marketing techniques
Financial marketing techniques involve strategies and tactics used to promote financial products and services.
Targeted advertising to reach specific demographics
Content marketing through blogs, articles, and social media
Email marketing campaigns to engage and inform customers
Search engine optimization (SEO) to improve online visibility
Influencer marketing to leverage the influence of industry experts
Direct mail campaigns to reach potential customers
Event sponsorships and part...read more
Q38. Are you involved in test plans
Yes, I am involved in test plans.
I collaborate with the team to create and review test plans.
I ensure that the test plans cover all the necessary scenarios.
I update the test plans as needed based on changes in requirements or functionality.
I use the test plans to guide my testing efforts and report any issues found.
Q39. Golden rule’s of accounts
The golden rules of accounts are basic principles that guide the recording of financial transactions.
The golden rules include: Debit what comes in, Credit what goes out; Debit the receiver, Credit the giver; Debit expenses and losses, Credit income and gains.
For example, when cash is received, it is debited to increase the cash account (debit what comes in).
Similarly, when a sale is made, the revenue account is credited to reflect the increase in income (credit income and gai...read more
Q40. Why London Stock Exchange Group?
LSEG is a leading financial markets infrastructure provider with a diverse range of businesses.
LSEG has a strong reputation in the financial industry
The company offers a wide range of opportunities for learning and growth
Working at LSEG provides exposure to a diverse range of businesses and markets
LSEG is committed to innovation and technology, which aligns with my interests and skills
Q41. What is Oops and around it?
Oops stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.
Oops is a programming paradigm that uses objects to design applications.
It focuses on data encapsulation, inheritance, polymorphism, and abstraction.
Examples of Oops languages include Java, C++, and Python.
Q42. Risk management methodologies and handling the information security risks
Risk management methodologies involve identifying, assessing, and mitigating information security risks.
Identify potential risks by conducting risk assessments and vulnerability scans
Assess the impact and likelihood of each risk
Prioritize risks based on their potential impact and likelihood
Implement controls and safeguards to mitigate identified risks
Regularly monitor and review the effectiveness of controls
Update risk management strategies based on changes in technology, thr...read more
Q43. What do you mean by AML and KYC?
AML stands for Anti-Money Laundering and KYC stands for Know Your Customer. They are regulatory processes to prevent financial crimes.
AML is a set of procedures, laws, and regulations designed to prevent the practice of generating income through illegal actions.
KYC is the process of verifying the identity of customers and assessing their suitability, along with the potential risks of illegal intentions through their financial transactions.
Both AML and KYC are crucial in the f...read more
Q44. What is shares and kind of shares
Shares represent ownership in a company and can be classified into different types such as common shares and preferred shares.
Shares represent ownership in a company
Common shares give voting rights to shareholders
Preferred shares have priority in receiving dividends
Other types include treasury shares and bonus shares
Q45. How Eikon is different from datascope
Eikon is a financial analysis platform while Datascope is a data delivery platform.
Eikon is primarily used for financial analysis and trading purposes.
Datascope is focused on delivering financial data and content to users.
Eikon provides real-time market data, news, analytics, and trading tools.
Datascope offers historical and reference data for financial analysis.
Eikon is more user-friendly and customizable compared to Datascope.
Q46. What are the technicals you need for tradingm
Technical analysis involves using historical price and volume data to predict future price movements in trading.
Knowledge of chart patterns and indicators
Understanding of support and resistance levels
Ability to interpret volume and price trends
Familiarity with technical analysis tools like moving averages and RSI
Experience in backtesting trading strategies
Q47. What are complex tickets you resolved ?
Resolved complex tickets related to billing discrepancies and system errors.
Identifying root causes of billing discrepancies
Collaborating with cross-functional teams to resolve system errors
Implementing solutions to prevent future occurrences
Providing detailed explanations to customers regarding the resolution process
Q48. What is money laundering
Money laundering is the illegal process of making large amounts of money generated by a criminal activity, such as drug trafficking or terrorist funding, appear to have come from a legitimate source.
Money laundering involves disguising the origins of illegally obtained money by passing it through a complex sequence of banking transfers or commercial transactions.
The purpose of money laundering is to make the money appear as if it was earned legally, thus avoiding suspicion an...read more
Q49. How do you configure snowpipe?
Snowpipe is configured using a Snowflake account, specifying the source data location and the target table.
Configure a stage in Snowflake to specify the source data location.
Create a pipe in Snowflake to define the target table and the stage.
Set up notifications for the pipe to trigger loading data automatically.
Monitor the pipe for any errors or issues in data loading.
Example: CREATE STAGE my_stage URL = 's3://my_bucket/data'
Example: CREATE PIPE my_pipe AS COPY INTO my_table...read more
Q50. Access Modifiers in java
Access modifiers in Java control the visibility of classes, methods, and variables.
There are four types of access modifiers in Java: public, private, protected, and default.
Public: accessible from any other class.
Private: only accessible within the same class.
Protected: accessible within the same package and subclasses.
Default: accessible only within the same package.
Example: public class MyClass { private int myVar; protected void myMethod() { } }
Q51. Name different stock exchange internationally
Some of the major international stock exchanges include NYSE, NASDAQ, LSE, TSX, and HKEX.
NYSE - New York Stock Exchange
NASDAQ - National Association of Securities Dealers Automated Quotations
LSE - London Stock Exchange
TSX - Toronto Stock Exchange
HKEX - Hong Kong Stock Exchange
Q52. What is annual report
An annual report is a comprehensive report on a company's activities throughout the preceding year.
An annual report provides information on a company's financial performance, operations, and future plans.
It includes financial statements such as balance sheets, income statements, and cash flow statements.
It also includes a letter from the CEO or chairman, a summary of the company's achievements, and a discussion of its challenges.
Annual reports are typically published online a...read more
Q53. What is object oriented programming
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
Objects are instances of classes, which define the structure and behavior of the objects.
Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.
Example: In a banking application, a 'Customer' class may have attributes like name and account balance, and methods like deposit and withdraw.
Q54. How would you manage workflow?
I would manage workflow by prioritizing tasks, setting deadlines, delegating responsibilities, and using project management tools.
Prioritize tasks based on deadlines and importance
Set clear deadlines for each task to ensure timely completion
Delegate responsibilities to team members based on their strengths and workload
Utilize project management tools such as Trello or Asana to track progress and communicate with team members
Q55. Scenarios experienced by a scrum master
Scrum Master experiences various scenarios like team conflicts, impediment removal, and stakeholder management.
Handling conflicts within the team
Removing impediments to progress
Managing stakeholders and their expectations
Q56. Data modelling techniques used
Various data modelling techniques like dimensional modelling, ER modelling, and data vault are used.
Dimensional modelling is used for data warehousing and involves organizing data into facts and dimensions.
ER modelling is used to visualize the data relationships in an entity-relationship diagram.
Data vault modelling is used for agile data warehousing and involves creating a flexible and scalable data model.
Q57. Clustering Keys in snowflake
Clustering keys in Snowflake help improve query performance by organizing data in a specific order.
Clustering keys determine the physical order of data in Snowflake tables.
They are defined at the table level and can be set during table creation or altered later.
Clustering keys can be single or composite, and should be chosen based on the most commonly used columns in queries.
They help reduce the amount of data scanned during query execution, leading to faster performance.
Q58. Share capital formula
Share capital formula calculates the total amount of funds raised by a company through the sale of its shares.
Share capital formula = Number of shares issued x Par value of shares
Par value is the minimum price at which a share can be issued
Share capital can also be calculated as the sum of the nominal value of all shares issued
Share capital is an important metric for investors and analysts to evaluate a company's financial health
Q59. Difference between Rights and Warrents
Rights are issued by the company to its shareholders, while warrants are issued by a third party and give the holder the right to buy company stock at a specific price.
Rights are issued by the company to existing shareholders, allowing them to purchase additional shares at a discounted price.
Warrants are issued by a third party, such as a bank or investor, and give the holder the right to buy company stock at a specific price within a certain timeframe.
Rights typically have a...read more
Q60. What are Graphs
Graphs are mathematical structures used to represent relationships between objects.
Graphs consist of nodes (vertices) and edges connecting these nodes.
There are different types of graphs such as directed graphs, undirected graphs, weighted graphs, etc.
Graphs are used in various fields like computer science, social networks, transportation networks, etc.
Examples of graphs include social networks like Facebook, road networks, and organizational hierarchies.
Q61. What are Derivatives
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage.
Common types of derivatives include options, futures, forwards, and swaps.
Derivatives allow investors to take positions on the price movements of assets without owning the assets themselves.
They are often used to manage risk in financial markets.
Derivatives are traded on exchanges or over-the-counter (OTC) mark...read more
Q62. Recent news about AML kyc
Recent news about AML KYC regulations have highlighted the importance of compliance and due diligence in financial institutions.
Increased focus on AML (Anti-Money Laundering) regulations and KYC (Know Your Customer) requirements
Implementation of stricter measures to prevent money laundering and terrorist financing
Use of technology such as AI and blockchain to enhance AML compliance
Collaboration between financial institutions and regulatory bodies to combat financial crimes
Q63. Streans in snowflake
Streams in Snowflake are used to continuously replicate data from a table to another destination in real-time.
Streams capture changes made to a table, such as inserts, updates, and deletes.
They can be used to track changes and replicate data to other tables or external systems.
Streams are created on a specific table and can be monitored for changes using SQL commands.
Q64. Streams in snowflake
Streams in Snowflake are continuous flows of data that can be consumed in real-time for processing and analysis.
Streams capture changes made to a table and make them available for processing in real-time.
They can be used to implement CDC (Change Data Capture) solutions.
Streams can be created using the CREATE STREAM statement.
Example: CREATE STREAM my_stream ON TABLE my_table;
Q65. Implement kafka like queue
Implementing a Kafka-like queue involves creating a distributed messaging system for handling large volumes of data.
Use Apache Kafka or another messaging system as a base for understanding the architecture.
Design a system with topics, partitions, producers, and consumers.
Implement fault tolerance and scalability features like replication and partitioning.
Ensure high throughput and low latency for message processing.
Consider implementing features like message retention, acknow...read more
Q66. Skills that are owned
Some skills I possess include content creation, SEO optimization, social media management, and data analysis.
Content creation
SEO optimization
Social media management
Data analysis
Q67. React vs angular
React is a lightweight library for building user interfaces, while Angular is a full-fledged framework for web development.
React is more flexible and allows for easier integration with other libraries and frameworks.
Angular provides more out-of-the-box features and a more opinionated structure.
React uses a virtual DOM for better performance, while Angular uses two-way data binding for easier data manipulation.
React is maintained by Facebook, while Angular is maintained by Goo...read more
Top HR Questions asked in Mil Power Converter Technologies India
Interview Process at Mil Power Converter Technologies India
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month