Upload Button Icon Add office photos

Fractal Analytics

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Fractal Analytics Senior Data Engineer Interview Questions and Answers

Updated 23 May 2024

Fractal Analytics Senior Data Engineer Interview Experiences

3 interviews found

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

I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Interviews question about adf adls gen2 ,databricks and experience
  • Ans. One might ask you on how can one configure these
  • Answered Anonymously
  • Q2. Transformations in databricks
  • Ans. 

    Transformations in Databricks involve manipulating data using functions like map, filter, reduce, etc.

    • Transformations are operations that are applied to RDDs in Databricks

    • Common transformations include map, filter, reduce, flatMap, etc.

    • Transformations are lazy evaluated and create a new RDD

    • Example: map transformation to convert each element in an RDD to uppercase

  • Answered by AI
  • Q3. Concepts in spark
  • Ans. 

    Spark is a distributed computing framework for processing big data.

    • Spark is built around the concept of Resilient Distributed Datasets (RDDs)

    • It supports various programming languages like Scala, Java, Python, and R

    • Spark provides high-level APIs like DataFrames and Datasets for structured data processing

    • It includes libraries for SQL, streaming, machine learning, and graph processing

    • Spark can run on various cluster manag

  • Answered by AI
Round 2 - Technical 

(3 Questions)

  • Q1. In depth discussion on projects
  • Q2. Performance enhancemnets in pyspark
  • Ans. 

    Performance enhancements in PySpark involve optimizing code, tuning configurations, and utilizing efficient data structures.

    • Use partitioning to distribute data evenly across nodes

    • Cache intermediate results to avoid recomputation

    • Optimize joins by broadcasting smaller tables

    • Use efficient data formats like Parquet or ORC

    • Tune Spark configurations for memory and parallelism

  • Answered by AI
  • Q3. Data handling and data quality

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

It was a hackerearth test ranging from simple to intermediate

Round 2 - Technical 

(2 Questions)

  • Q1. Basic on Pyspark, Hive
  • Q2. Basic on SQL related
Round 3 - Technical 

(1 Question)

  • Q1. It was tougher round with coding questions

Interview Preparation Tips

Topics to prepare for Fractal Analytics Senior Data Engineer interview:
  • Spark
  • Hadoop
  • Hive
  • SQL

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more

I applied via Naukri.com and was interviewed before Nov 2021. There were 4 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 Resume tips
Round 2 - Coding Test 

Language coding test which might be very specific to the proficient for data technologies

Round 3 - Technical 

(1 Question)

  • Q1. More of basic understanding on the concepts of processing of data and related technologies
Round 4 - Technical 

(1 Question)

  • Q1. In terms of architecture understanding and designing perspective

Interview Preparation Tips

Interview preparation tips for other job seekers - Should be good in basics of data understanding and it's processing

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Sep 2021. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. 1. Types of cloud 2.Different Activity in ADF 3.Advance SQL 4.Basic OPPS concepts
  • Ans. 

    Questions related to cloud types, ADF activities, advanced SQL, and basic OOPs concepts.

    • Types of cloud include public, private, and hybrid

    • ADF activities include data ingestion, transformation, and loading

    • Advanced SQL includes window functions, subqueries, and joins

    • Basic OOPs concepts include encapsulation, inheritance, and polymorphism

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. 1. Secenario bases case study. 2.Performance tuning in Datebases and warehouse. 3.SQL Logics

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and and answer to the point as per knowledge and experience and understanding.
Talk about past work experiences

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL problems to solve nth highest salary
  • Ans. 

    Use SQL query with subquery to find nth highest salary

    • Use ORDER BY and LIMIT to get the nth highest salary

    • Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary

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

(1 Question)

  • Q1. GCP big query Architecture

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Basics of SQL, Python

Round 2 - Coding Test 

Experience based questions, SQL and Python

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about the projects you worked on
  • Ans. 

    I have worked on projects involving building data pipelines, optimizing data storage, and developing machine learning models.

    • Built data pipelines using Apache Spark and Airflow

    • Optimized data storage by implementing partitioning and indexing strategies

    • Developed machine learning models for predictive analytics

  • Answered by AI
  • Q2. Based on experience some questions related to projects.

I applied via LinkedIn and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical Questions were easy. No coding questions just on architecture level and basic system design questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Got selected in interview. However offer was not released. Time to time HR would call to check whether I am serving notice. "You were searching from long time, still you don't have any other offer yet ". This shows HR team just want to hire someone who is already serving notice irrespective of the rounds cleared
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Prepare well on coding n programming

Round 2 - Group Discussion 

Topic will be give should talk for a min

I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Technical concepts in Hadoop, Spark, FileSystem, Hive. Cultural questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for collection operations, SQL, Spark, Hive
Round 1 - Coding Test 

Python and SQL scenarios

Round 2 - Technical 

(1 Question)

  • Q1. Work experience and Python and Sql questions
Round 3 - Technical 

(1 Question)

  • Q1. Role fit..work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for Python and Sql scenario questions
Contribute & help others!
anonymous
You can choose to be anonymous

Fractal Analytics Interview FAQs

How many rounds are there in Fractal Analytics Senior Data Engineer interview?
Fractal Analytics interview process usually has 3 rounds. The most common rounds in the Fractal Analytics interview process are Technical, Coding Test and Resume Shortlist.
How to prepare for Fractal Analytics Senior Data Engineer 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 Fractal Analytics. The most common topics and skills that interviewers at Fractal Analytics expect are SQL, Python, SDLC, Analytics and Data Engineering.
What are the top questions asked in Fractal Analytics Senior Data Engineer interview?

Some of the top questions asked at the Fractal Analytics Senior Data Engineer interview -

  1. Performance enhancemnets in pysp...read more
  2. Transformations in databri...read more
  3. Concepts in sp...read more

Recently Viewed

INTERVIEWS

Housing.com

No Interviews

INTERVIEWS

Housing.com

No Interviews

INTERVIEWS

Walmart

10 top interview questions

INTERVIEWS

HTC Global Services

No Interviews

INTERVIEWS

Housing.com

No Interviews

INTERVIEWS

MathCo

No Interviews

INTERVIEWS

MagicBricks

No Interviews

INTERVIEWS

Photon Interactive

No Interviews

INTERVIEWS

Zetwerk

No Interviews

LIST OF COMPANIES

Discover companies

Find best workplace

Tell us how to improve this page.

Fractal Analytics Senior Data Engineer Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
MathCo Interview Questions
2.9
 • 110 Interviews
Zeta Interview Questions
3.3
 • 69 Interviews
Kiya.ai Interview Questions
3.2
 • 48 Interviews
C5i Interview Questions
3.7
 • 46 Interviews
Subex Interview Questions
3.5
 • 35 Interviews
View all
Fractal Analytics Senior Data Engineer Salary
based on 149 salaries
₹15 L/yr - ₹40 L/yr
48% more than the average Senior Data Engineer Salary in India
View more details

Fractal Analytics Senior Data Engineer Reviews and Ratings

based on 14 reviews

4.1/5

Rating in categories

4.1

Skill development

4.0

Work-life balance

4.1

Salary

4.4

Job security

4.4

Company culture

3.0

Promotions

3.6

Work satisfaction

Explore 14 Reviews and Ratings
Consultant
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
718 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
588 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
462 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engineer
202 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Fractal Analytics with

Mu Sigma

2.6
Compare

AbsolutData

3.6
Compare

LatentView Analytics

3.7
Compare

Tiger Analytics

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