i
Factspan
Filter interviews by
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...
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
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
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
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
I was interviewed in Feb 2025.
I was interviewed in Jan 2025.
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
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
Factspan interview questions for popular designations
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...
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
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
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 .
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
I applied via Naukri.com and was interviewed before Nov 2022. There were 5 interview rounds.
Top trending discussions
The duration of Factspan interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 14 interviews
Interview experience
based on 120 reviews
Rating in categories
Senior Analyst
95
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
73
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
60
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Manager
51
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
28
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
AbsolutData
Tiger Analytics