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, Process, and Tips
Top Factspan Interview Questions and Answers
- Q1. How Adobe Marketing Cloud Solutions work togetherasked in Principal Analyst interview
- Q2. Window analytical functions, difference and how to use themasked in Data Engineering Analyst interview
- Q3. Describe experience on Data engineeringasked in Manager interview
Factspan Interview Experiences
18 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
(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
Get interview-ready with Top Factspan Interview Questions
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
Jobs at Factspan
(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.
Selected
I applied via Naukri.com and was interviewed before Nov 2022. There were 5 interview rounds.
(2 Questions)
- Q1. With HR basic discussion
- Q2. Cultural fit teat
(1 Question)
- Q1. Based on ML theory, SQL, SQL queries
(1 Question)
- Q1. Interview with Senior management
(1 Question)
- Q1. Salary discussion round
Interview Preparation Tips
- Python
- Sql
- Business case study
Senior Analyst Interview Questions asked at other Companies
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
Factspan Interview Process
based on 14 interviews
Interview experience
Interview Questions from Similar Companies
Factspan Reviews and Ratings
based on 122 reviews
Rating in categories
|
Senior Analyst
96
salaries
|  ₹9 L/yr - ₹17.7 L/yr |
|
Analyst
73
salaries
| ₹6.5 L/yr - ₹10.5 L/yr |
|
Business Analyst
60
salaries
| ₹6 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 |
Fractal Analytics
Mu Sigma
AbsolutData
Tiger Analytics
- Home >
- Interviews >
- Factspan Interview Questions
