Intercontinental Exchange System Operations Analyst Interview Questions and Answers

Q1. Type of Joins, Syntax of Join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Syntax of join: SELECT columns FROM table1 JOIN table2 ON table1.column = table2.column

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Q1. What is shares and kind of shares
Ans. 
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
Answered by AI
Add your answer
Q2. Name different stock exchange internationally
Ans. 
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
Answered by AI
Add your answer

Q1. Project related questions
Add your answer
Q2. Financial instruments knowledge
Add your answer

Q1. General project related questions
Add your answer
Q2. Financial domain in depth questions
Add your answer

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Customer churn classification using a classification ML model

Q1. Write a pseudo code for Bubble sort
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
• Start with the first element and compare it with the next element, swapping if necessary

• Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

• Continue this process for each element in the array until no more swaps are ne
Answered by AI
Add your answer
Q2. What is an API
Ans. 
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
• APIs define the methods for requesting and receiving data between software applications

• APIs can be used to access data from external sources, such as social media platforms or weather services

• Examples of APIs include the Twitter API, Google Maps API, and Spotify API
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills and attention to detail
Answered by AI
Add your answer
Q2. Salaray compensation how much
Add your answer

Sql and aptitude questions

Q1. Question from resume amd project
Add your answer
Q2. Some questions on sql
Add your answer