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

Affine Interview Questions, Process, and Tips

Updated 7 Mar 2025

Top Affine Interview Questions and Answers

View all 49 questions

Affine Interview Experiences

Popular Designations

49 interviews found

Associate Interview Questions & Answers

user image Anonymous

posted on 18 Mar 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Approached by Company

Round 1 - Technical 

(2 Questions)

  • Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
  • Q2. Joining tables with different joins
  • Ans. 

    Joining tables with different joins in SQL

    • Use INNER JOIN to return rows when there is at least one match in both tables

    • Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

    • Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

    • Use FULL JOIN to return rows when there is a match in one of the tables

  • Answered by AI

Skills evaluated in this interview

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR & why required for powder coating process ?
View answer (17)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Sep 2024.

Round 1 - Coding Test 

A coding test was administered to address several machine learning problem statements.

Round 2 - Technical 

(2 Questions)

  • Q1. Mention some metric in ML and explain the tradeoffs between them
  • Q2. How does the xgboost algorithm works , with explanation on every steps
Round 3 - One-on-one 

(4 Questions)

  • Q1. Write a program to reverse an array of integers and strings?
  • Q2. Write a program to count the maximum repetitive integer among one array?
  • Q3. Project discussion and why use specific algorithm
  • Q4. How does linear programming algorithm works ?

Senior Data Scientist Associate Interview Questions asked at other Companies

Q1. Evaluation metrics while training the model.
View answer (1)
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 asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

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

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

Affine interview questions for popular designations

 Data Analyst

 (8)

 Business Analyst

 (6)

 Data Scientist

 (5)

 Senior Associate

 (3)

 Data Engineer

 (3)

 Senior Data Scientist

 (2)

 Graduate Engineer

 (1)

 Associate Engineer

 (1)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Nov 2024

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

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

Round 1 - Technical 

(3 Questions)

  • Q1. Highlight the odd cells in excel
  • Ans. 

    Use conditional formatting to highlight odd cells in Excel

    • Select the range of cells you want to highlight

    • Go to the 'Home' tab and click on 'Conditional Formatting'

    • Choose 'New Rule' and select 'Use a formula to determine which cells to format'

    • Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

    • Choose the formatting style you want for the odd cells

  • Answered by AI
  • Q2. What are Joins in SQL, explain different joins and their outputs
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • INNER JOIN returns rows when there is at least one match in both tables

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table

    • RIGHT JOIN returns all rows from the right table and the matched rows from the left table

    • FU...

  • Answered by AI
  • Q3. Query to give running sum of salary
  • Ans. 

    Use window function to calculate running sum of salary in SQL

    • Use window function like SUM() with OVER() clause

    • Partition the data by employee ID if needed

    • Order the data by date or any other relevant column

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your SQL strong and practice joins with problem solving questions

Skills evaluated in this interview

Top Affine Data Analyst Interview Questions and Answers

Q1. What is the difference between Tree Map and Heatmap in Tableau?
View answer (1)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Get interview-ready with Top Affine Interview Questions

Power BI Developer Interview Questions & Answers

user image Shruti Yadav

posted on 21 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What are the types of data set you have worked upon?
  • Ans. 

    I have worked on various types of data sets including sales data, customer data, financial data, and social media data.

    • Sales data

    • Customer data

    • Financial data

    • Social media data

  • Answered by AI
  • Q2. Write dax for delta sales growth
  • Ans. 

    Calculate delta sales growth using DAX formula

    • Use the following DAX formula: Delta Sales Growth = (SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))) / CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))

    • Make sure to replace 'Sales[SalesAmount]' with the actual column name in your dataset

    • Ensure that 'Date'[DateKey]' is the date column in your dataset

  • Answered by AI

Skills evaluated in this interview

Power BI Developer Interview Questions asked at other Companies

Q1. Types of joins in power Bi & SQL and how it works?
View answer (7)

Jobs at Affine

View all

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 21 Mar 2024

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

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Coding Test 

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Round 2 - Technical 

(1 Question)

  • Q1. Simple questions on SQL were asked.
Round 3 - One-on-one 

(5 Questions)

  • Q1. What is pivot table in Excel?
  • Ans. 

    A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

    • Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

    • You can easily rearrange the layout of the data to view it from different perspectives.

    • Pivot tables can perform functions like sum, average, count, and more on the data.

    • They are useful for creating reports...

  • Answered by AI
  • Q2. What is 'Data Validation' in Excel?
  • Ans. 

    Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.

    • Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

    • Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

    • Data ...

  • Answered by AI
  • Q3. What is the order of execution of an SQL query?
  • Ans. 

    The order of execution of an SQL query involves multiple steps to retrieve data from a database.

    • 1. Parsing: The SQL query is first parsed to check for syntax errors.

    • 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

    • 3. Compilation: The optimized query is compiled into an executable form.

    • 4. Execution: The compiled query is executed by the database engine t...

  • Answered by AI
  • Q4. What is the difference between Tree Map and Heatmap in Tableau?
  • Ans. 

    Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.

    • Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

    • Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

    • Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...

  • Answered by AI
  • Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
  • Ans. 

    Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.

    • Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

    • Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

    • Extract Data can improve per...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Affine Data Analyst interview:
  • SQL
  • Power Bi
  • Tableau
  • Excel

Skills evaluated in this interview

Top Affine Data Analyst Interview Questions and Answers

Q1. What is the difference between Tree Map and Heatmap in Tableau?
View answer (1)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

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

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. I don't know why they rejected me
  • Q2. What ever they asked me for coding part the output is correct and logic is also correct

Full Stack Software Developer Interview Questions asked at other Companies

Q1. Oops in Java Patterns in Java JDK,JRE,JVM MVC Array questions strings in Java This,super keywords Java problems like palindrome, prime number,and so many problems and logics Why java is platform independent Why java is not platform dependen... read more
View answer (1)

Interview Questions & Answers

user image Anonymous

posted on 10 Sep 2024

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

I applied via Company Website and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is self-join
  • Ans. 

    Self-join is a SQL query that joins a table to itself.

    • Self-join is used when a table needs to be joined with itself to compare rows within the same table.

    • It is achieved by using table aliases to differentiate between the two instances of the same table.

    • Commonly used in hierarchical data structures or when comparing related records within the same table.

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

(1 Question)

  • Q1. What is a stored procedure
  • Ans. 

    A stored procedure is a set of SQL statements that are stored in a database and can be called by other programs or scripts.

    • Stored procedures can improve performance by reducing network traffic and executing complex operations on the database server.

    • They can be used to encapsulate business logic and enforce security measures.

    • Example: CREATE PROCEDURE GetCustomerOrders AS SELECT * FROM Orders WHERE CustomerID = @Customer

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

(1 Question)

  • Q1. What is difference between DROP and TRUNCATE statements?
  • Ans. 

    DROP deletes the table structure and data, while TRUNCATE deletes only the data.

    • DROP statement removes the table from the database, including all data and structure.

    • TRUNCATE statement removes all data from the table, but keeps the table structure intact.

    • DROP is a DDL (Data Definition Language) command, while TRUNCATE is a DML (Data Manipulation Language) command.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Affine interview:
  • SQL
  • Python
  • ETL
  • Datawareshouse
  • Cloud
Interview preparation tips for other job seekers - ask hr for important or primary skills and prepare well for the discussion.

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL and excel questions intermediate

Top Affine Data Analyst Interview Questions and Answers

Q1. What is the difference between Tree Map and Heatmap in Tableau?
View answer (1)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Affine Interview FAQs

How many rounds are there in Affine interview?
Affine interview process usually has 1-2 rounds. The most common rounds in the Affine interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Affine 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, AWS, ETL and Machine Learning.
What are the top questions asked in Affine interview?

Some of the top questions asked at the Affine interview -

  1. you have a pandas dataframe with three columns, filled with state names, city n...read more
  2. I have two jars of 5 litres and 3 litres. How can I measure 4 litres? (Assume: ...read more
  3. How to retain special characters (that pandas discards by default) in the data ...read more
How long is the Affine interview process?

The duration of Affine interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Affine Interview Process

based on 39 interviews

Interview experience

3.6
  
Good
View more
Join Affine Command The New

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.0
 • 9 Interviews
Crayon Data Interview Questions
3.6
 • 4 Interviews
View all

Affine Reviews and Ratings

based on 168 reviews

3.3/5

Rating in categories

3.5

Skill development

3.1

Work-life balance

3.2

Salary

3.1

Job security

3.2

Company culture

2.9

Promotions

3.2

Work satisfaction

Explore 168 Reviews and Ratings
Business Analyst

Bangalore / Bengaluru

3-5 Yrs

₹ 10-20 LPA

Python Engineer

Bangalore / Bengaluru

5-9 Yrs

Not Disclosed

Explore more jobs
Senior Associate
128 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
94 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
86 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