Upload Button Icon Add office photos

Fractal Analytics

Compare button icon Compare button icon Compare

Filter interviews by

Fractal Analytics AWS Data Engineer Interview Questions and Answers

Updated 16 Oct 2022

Fractal Analytics AWS Data Engineer Interview Experiences

1 interview found

AWS Data Engineer Interview Questions & Answers

user image Tomrock D'souza

posted on 16 Oct 2022

I applied via Approached by Company and was interviewed before Oct 2021. There were 5 interview rounds.

Round 1 - Coding Test 

Do select coding test. then 2 basic data manipulation and sql rounds then management round

Round 2 - Technical 

(2 Questions)

  • Q1. First Letter of firstname in a column in any data manipulation package supported on databricks
  • Ans. 

    The function to extract the first letter of the firstname in a column varies based on the data manipulation package used.

    • Use SUBSTR function in SQL

    • Use str_extract function in R

    • Use substring function in Python

  • Answered by AI
  • Q2. Windows function based sql problem
  • Ans. 

    Understanding SQL window functions for advanced data analysis and reporting.

    • Window functions perform calculations across a set of table rows related to the current row.

    • Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and SUM().

    • Example: SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees;

    • Window functions can be used with PARTITION BY to segment data, e.g., SELE...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Basic Leetcode problem with medium difficulty
Round 4 - One-on-one 

(1 Question)

  • Q1. Asked why I switched so much
Round 5 - HR 

(1 Question)

  • Q1. Asking if working in AWS squad is what I would like instead of big data

Interview Preparation Tips

Interview preparation tips for other job seekers - If you can complete their coding test probably you are good to go.

Top trending discussions

