Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Factspan Team. If you also belong to the team, you can get access from here

Factspan Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Factspan Data Engineering Analyst Interview Questions and Answers

Updated 12 Sep 2024

Factspan Data Engineering Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL query to find nth highest salary
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find nth highest salary.

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT to specify the nth highest salary

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT n-1, 1

  • Answered by AI
  • Q2. Window analytical functions, difference and how to use them
  • Ans. 

    Window analytical functions are used to perform calculations across a set of table rows related to the current row.

    • Window functions operate on a set of rows related to the current row

    • They allow calculations to be performed across a group of rows

    • Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

    • They are used with the OVER() clause in SQL queries

  • Answered by AI
Round 2 - Behavioral 

(1 Question)

  • Q1. Questions around current project, details of what we currently use and potential replacer for it
Round 3 - HR 

(2 Questions)

  • Q1. Introduction of yourself, work experience
  • Q2. Why are you leaving current organization and why are you still looking out for job when already have an offer
  • Ans. 

    Seeking new challenges and growth opportunities in a more innovative and dynamic environment.

    • Looking for new challenges and opportunities for growth

    • Seeking a more innovative and dynamic work environment

    • Interested in exploring new technologies and methodologies

    • Current organization may not align with long-term career goals

    • Considering multiple offers to find the best fit

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Technical rounds are good. Please be careful that HR will ask you to come to office without clarifying on numbers. When you go to office, you hear disappointing numbers. Offer lesser than competitive offer in hand. Do not waste your day. Please make sure you discuss the numbers before agreeing to visit office.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Self Introduction
  • Q2. Salary Expectation
Round 2 - Technical 

(1 Question)

  • Q1. 14 questions in excel formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - To prepare Excel Formulas and Hlookup,vlookup and etc....
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(3 Questions)

  • Q1. Finance questions - related to option pricing, derivatives, securities such as ABS, CLOs
  • Q2. Questions on hedge fund structure, ecosystem, hedge fund strategies
  • Q3. Why do you want to join IVP? Why not sell side core finance roles?
Round 2 - One-on-one 

(4 Questions)

  • Q1. Math puzzles, Statistics, Probability problems
  • Q2. Do you have any technical experience? Data visualization and SQL based
  • Q3. Why do you want to join us?
  • Q4. What do you know about IVP and the exact nature of work we do?
Round 3 - HR 

(2 Questions)

  • Q1. What keeps you going everyday?
  • Q2. Why do you want to join IVP and what strengths will make you thrive here?

I applied via Referral and was interviewed in Oct 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. How can you fit in to this role
  • Q2. Questions about Finacial products, CDS, Asset Management

Interview Preparation Tips

Interview preparation tips for other job seekers - Be well prepared on Financial topics, especially Asset Management and Hedge Funds.
Be well verse with your CV, especially work experience and projects
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is call option?
  • Ans. 

    A call option is a financial contract that gives the holder the right, but not the obligation, to buy an asset at a specified price within a specific time period.

    • Call options are commonly used in stock trading and allow investors to profit from a rising stock price.

    • The specified price at which the asset can be bought is known as the strike price.

    • The expiration date is the deadline by which the option must be exercised.

    • ...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024, where I was asked the following questions.

  • Q1. What is a Collateralized Loan Obligation (CLO)?
  • Ans. 

    A CLO is a type of structured credit product backed by a pool of loans, typically corporate loans, that are securitized.

    • CLOs are created by pooling together various loans, primarily leveraged loans to corporations.

    • Investors in CLOs receive payments based on the cash flows generated by the underlying loans.

    • CLOs are divided into tranches, each with different risk levels and returns; for example, senior tranches are less ...

  • Answered by AI
  • Q2. What is the process for valuing a partially drawn Collateralized Loan Obligation (CLO)?
  • Ans. 

    Valuing a partially drawn CLO involves assessing cash flows, credit quality, and market conditions.

    • 1. Assess the underlying assets: Evaluate the credit quality and performance of the loans in the CLO portfolio.

    • 2. Cash flow analysis: Project future cash flows based on the current draw and expected repayments.

    • 3. Discount rate: Determine an appropriate discount rate reflecting the risk profile of the CLO.

    • 4. Market compara...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral

Round 1 - Technical 

(2 Questions)

  • Q1. What are the characteristics of a bond?
  • Ans. 

    A bond is a debt instrument issued by a company or government to raise capital.

    • Bonds have a fixed maturity date when the principal amount is repaid.

    • Bonds pay periodic interest payments to bondholders.

    • Bonds have a face value, which is the principal amount borrowed.

    • Bonds can be traded on the secondary market.

    • Bonds have different types such as government bonds, corporate bonds, and municipal bonds.

  • Answered by AI
  • Q2. Tell me about yourself
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about your previous work experience?
  • Q2. Why do you want to switch to IVP?
  • Ans. 

    I want to switch to IVP for the opportunity to work with cutting-edge technology and contribute to innovative solutions.

    • IVP offers a more challenging and dynamic work environment compared to my current role.

    • I am excited about the opportunity to work with a team of talented professionals who are at the forefront of technology.

    • IVP's focus on innovation and creativity aligns with my career goals and aspirations.

    • I believe ...

  • Answered by AI
Round 1 - Aptitude Test 

Math , gk, english

Round 2 - Group Discussion 

AI

Round 3 - One-on-one 

(1 Question)

  • Q1. Ai questions , java questions , coding questions
Round 4 - HR 

(1 Question)

  • Q1. Where do you see yourself in 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - none , not difficult to get into equifax

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

Factspan Interview FAQs

How many rounds are there in Factspan Data Engineering Analyst interview?
Factspan interview process usually has 3 rounds. The most common rounds in the Factspan interview process are Technical, Behavioral and HR.
How to prepare for Factspan Data Engineering Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Factspan. The most common topics and skills that interviewers at Factspan expect are Airflow, Data Bricks, Data Mart, GCP and Hadoop Administration.
What are the top questions asked in Factspan Data Engineering Analyst interview?

Some of the top questions asked at the Factspan Data Engineering Analyst interview -

  1. Window analytical functions, difference and how to use t...read more
  2. SQL query to find nth highest sal...read more
  3. Questions around current project, details of what we currently use and potentia...read more

Tell us how to improve this page.

Factspan Data Engineering Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Equifax Interview Questions
3.3
 • 32 Interviews
VDart Interview Questions
4.1
 • 29 Interviews
DISYS Interview Questions
3.0
 • 27 Interviews
EagleView Interview Questions
3.3
 • 20 Interviews
View all

Fast track your campus placements

View all
Senior Analyst
97 salaries
unlock blur

₹9 L/yr - ₹20 L/yr

Analyst
68 salaries
unlock blur

₹6.5 L/yr - ₹11 L/yr

Business Analyst
60 salaries
unlock blur

₹6 L/yr - ₹10.5 L/yr

Associate Manager
53 salaries
unlock blur

₹13.5 L/yr - ₹20 L/yr

Data Analyst
29 salaries
unlock blur

₹7 L/yr - ₹10.5 L/yr

Explore more salaries
Compare Factspan with

Saama Technologies

3.7
Compare

Jumio

3.7
Compare

DISYS

3.0
Compare

Data-Core Systems

3.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview