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
22 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Jun 2024. There were 4 interview rounds.
(2 Questions)
- Q1. The HR representative will seek to understand your experience and its alignment with the role.
- Q2. Salary expectations, Offers in hand
(3 Questions)
- Q1. What are the key features and functionalities of Snowflake?
- Ans.
Snowflake is a cloud-based data warehousing platform known for its scalability, performance, and ease of use.
Snowflake uses a unique architecture called multi-cluster, which separates storage and compute resources for better scalability and performance.
It supports both structured and semi-structured data, allowing users to work with various data types.
Snowflake offers features like automatic scaling, data sharing, and ...
- Q2. The interviewer asked several complex SQL questions that utilized analytical functions.
- Q3. I was asked to write some syntax-level code for Jinja statements in dbt.
(2 Questions)
- Q1. The interviewer, who was part of the senior management, inquired about dbt, its features, and my experience with dbt thus far.
- Q2. The interviewer reviewed my resume and inquired about the challenges I encountered in my previous roles and the methods I used to resolve them.
(1 Question)
- Q1. Salary negotiations, Bonus discussions
Interview Preparation Tips
- dbt
- Snowflake
- AWS
- Python
- PySpark
- SQL
- Data Modelling
- Data Quality
- Airflow
I applied via Walk-in
A general round having mix of maths,aptitude,english,puzzle and quiz. level was easy
(2 Questions)
- Q1. Tell about yourself
- Q2. What step would you take in this situatiion
Divisha Sharma
Selected
(1 Question)
- Q1. Sql questions and python
(1 Question)
- Q1. About last projects
(1 Question)
- Q1. Basic SQL questions and Window fuctions
(1 Question)
- Q1. HR asked how was the interview last round and gave me feedback
Interview Preparation Tips
In fact interviewer turned camera off several times between and missed responding for a few seconds.
He even didn't tell me to share screen to see what I code.
Totally not serious about the interview..
Fractal Analytics interview questions for designations
Abhishek Rajeevan
Selected
I applied via Recruitment Consulltant and was interviewed before Dec 2023. There were 4 interview rounds.
I cannot recall the platform, but it featured a combination of Python and SQL questions, with the majority being focused on SQL.
(2 Questions)
- Q1. SQL basics like Indexes, Clustering, Keys, Data warehousing concepts, Normalization and Denormalization etc..
- Q2. SQL coding questions
(2 Questions)
- Q1. SQL questions to solve using different types of joins
- Q2. Questions based on project and data quality checks
(2 Questions)
- Q1. Behavioral questions
- Q2. Culture fit
Interview Preparation Tips
Get interview-ready with Top Fractal Analytics Interview Questions
Selected
I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.
Sql and python coding conducted
(1 Question)
- Q1. Questions on AWS or azure depending upon the platform you work. more conceptual questions on data engineering.
(1 Question)
- Q1. They check to which project you are fit to.
Interview Preparation Tips
Data Engineer Jobs at Fractal Analytics
Selected
I applied via LinkedIn and was interviewed before Jan 2024. There were 3 interview rounds.
Basic sql online assessment with some queries and mcq
(2 Questions)
- Q1. Explain project
- Q2. Pipeline optimization
(1 Question)
- Q1. Behavioral question
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There were 4 interview rounds.
(2 Questions)
- Q1. SQL query on joins, window function, remove duplicates, 2nd highest rank
- Q2. Azure Data Factory, ETL questions
(2 Questions)
- Q1. SQL, python technical questions
- Q2. Managerial questions
(2 Questions)
- Q1. Strength and weakness
- Q2. Typical hr questions
Quantitative Analysis, Data Interpretation, Logical Reasoning
Selected
I applied via Naukri.com and was interviewed before Sep 2023. There were 2 interview rounds.
They give you SQL assignment to complete based on that select for technical interview
(2 Questions)
- Q1. What are window functions in SQL
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Examples of window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
- Q2. Difference between group by and distinct
- Ans.
Group by is used to group rows that have the same values into summary rows, while distinct is used to remove duplicate rows from a result set.
Group by is used with aggregate functions like COUNT, SUM, AVG, etc.
Distinct is used to retrieve unique values from a column or set of columns.
Group by is used to perform operations on groups of rows, while distinct is used to filter out duplicate rows.
Group by is used in conjunc...
Skills evaluated in this interview
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
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 Data Analyst 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 18 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 L/yr - ₹24 L/yr |
|
Data Engineer
712
salaries
| ₹7.5 L/yr - ₹28 L/yr |
|
Senior Consultant
596
salaries
| ₹12.4 L/yr - ₹40 L/yr |
|
Data Scientist
451
salaries
| ₹8.4 L/yr - ₹33 L/yr |
|
Senior Engineer
196
salaries
| ₹15 L/yr - ₹36 L/yr |
Mu Sigma
AbsolutData
LatentView Analytics
Tiger Analytics
- Home >
- Interviews >
- Fractal Analytics Interview Questions >
- Fractal Analytics Data Engineer Interview Questions