View All
Interview Tips & Stories
6d (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Fractal Analytics?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Apr 2021. There were 5 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 - Aptitude Test 

Time and work, time and distance, percentages, data interpretation

Round 3 - Case Study 

Business case study - increase revenue for museum

Round 4 - Technical 

(1 Question)

  • Q1. Common machine learning algorithms, statistical concepts, projects mentioned in resume
Round 5 - One-on-one 

(2 Questions)

  • Q1. Management round, behavioral questions were asked.
  • Q2. Why Mathcompany?, what if your current company offers more pay?

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best for your interview

AWS Data Engineer Interview Questions Asked at Other Companies

asked in Cognizant
Q1. Which libraries did you use in your project, and how did you impo ... read more
asked in TCS
Q2. Explain use of * in both the args and kwargs. Expedition handling ... read more
asked in LTIMindtree
Q3. Modify null salary with avg salary, find count of employees by jo ... read more
asked in HARMAN
Q4. Write a program to find the greatest element from a list of eleme ... read more
asked in EXL Service
Q5. what is the devops? how both python is used? what can be done for ... read more

I applied via Campus Placement and was interviewed before Aug 2021. There were 4 interview rounds.

Round 1 - Coding Test 

Duration: 1hr
Topics: Array, LinkedList,Stack

Round 2 - Technical 

(2 Questions)

  • Q1. Write code for Insertion in a binary tree.
  • Q2. Write code for quick sort
Round 3 - Technical 

(1 Question)

  • Q1. Various DBMS related question(JOINS, SORT, LIMIT)
Round 4 - HR 

(2 Questions)

  • Q1. Tell us about yourself.
  • Q2. Why do want to join the company

Interview Preparation Tips

Topics to prepare for Hughes Systique Corporation Software Engineer interview:
  • C++
  • Data Structures
  • SQL
Interview preparation tips for other job seekers - Just be confident and explain your thought process and go with the flow

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Dec 2023. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Famous Java Questions like why string is immuatable and basics of OOPs.
  • Q2. Easy to medium level DSA based on array and string.
Round 2 - Technical 

(2 Questions)

  • Q1. Project Related Questions
  • Q2. Questions related to java 8 stream API
Round 3 - Technical 

(2 Questions)

  • Q1. Question related to basic recursion
  • Q2. Top kafka interview questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Your basics should be strong.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Recruitment Consulltant

Round 1 - One-on-one 

(2 Questions)

  • Q1. Minimum element in an array
  • Q2. Reverse a linked list

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your basics good then you can crack the interview

Skills evaluated in this interview

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

I appeared for an interview before Aug 2023.

Round 1 - Technical 

(2 Questions)

  • Q1. Java8 and multhithreading based questions
  • Q2. 1 Leetcode easy question
Round 2 - Technical 

(2 Questions)

  • Q1. TDD based live coding and spring based question
  • Q2. 1 leetcode medium question
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiations and company fit based questions
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. To do list design
Round 2 - Technical 

(1 Question)

  • Q1. Project related

Interview Preparation Tips

Topics to prepare for Deutsche Telekom Digital Labs Software Engineer interview:
  • DSA
Interview preparation tips for other job seekers - goodluck
Are these interview questions helpful?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview before May 2024, where I was asked the following questions.

  • Q1. DSA leetcode problems
  • Q2. SPring concepts
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Basic questions of angular and javascript.
  • Q2. Es6 feature , typescript features
  • Q3. Promise, observable, focus on syntax of every thing like interceptor, routing, gaurd and all .
Round 2 - Technical 

(3 Questions)

  • Q1. Behaviour subject, subject, life cycle hooks
  • Q2. This round was not very easy in my case.
  • Q3. Be prepared for array and object of array questions. Like sorting, searching, filtering , any logic .
Round 3 - HR 

(1 Question)

  • Q1. Basic HR questions and managerial round. Not being hard . But learn about your project and past organisation
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

2 coding questions and 7 aptitude questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Linked List creation was asked
Round 3 - Assignment 

General HR questions

Fractal Analytics Interview FAQs

How many rounds are there in Fractal Analytics AWS Data Engineer interview?
Fractal Analytics interview process usually has 6 rounds. The most common rounds in the Fractal Analytics interview process are Technical, Resume Shortlist and Coding Test.
How to prepare for Fractal Analytics AWS 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 AWS, EMR, Python, AWS Glue and Data Engineering.
What are the top questions asked in Fractal Analytics AWS Data Engineer interview?

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

  1. First Letter of firstname in a column in any data manipulation package supporte...read more
  2. Windows function based sql prob...read more
  3. Basic Leetcode problem with medium difficu...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

MathCo Interview Questions
3.0
 • 116 Interviews
Zeta Interview Questions
3.4
 • 74 Interviews
Kiya.ai Interview Questions
3.4
 • 50 Interviews
CoinDCX Interview Questions
3.8
 • 31 Interviews
MoEngage Interview Questions
3.9
 • 27 Interviews
Seclore Interview Questions
4.0
 • 27 Interviews
Demandbase Interview Questions
3.8
 • 18 Interviews
View all
Fractal Analytics AWS Data Engineer Salary
based on 5 salaries
₹18 L/yr - ₹26 L/yr
126% more than the average AWS Data Engineer Salary in India
View more details

Fractal Analytics AWS Data Engineer Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Python+AWS Data Engineer

Noida,

Mumbai

+4

4-7 Yrs

Not Disclosed

AWS Data Engineer

Mumbai,

Pune

+3

2-10 Yrs

Not Disclosed

Explore more jobs
Consultant
1.2k salaries
unlock blur

₹11.3 L/yr - ₹20 L/yr

Data Engineer
948 salaries
unlock blur

₹9 L/yr - ₹23.5 L/yr

Senior Consultant
742 salaries
unlock blur

₹20 L/yr - ₹34.4 L/yr

Data Scientist
581 salaries
unlock blur

₹14 L/yr - ₹25 L/yr

Senior Data Scientist
350 salaries
unlock blur

₹22 L/yr - ₹38 L/yr

Explore more salaries
Compare Fractal Analytics with

Kiya.ai

3.4
Compare

MathCo

3.0
Compare

Innovatiview India Ltd

3.9
Compare

Zeta

3.4
Compare
write
Share an Interview