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 Senior Principal Analyst Interview Questions and Answers

Updated 22 Apr 2024

Factspan Senior Principal Analyst Interview Experiences

1 interview found

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 questions from similar companies

I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Object Oriented Concepts and basic list/tuple/dictionary/ datetime conversion
  • Q2. Project done in last company and how will you help Saama?

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to frame answers end to end and stick to what you have done. Don't try to exaggerate.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Data structure question asked

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are looking for job security and growth then skip this organisation

I applied via Naukri.com and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Informatica scenario based questions
  • Q2. Told to write complex sql queries based on some informations.
  • Q3. Agile methodology
  • Q4. What do you know about Saama

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview experience and good hike.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...
  • Q2. No of occurrences of letter in a string.
  • Ans. 

    Count occurrences of a letter in a string.

    • Iterate through each character in the string and count occurrences of the specified letter.

    • Use a hashmap to store the count of each letter.

    • Handle both uppercase and lowercase letters to ensure accurate counting.

  • Answered by AI

Skills evaluated in this interview

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

I appeared for an interview before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Form based JS questions. String questions in javascript
  • Q2. React interview questions with some state management follow up questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up on js ,es6, node.js
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Write a Postgres Query
  • Ans. 

    Query to retrieve all employees from a table named 'employees'

    • Use SELECT * FROM employees;

    • Make sure to replace 'employees' with the actual table name if different.

  • Answered by AI

Skills evaluated in this interview

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

I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 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 

(3 Questions)

  • Q1. Why are you looking for a change?
  • Q2. What is that you bring skills to the table that can add value to the Company
  • Q3. How can you bring value add to the Company
  • Ans. 

    I can bring value to the company by leveraging my technical expertise and leadership skills to drive innovation and improve efficiency.

    • Identifying and implementing new technologies to streamline processes

    • Mentoring and coaching team members to enhance their skills and productivity

    • Collaborating with cross-functional teams to develop and execute strategic plans

    • Ensuring adherence to industry standards and best practices

    • Con...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. What is your expectation?
  • Q2. How long do you think will continue with the Company

Interview Preparation Tips

Interview preparation tips for other job seekers - Contract jobs are also good with the Company. They put you on another Client once your contract ends with the existing client.

I applied via Naukri.com and was interviewed in Jul 2021. There were 2 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 - Technical 

(1 Question)

  • Q1. Overall idea about sap os/db migration
  • Ans. 

    SAP OS/DB migration involves moving SAP systems from one operating system and database to another.

    • It is a complex process that requires careful planning and execution.

    • It involves analyzing the current system landscape and identifying the target system.

    • The migration process includes data backup, system shutdown, system copy, and system startup.

    • Testing and validation are critical to ensure the new system is functioning p...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - till now no negative found.its good to join

Skills evaluated in this interview

I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL queries, joins, lead lag functions,
  • Q2. Unix scripting, snowflake, cloud technology background, practical experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was more of technical check, mostly bon SQL queries as I was considered as ETL developer.

Factspan Interview FAQs

How many rounds are there in Factspan Senior Principal Analyst interview?
Factspan interview process usually has 4 rounds. The most common rounds in the Factspan interview process are Coding Test, Technical and Aptitude Test.
How to prepare for Factspan Senior Principal 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 Data Warehousing, Python, SQL, ETL and GCP.
What are the top questions asked in Factspan Senior Principal Analyst interview?

Some of the top questions asked at the Factspan Senior Principal Analyst interview -

  1. In the second round I was asked mostly on SQLs, Optimization techniques to solv...read more
  2. Don't remember the questions but this round lasted about 30 minut...read more

Tell us how to improve this page.

Factspan Senior Principal Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

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

Fast track your campus placements

View all
Factspan Senior Principal Analyst Salary
based on 4 salaries
₹36.4 L/yr - ₹37 L/yr
59% more than the average Senior Principal Analyst Salary in India
View more details
Senior Analyst
97 salaries
unlock blur

₹9 L/yr - ₹20 L/yr

Business Analyst
60 salaries
unlock blur

₹6 L/yr - ₹10.5 L/yr

Analyst
58 salaries
unlock blur

₹6.5 L/yr - ₹10.5 L/yr

Associate Manager
52 salaries
unlock blur

₹13.5 L/yr - ₹20 L/yr

Data Analyst
30 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.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview