AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Factspan
Compare
Filter interviews by
Factspan Interview Questions and Answers
Factspan Interview Experiences
19 interviews found
Anonymous
(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...
- Q2. Estimates and sow process milestones etc
(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
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
(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
- 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
(1 Question)
- Q1. Questions around current project, details of what we currently use and potential replacer for it
(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
Interview Preparation Tips
Skills evaluated in this interview
Data Engineering Analyst Interview Questions asked at other Companies
Selected
I appeared for an interview in Feb 2025.
(3 Questions)
- Q1. Sql and python questions
- Q2. Ddl and dml command
- Q3. Joins inSQL explain
- Ans.
SQL joins combine rows from two or more tables based on related columns.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched records from the left ...
Associate Principal Engineer Interview Questions asked at other Companies
Selected
I appeared for an interview in Jan 2025.
(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
- 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
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
Factspan interview questions for popular designations
Selected
I appeared for an interview before Mar 2024, where I was asked the following questions.
- Q1. What were the main reasons you expressed for wanting this job, and what technical questions were you asked during the interview?
- Q2. What is your story that demonstrates your suitability for this position?
Analyst Interview Questions asked at other Companies
(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...
- 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
Skills evaluated in this interview
Principal Analyst Interview Questions asked at other Companies
Jobs at Factspan
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
It was easy more of case study, guess estimate,sql
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
(1 Question)
- Q1. LLM (lage language models), XGBoost
Data Scientist Interview Questions asked at other Companies
Migrant white
(1 Question)
- Q1. Tell me about yourself
Salesman Interview Questions asked at other Companies
Selected
I applied via Approached by Company and was interviewed before Apr 2023. There were 4 interview rounds.
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 .
(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.
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
(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.
Top trending discussions
Factspan Interview FAQs
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 Interviews By Designations
- Factspan Analyst Interview Questions
- Factspan Senior Analyst Interview Questions
- Factspan Data Scientist Interview Questions
- Factspan Manager Interview Questions
- Factspan Data Analyst Interview Questions
- Factspan Senior Consultant Interview Questions
- Factspan Senior Business Analyst Interview Questions
- Factspan Salesman Interview Questions
- Show more
Interview Questions for Popular Designations
- Analyst Interview Questions
- Senior Executive Interview Questions
- Software Developer Interview Questions
- Business Analyst Interview Questions
- Senior Associate Interview Questions
- Sales Executive Interview Questions
- Associate Software Engineer Interview Questions
- Accountant Interview Questions
- Show more
Factspan Interview Process
based on 15 interviews
Interview experience
Interview Questions from Similar Companies
Factspan Reviews and Ratings
based on 126 reviews
Rating in categories
13-18 Yrs
Not Disclosed
13-18 Yrs
Not Disclosed
|
Senior Analyst
97
salaries
|  ₹9 L/yr - ₹20 L/yr |
|
Business Analyst
60
salaries
| ₹6 L/yr - ₹10.5 L/yr |
|
Analyst
58
salaries
| ₹6.5 L/yr - ₹10.5 L/yr |
|
Associate Manager
52
salaries
| ₹13.5 L/yr - ₹20 L/yr |
|
Data Analyst
30
salaries
| ₹7 L/yr - ₹10.5 L/yr |
Saama Technologies
Jumio
DISYS
Data-Core Systems
- Home >
- Interviews >
- Factspan Interview Questions
