Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Blackstraw AI Team. If you also belong to the team, you can get access from here

Blackstraw AI Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Blackstraw AI Data Engineer Interview Questions and Answers

Updated 2 Sep 2024

Blackstraw AI Data Engineer Interview Experiences

2 interviews found

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Remove duplicates from array
  • Ans. 

    Remove duplicates from array of strings

    • Use a Set data structure to store unique elements

    • Convert the array to a Set to remove duplicates

    • Convert the Set back to an array if needed

  • Answered by AI
  • Q2. Window function

Interview Preparation Tips

Interview preparation tips for other job seekers - although the interview went well but they did not even reply back

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Apr 2022

I was interviewed in Oct 2021.

Round 1 - Technical 

(1 Question)

  • Q1. Python collections numpy pandas library Sql windows functions Spark

Interview Preparation Tips

Interview preparation tips for other job seekers - Good luck!! !!!!!!!!!!!!!!!!!!!!!!

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Assignment 

They give you SQL assignment to complete based on that select for technical interview

Round 2 - Technical 

(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().

  • Answered by AI
  • 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...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. How to decide upon Spark cluster sizing?
  • Ans. 

    Spark cluster sizing depends on workload, data size, memory requirements, and processing speed.

    • Consider the size of the data being processed

    • Take into account the memory requirements of the Spark jobs

    • Factor in the processing speed needed for the workload

    • Scale the cluster based on the number of nodes and cores required

    • Monitor performance and adjust cluster size as needed

  • Answered by AI
  • Q2. Question on Spark internals
Round 2 - Case Study 

Implement a pipeline based on given conditions and data requirement

Round 3 - HR 

(1 Question)

  • Q1. There were no questions as such. They want me join on very next day when the HR discussion was over and started itimidating me with aggressive approach even without discussing the salary part and the benef...

Interview Preparation Tips

Interview preparation tips for other job seekers - I could clear both the rounds and salary discussion was the only thing left I decided not to join the company because of the way HR handled the process.
Based on the HR behaviour, I can say there is no respect for an employee/ candidate.
The behaviour was like as if I am at the mercy of the employer and I don't have any other company in this world.

Skills evaluated in this interview

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

I applied via Recruitment Consulltant and was interviewed before Dec 2023. There were 4 interview rounds.

Round 1 - Coding Test 

I cannot recall the platform, but it featured a combination of Python and SQL questions, with the majority being focused on SQL.

Round 2 - One-on-one 

(2 Questions)

  • Q1. SQL basics like Indexes, Clustering, Keys, Data warehousing concepts, Normalization and Denormalization etc..
  • Q2. SQL coding questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. SQL questions to solve using different types of joins
  • Q2. Questions based on project and data quality checks
Round 4 - HR 

(2 Questions)

  • Q1. Behavioral questions
  • Q2. Culture fit

Interview Preparation Tips

Interview preparation tips for other job seekers - Fractal typically emphasizes core skills in programming and data engineering. It is important to have a solid understanding of the fundamentals and to be prepared for coding challenges, as well as knowledge of data warehousing and ETL concepts.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Jan 2022. 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 - Aptitude Test 

In the first round they ask some technical mcq and gave some coding questions in python and SQL.there were less aptitude questions.

Round 3 - Technical 

(4 Questions)

  • Q1. Just asking simple string based questions and some difficult sql questions .it was 1hr section.
  • Q2. Groupby having, joins like inner outer left right
  • Q3. Most frequent word in a sentence ?
  • Ans. 

    The most frequent word in a sentence can be found by counting the occurrence of each word and selecting the one with the highest count.

    • Split the sentence into words using whitespace as delimiter

    • Create a dictionary to store the count of each word

    • Iterate through the words and update the count in the dictionary

    • Find the word with the highest count in the dictionary

  • Answered by AI
  • Q4. Given some tables and extract the values between some values and fileter by some values

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in Python and SQL .and be strong in thinking abilities.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Simple mcq's and coding

Round 2 - One-on-one 

(1 Question)

  • Q1. In depth question on your work
Round 3 - One-on-one 

(1 Question)

  • Q1. Detailed question of your tech stack advancement
Round 4 - HR 

(1 Question)

  • Q1. Work culture, location
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain spark architecture
  • Ans. 

    Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.

    • Consists of a driver program that manages the execution of tasks

    • Utilizes a cluster manager to allocate resources and schedule tasks

    • Worker nodes execute the tasks and store data in memory or disk

    • Supports fault tolerance through resilient distributed datasets (RDDs)

  • Answered by AI

Skills evaluated in this interview

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

I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Different type of license in power bi. Data Modelling.
  • Ans. 

    Power BI offers different types of licenses for data modeling, including Power BI Pro and Power BI Premium.

    • Power BI Pro license allows users to create and share reports and dashboards with others.

    • Power BI Premium license offers additional features such as larger data capacity and advanced AI capabilities.

    • Power BI Embedded license is designed for embedding reports and dashboards into custom applications.

    • Power BI Report ...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. What abt you know tiger
  • Q2. General hr questions

Interview Preparation Tips

Topics to prepare for Tiger Analytics Data Engineer interview:
  • Power Bi
  • Data Modeling
  • SQL
Interview preparation tips for other job seekers - Na

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Spark Architecture
  • Q2. Data warehousing

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain data warehousing concept
Contribute & help others!
anonymous
You can choose to be anonymous

Blackstraw AI Interview FAQs

How many rounds are there in Blackstraw AI Data Engineer interview?
Blackstraw AI interview process usually has 1 rounds. The most common rounds in the Blackstraw AI interview process are Technical.
How to prepare for Blackstraw AI 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 Blackstraw AI. The most common topics and skills that interviewers at Blackstraw AI expect are Artificial Intelligence, Data Integration, Data Mining, Deep Learning and Hadoop.
What are the top questions asked in Blackstraw AI Data Engineer interview?

Some of the top questions asked at the Blackstraw AI Data Engineer interview -

  1. remove duplicates from ar...read more
  2. Python collections numpy pandas library Sql windows functions Sp...read more
  3. window funct...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Data Economy

No Interviews

INTERVIEWS

Frontizo Business Services

No Interviews

INTERVIEWS

Oracle

No Interviews

INTERVIEWS

WinZO

No Interviews

INTERVIEWS

BT Group

No Interviews

INTERVIEWS

Shriram General Insurance

No Interviews

INTERVIEWS

Smarter BIZ Technologies

No Interviews

INTERVIEWS

Fidelity Investments

No Interviews

Tell us how to improve this page.

Blackstraw AI Data Engineer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Blackstraw AI Data Engineer Salary
based on 33 salaries
₹4.5 L/yr - ₹13.2 L/yr
21% less than the average Data Engineer Salary in India
View more details

Blackstraw AI Data Engineer Reviews and Ratings

based on 3 reviews

3.6/5

Rating in categories

4.4

Skill development

3.8

Work-life balance

3.6

Salary

3.7

Job security

4.1

Company culture

3.1

Promotions

3.6

Work satisfaction

Explore 3 Reviews and Ratings
Data Scientist
39 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
35 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Blackstraw AI with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent