AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Fractal Analytics Data Engineer Interview Questions, Process, and Tips
Top Fractal Analytics Data Engineer Interview Questions and Answers
- Q1. In a word count spark program which command will run on driver and which will run on executor
- Q2. What are the key features and functionalities of Snowflake?
- Q3. Joins in Sql, Modelling and visualization part in PowerBI
Fractal Analytics Data Engineer Interview Experiences
23 interviews found
Anonymous
I applied via Referral and was interviewed in Jun 2022. There were 5 interview rounds.
It was through a link they share and you need to write and submit your code, no execution needed.
(1 Question)
- Q1. R1 was about 40 mins and was a bit tough. Asked more about ADF, ADB, SQL, SQL DW
(1 Question)
- Q1. R2: Was the toughest, asked for 40 mins and more than 30 questions were asked, lucky enough to answer all of them.
(1 Question)
- Q1. Some Managerial questions for 30mins, handling conflicts, leadership skills etc
(1 Question)
- Q1. Asked why I want to join fractal, why looking for other offer, biggest achievement etc
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Jul 2023. There were 2 interview rounds.
It's a coding test of python and sql for 1-2, years of role and an aptitude test of verbal,quants,reasoning and data interpretation questions
Questions related to python,sql,pandas,numpy,previous projects
Interview Preparation Tips
- Python
- SQL
- Pyspark
- ETL
- Pandas
- Numpy
Billuri Tejaswini
Selected
I applied via Campus Placement and was interviewed before Jan 2023. There were 4 interview rounds.
Aptitude test has 70 questions to be done in 75 minutes. It's moderately tough but not very tough with right amount of preparation
I was from non-cs background so coding round was not mandatory but for cs people it was mandatory to clear it. It has SQL and python and they were easy to moderate. I am a fresher (imagineer) so we had to go this interview process
(1 Question)
- Q1. The interviewer was really nice and that went so smooth for me. 1. Asked questions from IC Engines and stuff 😄, as I was from mechanical 2.In coding, Sorting and Oops concepts were asked 3. Guessimates ...
(1 Question)
- Q1. Typical HR questions
Selected
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
Basics codes, filtration round
(1 Question)
- Q1. Explain Sorting algorithms
- Ans.
Sorting algorithms are methods used to arrange elements in a specific order.
Sorting algorithms are used to rearrange elements in a specific order, such as numerical or alphabetical.
Common sorting algorithms include Bubble Sort, Selection Sort, Insertion Sort, Merge Sort, Quick Sort, and Heap Sort.
Each sorting algorithm has its own time complexity and efficiency based on the size of the input data.
Sorting algorithms can...
(1 Question)
- Q1. Tell me something about yourself
Skills evaluated in this interview
Fractal Analytics interview questions for designations
Selected
I applied via Job Fair and was interviewed before Feb 2023. There were 3 interview rounds.
1 hour, 2 coding and 20 MCQs
(1 Question)
- Q1. 1 hour deep discussion on data engineering
(1 Question)
- Q1. Salary discussion, company policies etc
Interview Preparation Tips
Get interview-ready with Top Fractal Analytics Interview Questions
I applied via campus placement at National Institute of Technology,(NIT), Agartala and was interviewed before Jan 2023. There were 5 interview rounds.
Sql,python and java question
Quant,LRDI question, Data interpration
(1 Question)
- Q1. Resume based technical questions
(1 Question)
- Q1. Based in business acumen
(1 Question)
- Q1. Personality based
Data Engineer Jobs at Fractal Analytics
I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Basic spark questions like optimization techniques
- Q2. Reparation coalesce joins
- Q3. Slowly change data handling in spark
- Ans.
Slowly changing data handling in Spark involves updating data over time.
Slowly changing dimensions (SCD) are used to track changes in data over time.
SCD Type 1 updates the data in place, overwriting the old values.
SCD Type 2 creates a new record for each change, with a start and end date.
SCD Type 3 adds a new column to the existing record to track changes.
Spark provides functions like `from_unixtime` and `unix_timestam
- Q4. Cumulative sum and rank functions in spark
- Ans.
Explanation of cumulative sum and rank functions in Spark
Cumulative sum function calculates the running total of a column
Rank function assigns a rank to each row based on the order of values in a column
Both functions can be used with window functions in Spark
Example: df.withColumn('cumulative_sum', F.sum('column').over(Window.orderBy('order_column').rowsBetween(Window.unboundedPreceding, Window.currentRow)))
Example: df...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Feb 2022. There were 4 interview rounds.
MCQ SQL round coding easy questions
(1 Question)
- Q1. Resume based questions mostly on SQL, Python, Cloud basic to medium level
(1 Question)
- Q1. It was both mangerial and technical round similar to round 1 but more deep
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Round 1: Coding round, Round 2: Basic and conceptual from Spark and Hive, Round 3: In Depth question from Spark and Hive, Write code in Spark and Hive.
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Joins in Sql, Modelling and visualization part in PowerBI
- Ans.
Answering about joins in SQL and modeling/visualization in PowerBI
Joins in SQL are used to combine data from two or more tables based on a related column
There are different types of joins such as inner join, left join, right join, and full outer join
PowerBI is a data visualization tool that allows users to create interactive reports and dashboards
Data modeling in PowerBI involves creating relationships between tables a...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Fractal Analytics Interview FAQs
Some of the top questions asked at the Fractal Analytics Data Engineer interview -
The duration of Fractal Analytics Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Fractal Analytics Interviews By Designations
- Fractal Analytics Consultant Interview Questions
- Fractal Analytics Data Engineer Interview Questions
- Fractal Analytics Data Scientist Interview Questions
- Fractal Analytics Software Engineer Interview Questions
- Fractal Analytics Decision Scientist Interview Questions
- Fractal Analytics Business Analyst Interview Questions
- Fractal Analytics Senior Consultant Interview Questions
- Fractal Analytics Summer Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Fractal Analytics Data Engineer Interview Process
based on 19 interviews
4 Interview rounds
- Coding Test Round
- Technical Round - 1
- Technical Round - 2
- HR Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Fractal Analytics Data Engineer Reviews and Ratings
based on 87 reviews
Rating in categories
|
Consultant
1.1k
salaries
|  ₹6.8 L/yr - ₹24 L/yr |
|
Data Engineer
717
salaries
| ₹7.5 L/yr - ₹28 L/yr |
|
Senior Consultant
586
salaries
| ₹11 L/yr - ₹40 L/yr |
|
Data Scientist
462
salaries
| ₹8.4 L/yr - ₹33 L/yr |
|
Senior Engineer
201
salaries
| ₹15 L/yr - ₹44 L/yr |
Mu Sigma
AbsolutData
LatentView Analytics
Tiger Analytics
- Home >
- Interviews >
- Fractal Analytics Interview Questions >
- Fractal Analytics Data Engineer Interview Questions
