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 Associate Interview Questions and Answers

Updated 18 Mar 2024

Affine Associate Interview Experiences

1 interview 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

Interview questions from similar companies

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

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

Round 1 - Aptitude Test 

The Aptitude round was of mediocre level, get well prepared for it and it is a qualifying round

Round 2 - Technical 

(2 Questions)

  • Q1. Project Related Questions
  • Q2. Data Warehouse and modeling related questions, along with schema selection in various scenarios
Round 3 - Behavioral 

(2 Questions)

  • Q1. About Myself, Why Axtria, Pharma related questions
  • Q2. Real life scenarios

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was fairly easy and the whole process took 2-3 weeks
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed in Aug 2023.

Round 1 - Aptitude Test 

Logical, statistics, Aptitude, Data science and analytics

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between Delete and Truncate in SQL
  • Ans. 

    Delete removes specific rows from a table, while Truncate removes all rows from a table.

    • Delete is a DML command, while Truncate is a DDL command.

    • Delete can be rolled back, while Truncate cannot be rolled back.

    • Delete maintains the table structure and indexes, while Truncate resets the table structure and indexes.

    • Delete triggers delete triggers and delete constraints, while Truncate does not trigger any triggers or const...

  • Answered by AI
  • Q2. Assumptions of regression
  • Ans. 

    Assumptions of regression

    • Linearity: The relationship between the independent and dependent variables is linear.

    • Independence: The residuals are independent of each other.

    • Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

    • Normality: The residuals are normally distributed.

    • No multicollinearity: The independent variables are not highly correlated with each other.

  • Answered by AI

Skills evaluated in this interview

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

I applied via Approached by Company and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

General aptitude test on an online platform with camera and mic monitoring.

Round 2 - One-on-one 

(1 Question)

  • Q1. One on one round with manager and senior manager. Basic questions about day to day responsibilities and tech stack.

Interview Preparation Tips

Topics to prepare for Axtria Senior Associate interview:
  • Pharma forecasting
  • Advanced Excel
  • Tableau
  • Powerpoint
  • powebi
Interview preparation tips for other job seekers - Be clear with the basics that you’re working on and in-depth on the projects that you’re working on.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Ridge and lasso regression difference
  • Ans. 

    Ridge and lasso regression are both regularization techniques used in linear regression to prevent overfitting by adding penalty terms to the cost function.

    • Ridge regression adds a penalty term equivalent to the square of the magnitude of coefficients, while lasso regression adds a penalty term equivalent to the absolute value of the magnitude of coefficients.

    • Ridge regression tends to shrink the coefficients towards zer...

  • Answered by AI
  • Q2. Random forest vs decision tree vs xg boost
  • Ans. 

    Random forest is an ensemble method using multiple decision trees, XGBoost is a gradient boosting algorithm that builds trees sequentially.

    • Random forest is an ensemble learning method that builds multiple decision trees and combines their predictions.

    • Decision tree is a single tree model that makes decisions based on features to predict outcomes.

    • XGBoost is a gradient boosting algorithm that builds trees sequentially, op...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Why do you not want to opt for higher studies
  • Q2. What to do when a team member is not collaborating

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about pharma industry

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jun 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. About IC design
  • Q2. Resume based questions

Interview Questionnaire 

1 Question

  • Q1. Batches,triggers

I applied via Job Fair and was interviewed before Feb 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Code any program in 2 languages
  • Ans. 

    I can code a program in Python and Java.

    • I am proficient in both Python and Java programming languages.

    • I have experience in developing web applications using Python and Java frameworks.

    • I can write efficient and optimized code in both languages.

    • I can develop programs for data analysis, machine learning, and automation using Python.

    • I can develop enterprise-level applications using Java.

    • Examples: Python - a program to scra...

  • Answered by AI
  • Q2. Behavioral questions on why you want to join?

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and answer how much you know
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 Mar 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Related to MDM and IICs And ETL and SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process is good but offer releasing was late
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2023. 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 Resume tips
Round 2 - Aptitude Test 

Simple test with basic questions and reasoning.

Round 3 - Technical 

(2 Questions)

  • Q1. Mostly based on resume and sql questions along with some easy questions related to project .
  • Q2. Snowflake , Python SQL joins ? Tbl A ->1,1,1,null Tbl B ->1,null,1,1 What will be the output for each join and write those outputs.
Round 4 - Technical 

(3 Questions)

  • Q1. Techno Managerial round mostly focused on sql , and database design .
  • Q2. You would be given a scenario for which you would be asked to design a database and based on that design you will be asked few questions.
  • Q3. Snowflake time travel ?
Round 5 - HR 

(1 Question)

  • Q1. Basic hr questions were asked .

Interview Preparation Tips

Interview preparation tips for other job seekers - Highly unprofessional interview experience with Axtria. Before the process started, I made the HR clear on my expectation and the company agreed. I cleared all my rounds and during the rounds every discussion regarding the expectations were same. Thinking I and the company are on the same page, I saw through the end of the interview. However, during the final salary discussion round the HR got back to stating an offer way way below the expected and agreed upon quote, stating the quote as "Generous". Huge waste of time and effort.
Word of Advice: Communicate clearly. Don't waste a candidate time in such a manner.
Definitely not going to work for a company that doesn't values candidate's time and lies throughout the interview process .
Contribute & help others!
anonymous
You can choose to be anonymous

Affine Interview FAQs

How many rounds are there in Affine Associate interview?
Affine interview process usually has 1 rounds. The most common rounds in the Affine interview process are Technical.
How to prepare for Affine Associate 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, Analytics, Python, Analytical and Big Data.
What are the top questions asked in Affine Associate interview?

Some of the top questions asked at the Affine Associate interview -

  1. Joining tables with different jo...read more
  2. Sql is the most important , Focus on Joins ,Sub query and Sql bas...read more

Recently Viewed

INTERVIEWS

Essar Group

30 top interview questions

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Betsol

No Interviews

INTERVIEWS

Affine

No Interviews

DESIGNATION

JOBS

Affine

No Jobs

INTERVIEWS

Arup

No Interviews

SALARIES

Essar Group

LIST OF COMPANIES

Essar Group

Locations

INTERVIEWS

Arup

No Interviews

Tell us how to improve this page.

Affine Associate Interview Process

based on 1 interview

Interview experience

3
  
Average
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
 • 221 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
HCL Infosystems Interview Questions
3.9
 • 140 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Webkul Software Interview Questions
3.8
 • 54 Interviews
View all
Affine Associate Salary
based on 29 salaries
₹6.2 L/yr - ₹9.4 L/yr
13% more than the average Associate Salary in India
View more details

Affine Associate Reviews and Ratings

based on 3 reviews

3.4/5

Rating in categories

4.6

Skill development

3.4

Work-life balance

3.7

Salary

3.4

Job security

3.4

Company culture

3.7

Promotions

4.0

Work satisfaction

Explore 3 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