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 Interview Questions, Process, and Tips

Updated 1 Mar 2025

Top Factspan Interview Questions and Answers

View all 7 questions

Factspan Interview Experiences

Popular Designations

18 interviews found

Manager Interview Questions & Answers

user image Anonymous

posted on 21 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Describe experience on Data engineering
  • Ans. 

    I have 5 years of experience in data engineering, including designing data pipelines, ETL processes, and data modeling.

    • Designed and implemented data pipelines to extract, transform, and load data from various sources

    • Developed ETL processes to ensure data quality and consistency

    • Created data models to support business intelligence and analytics

    • Worked with big data technologies such as Hadoop, Spark, and Kafka

    • Collaborated...

  • Answered by AI
  • Q2. Estimates and sow process milestones etc
Round 2 - One-on-one 

(2 Questions)

  • Q1. No case study based interview questions
  • Q2. Some common scenario based questions

Skills evaluated in this interview

Manager Interview Questions asked at other Companies

Q1. There is a chairman of a conglomerate. He has been on the post for 10 years, and is extremely dominating. He treats the various business heads like children, not letting them take any major decision. While the chairman has negatives, he bel... read more
View answer (2)
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

Data Engineering Analyst Interview Questions asked at other Companies

Q1. Product Of Array Except Self Problem Statement You are provided with an integer array ARR of size N. You need to return an array PRODUCT such that PRODUCT[i] equals the product of all the elements of ARR except ARR[i]. Example: Input: T = 2... read more
View answer (1)
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Feb 2025.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql and python questions
  • Q2. Ddl and dml command
  • Q3. Joins inSQL explain

Associate Principal Engineer Interview Questions asked at other Companies

Q1. How will you prevent docker container from assuming root user role?
View answer (1)

Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Feb 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain your project.
  • Ans. 

    Developed a data analysis tool to track customer behavior and preferences.

    • Used Python and SQL to collect and analyze customer data

    • Implemented machine learning algorithms to predict customer trends

    • Generated reports and visualizations to present findings to stakeholders

  • Answered by AI
  • Q2. DDl in SQL
  • Ans. 

    DDL stands for Data Definition Language in SQL, used to define and manage database structures.

    • DDL includes commands like CREATE, ALTER, DROP, TRUNCATE, etc.

    • CREATE is used to create new database objects like tables, views, indexes, etc.

    • ALTER is used to modify existing database objects.

    • DROP is used to delete database objects.

    • TRUNCATE is used to remove all records from a table.

    • Examples: CREATE TABLE, ALTER TABLE ADD COLUM

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont sit for this company . Your offers may revoked.

