Premium Employer

i

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

Affine Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Affine Data Engineer Interview Questions and Answers

Updated 8 Jan 2025

Affine Data Engineer Interview Experiences

3 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(4 Questions)

  • Q1. All employees having same salary in the smae department sql and pysprk
  • Q2. How to create pipeline in databricks
  • Ans. 

    To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.

    • Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

    • Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

    • Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.

  • Answered by AI
  • Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...
  • Q4. String manuplation questions inpython

Interview Preparation Tips

Interview preparation tips for other job seekers - PRepare well on pyspark

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 24 Sep 2024

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

(2 Questions)

  • Q1. Describe your workflow of the last project
  • Ans. 

    Developed ETL pipeline to ingest, clean, and analyze customer data for personalized marketing campaigns

    • Gathered requirements from stakeholders to understand data sources and business objectives

    • Designed data model to store customer information and campaign performance metrics

    • Implemented ETL process using Python and Apache Spark to extract, transform, and load data

    • Performed data quality checks and created visualizations ...

  • Answered by AI
  • Q2. What are the different transformations you have used
  • Ans. 

    I have used various transformations such as filtering, joining, aggregating, and pivoting in my data engineering projects.

    • Filtering data based on certain conditions

    • Joining multiple datasets together

    • Aggregating data to summarize information

    • Pivoting data from rows to columns or vice versa

  • Answered by AI
Round 2 - One-on-one 

Skills evaluated in this interview

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

Data Engineer Interview Questions & Answers

user image do achieve

posted on 18 Sep 2024

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

(1 Question)

  • Q1. What is dual mode in Power BI
  • Ans. 

    Dual mode in Power BI allows users to switch between DirectQuery and Import modes for data sources.

    • Dual mode allows users to combine the benefits of both DirectQuery and Import modes in Power BI.

    • Users can switch between DirectQuery and Import modes for different data sources within the same report.

    • DirectQuery mode connects directly to the data source for real-time data retrieval, while Import mode loads data into Power...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Views on their recruiting process
  • Ans. 

    I believe the recruiting process is thorough and well-organized.

    • The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.

    • They have a clear timeline for the hiring process and keep candidates informed of their progress.

    • Feedback is provided to candidates after interviews to help them improve for future opportunities.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience:

Interview Preparation Tips

Round: Test
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40

Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.

Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.

Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P

General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore

I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Coding Test 

SQL test has been conducted nearer to 12-15 questions.

Round 3 - HR 

(2 Questions)

  • Q1. Normal discussion, about salary negotiation
  • Q2. Asked about my past company experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Best of luck.
They have lots of opportunities.....................
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. All basic concepts of pthon sql and ml
Round 2 - Coding Test 

Apptitude, tecncal, cognitiive

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

I applied via Campus Placement and was interviewed in Nov 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

Blood Relations, Pipes and Cisterns, Time and work etc.

Round 2 - Coding Test 

Question based on hashmap

Round 3 - Group Discussion 

Is Artificial Intelligence boon or ban.

Round 4 - Technical 

(2 Questions)

  • Q1. Python and SQL questions
  • Q2. Python and Numpy, Pandas

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare from your resume.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic SQL questions
  • Q2. Statistical questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Spark and airflow related questions
  • Q2. AWS services and it's related questions
Contribute & help others!
anonymous
You can choose to be anonymous

Affine Interview FAQs

How many rounds are there in Affine Data Engineer interview?
Affine interview process usually has 1-2 rounds. The most common rounds in the Affine interview process are Technical and One-on-one Round.
How to prepare for Affine 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 Affine. The most common topics and skills that interviewers at Affine expect are SQL, Python, ETL, Data Warehousing and Spark.
What are the top questions asked in Affine Data Engineer interview?

Some of the top questions asked at the Affine Data Engineer interview -

  1. what are the different transformations you have u...read more
  2. how to create pipeline in databri...read more
  3. What is dual mode in Power...read more

Recently Viewed

INTERVIEWS

Essar Group

No Interviews

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Affine

No Interviews

INTERVIEWS

3Pillar Global

No Interviews

INTERVIEWS

Essar Group

No Interviews

INTERVIEWS

Arup

No Interviews

INTERVIEWS

Perforce Software

No Interviews

INTERVIEWS

AppDynamics

No Interviews

SALARIES

Affine

SALARIES

Betsol

Tell us how to improve this page.

Affine Data Engineer Interview Process

based on 3 interviews

1 Interview rounds

  • Technical Round
View more
Join Affine Command The New
Affine Data Engineer Salary
based on 47 salaries
₹6 L/yr - ₹15 L/yr
5% more than the average Data Engineer Salary in India
View more details

Affine Data Engineer Reviews and Ratings

based on 4 reviews

2.2/5

Rating in categories

2.8

Skill development

1.6

Work-life balance

2.5

Salary

2.3

Job security

2.2

Company culture

2.2

Promotions

2.2

Work satisfaction

Explore 4 Reviews and Ratings
Senior Associate
129 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
94 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
47 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Affine 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