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
Selected
I appeared for an interview in Jan 2025.
Basic Pyspark/python question with some mcqs
(2 Questions)
- Q1. Project overview
- Q2. Pyspark, python , sql related questions.
(2 Questions)
- Q1. Basic technical question on spark and one python Dasa question and one sql
- Q2. Sql + python + spark + Adf + Databricks
(2 Questions)
- Q1. Why you want to join even though you have offers from good mnc
- Ans.
I am passionate about data engineering and believe this company offers unique opportunities for growth and learning.
Exciting projects and challenges at this company
Opportunities for growth and learning in data engineering
Alignment with company values and culture
Potential for career advancement and development
Interest in the industry or specific technologies used by the company
- Q2. Salary expectations and work culture
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
- Ans.
I would analyze the situation, identify the root cause, and propose a solution based on data-driven insights.
Analyze the data to understand the problem
Identify the root cause of the issue
Propose a solution based on data-driven insights
What people are saying about Fractal Analytics
Divisha Sharma
Selected
(1 Question)
- Q1. Sql questions and python
(1 Question)
- Q1. About last projects
Fractal Analytics interview questions for designations
(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..
Get interview-ready with Top Fractal Analytics Interview Questions
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
Data Engineer Jobs at Fractal Analytics
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
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
- Ans.
Developed a data pipeline to ingest, process, and analyze customer behavior data for targeted marketing campaigns.
Designed and implemented ETL processes to extract data from various sources
Utilized Apache Spark for data processing and analysis
Built machine learning models to predict customer behavior
Collaborated with marketing team to optimize campaign strategies
- 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
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 Senior Consultant Interview Questions
- Fractal Analytics Business Analyst 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
Interview Questions from Similar Companies
Fast track your campus placements
Fractal Analytics Data Engineer Reviews and Ratings
based on 88 reviews
Rating in categories
|
Consultant
1.1k
salaries
|  ₹7 L/yr - ₹24.1 L/yr |
|
Data Engineer
771
salaries
| ₹7.5 L/yr - ₹25.5 L/yr |
|
Senior Consultant
633
salaries
| ₹11 L/yr - ₹38 L/yr |
|
Data Scientist
495
salaries
| ₹8.5 L/yr - ₹31 L/yr |
|
Engineer
206
salaries
| ₹7.5 L/yr - ₹25.1 L/yr |
Subex
Kiya.ai
MathCo
Innovatiview India Ltd
- Home >
- Interviews >
- Fractal Analytics Interview Questions >
- Fractal Analytics Data Engineer Interview Questions