Analyst Interview Questions asked at other Companies

Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation. Since the answer can be very large, return the answer modulo 10^9 + 7. Formula: F(n) = F(n-... read more
View answer (1)

Factspan interview questions for popular designations

 Analyst

 (4)

 Senior Analyst

 (3)

 Data Scientist

 (1)

 Manager

 (1)

 Data Analyst

 (1)

 Senior Consultant

 (1)

 Senior Business Analyst

 (1)

 Salesman

 (1)

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How Adobe Marketing Cloud Solutions work together
  • Ans. 

    Adobe Marketing Cloud Solutions work together seamlessly to provide a comprehensive marketing platform.

    • Adobe Marketing Cloud Solutions, such as Adobe Analytics, Adobe Campaign, and Adobe Experience Manager, integrate data and workflows to provide a unified view of customer interactions.

    • These solutions enable marketers to create personalized and targeted campaigns, optimize content, and measure the impact of their marke...

  • Answered by AI
  • Q2. How CJA can impact converion
  • Ans. 

    CJA can impact conversion by optimizing customer journey analysis to identify pain points and improve user experience.

    • Identify key touchpoints in the customer journey where conversions are dropping off

    • Analyze user behavior data to understand why conversions are not happening at certain stages

    • Implement changes to improve user experience and address pain points, leading to increased conversions

  • Answered by AI

Skills evaluated in this interview

Principal Analyst Interview Questions asked at other Companies

Q1. How Adobe Marketing Cloud Solutions work together
View answer (1)

Analyst Interview Questions & Answers

user image Anonymous

posted on 12 Oct 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Coding Test 

It was easy more of case study, guess estimate,sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic sql

Analyst Interview Questions asked at other Companies

Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation. Since the answer can be very large, return the answer modulo 10^9 + 7. Formula: F(n) = F(n-... read more
View answer (1)

Jobs at Factspan

View all
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. LLM (lage language models), XGBoost

Data Scientist Interview Questions asked at other Companies

Q1. for a data with 1000 samples and 700 dimensions, how would you find a line that best fits the data, to be able to extrapolate? this is not a supervised ML problem, there's no target. and how would you do it, if you want to treat this as a s... read more
View answer (5)

Salesman Interview Questions & Answers

user image Migrant white

posted on 14 Dec 2024

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself

Salesman Interview Questions asked at other Companies

Q1. How can you motivate the customer to buy our products
View answer (9)
Interview experience
4
Good
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2023. There were 4 interview rounds.

Round 1 - Coding Test 

In the first round I was asked about Spark Questions. I was given a problem statement and datasets. I had to solve the problem statement by writing a PySpark code. For example - there are 2 tables with these are the columns and write a spark program to get the expected output. This round lasted from 45 minutes to 1 hour time and I was asked about 6 coding questions. Simple plus Difficult .

Round 2 - Technical 

(2 Questions)

  • Q1. In the second round I was asked mostly on SQLs, Optimization techniques to solve the problem of long running queries. But it was one level deeper than the first round. Also I was given a scenario based dif...
  • Q2. Don't remember the questions but this round lasted about 30 minutes.
Round 3 - Aptitude Test 

In this round I was asked about many things related to technology but not directly technical. Like - How comfortable I am to work on new technologies ?
- How to upskill quickly ?
- What kind of approaches to take to resolve conflicts within teams ?
- Have you said NO to work on a particular technology stack ?

This round lasted about 45 minutes

Round 4 - HR 

(1 Question)

  • Q1. This was a 45 minutes call again with HR team , mostly in behavioral, fitment and compensation related questions. And in this round you will get to know about the offer, salary and joining dates etc.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. With HR basic discussion
  • Q2. Cultural fit teat
Round 3 - Technical 

(1 Question)

  • Q1. Based on ML theory, SQL, SQL queries
Round 4 - One-on-one 

(1 Question)

  • Q1. Interview with Senior management
Round 5 - HR 

(1 Question)

  • Q1. Salary discussion round

Interview Preparation Tips

Topics to prepare for Factspan Senior Analyst interview:
  • Python
  • Sql
  • Business case study

Senior Analyst Interview Questions asked at other Companies

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference between IRR and CAGR. What is Bond Y... read more
View answer (1)

Factspan Interview FAQs

How many rounds are there in Factspan interview?
Factspan interview process usually has 2-3 rounds. The most common rounds in the Factspan interview process are Technical, One-on-one Round and HR.
How to prepare for Factspan 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 Python, SQL, Data Analytics, Big Data and Data Modeling.
What are the top questions asked in Factspan interview?

Some of the top questions asked at the Factspan interview -

  1. Window analytical functions, difference and how to use t...read more
  2. How to Proactively reduce incidents, how to process unstructured file...read more
  3. How Adobe Marketing Cloud Solutions work toget...read more
How long is the Factspan interview process?

The duration of Factspan interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Factspan Interview Process

based on 14 interviews

Interview experience

3.1
  
Average
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 221 Interviews
Fractal Analytics Interview Questions
4.0
 • 208 Interviews
Axtria Interview Questions
3.1
 • 116 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.0
 • 9 Interviews
Analytic Edge Interview Questions
3.1
 • 6 Interviews
Crayon Data Interview Questions
3.6
 • 4 Interviews
View all

Fast track your campus placements

View all

Factspan Reviews and Ratings

based on 120 reviews

3.5/5

Rating in categories

3.6

Skill development

3.6

Work-life balance

3.1

Salary

3.5

Job security

3.6

Company culture

3.3

Promotions

3.4

Work satisfaction

Explore 120 Reviews and Ratings
Site Reliability Engineer Manager

Bangalore / Bengaluru

7-12 Yrs

Not Disclosed

Devops Architect

Bangalore / Bengaluru

6-11 Yrs

Not Disclosed

Senior Manager

Bangalore / Bengaluru

9-14 Yrs

Not Disclosed

Explore more jobs
Senior Analyst
95 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
73 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
60 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
51 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Factspan with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

AbsolutData

3.6
Compare

Tiger Analytics

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