Get AmbitionBox App
Faster and better experience!
AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Affine
Work with us 
Compare
Filter interviews by
Affine Interview Questions and Answers
23 Interview questions
Optimize ETL processes and Spark jobs through efficient design, resource management, and performance tuning.
Use partitioning to improve data processing speed. For example, partitioning large datasets by date can speed up queries.
Implement data caching in Spark to store intermediate results, reducing the need for repeated computations.
Optimize data formats by using columnar storage formats like Parquet or ORC, whic...
Linear programming optimizes a linear objective function subject to linear constraints, finding the best outcome in a feasible region.
Linear programming involves maximizing or minimizing a linear objective function.
Constraints are linear inequalities that define the feasible region.
The feasible region is typically a convex polygon in multi-dimensional space.
The Simplex method is a popular algorithm used to solve l...
ML metrics help evaluate model performance, each with trade-offs affecting accuracy, interpretability, and application.
Accuracy vs. Precision: High accuracy may come with low precision in imbalanced datasets. Example: Classifying rare diseases.
Recall vs. F1 Score: High recall may lower F1 score, impacting balance in precision and recall. Example: Fraud detection.
ROC-AUC vs. PR-AUC: ROC-AUC is sensitive to class im...
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
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.
R-squared value is a statistical measure that represents the proportion of the variance in the dependent variable that is predictable from the independent variable(s).
R-squared value ranges from 0 to 1, with 1 indicating a perfect fit.
It is used to evaluate the goodness of fit of a regression model.
A higher R-squared value indicates that the model explains a larger proportion of the variance in the dependent varia...
Accounting in Tally involves recording financial transactions, generating reports, and managing accounts.
Recording financial transactions such as sales, purchases, payments, and receipts
Generating financial statements like balance sheet, profit and loss statement
Managing accounts receivable and accounts payable
Creating and maintaining ledgers for different accounts
Reconciling bank statements with Tally entries
Gene...
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.
...
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 effec...
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 eng...
Affine Interview Experiences
51 interviews found
Anonymous
I appeared for an interview in Apr 2025, where I was asked the following questions.
- Q1. Questions from SQL(40 Mins), Power BI (25 Mins) and Excel(15 Mins)
- Q2. Joins Number of records in inner outer left right joins, SQL Query and foundational questions, DAX Writing for Running total sales
Interview Preparation Tips
Power BI Developer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(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.
- 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
Data Engineer Interview Questions asked at other Companies
Selected
I appeared for an interview in Sep 2024.
A coding test was administered to address several machine learning problem statements.
(2 Questions)
- Q1. Mention some metric in ML and explain the tradeoffs between them
- Ans.
ML metrics help evaluate model performance, each with trade-offs affecting accuracy, interpretability, and application.
Accuracy vs. Precision: High accuracy may come with low precision in imbalanced datasets. Example: Classifying rare diseases.
Recall vs. F1 Score: High recall may lower F1 score, impacting balance in precision and recall. Example: Fraud detection.
ROC-AUC vs. PR-AUC: ROC-AUC is sensitive to class imbalan...
- Q2. How does the xgboost algorithm works , with explanation on every steps
- Ans.
XGBoost is an efficient implementation of gradient boosting that optimizes performance and accuracy through ensemble learning.
1. **Gradient Boosting Framework**: XGBoost builds models in a sequential manner, where each new model corrects errors made by the previous ones.
2. **Decision Trees**: It primarily uses decision trees as base learners, where each tree is built to minimize the loss function.
3. **Regularization**:...
(4 Questions)
- Q1. Write a program to reverse an array of integers and strings?
- Ans.
This program reverses an array containing both integers and strings.
Use a loop to iterate through the array from the last index to the first.
Create a new array to store the reversed elements.
Example: For input ['apple', 1, 'banana', 2], output should be [2, 'banana', 1, 'apple'].
- Q2. Write a program to count the maximum repetitive integer among one array?
- Ans.
This program counts the most frequently occurring integer in an array, identifying the maximum repetitive integer efficiently.
Use a dictionary to store the count of each integer in the array. For example, for the array [1, 2, 2, 3], the counts would be {1: 1, 2: 2, 3: 1}.
Iterate through the array and update the count in the dictionary for each integer encountered.
After counting, find the integer with the maximum count....
- Q3. Project discussion and why use specific algorithm
- Q4. How does linear programming algorithm works ?
- Ans.
Linear programming optimizes a linear objective function subject to linear constraints, finding the best outcome in a feasible region.
Linear programming involves maximizing or minimizing a linear objective function.
Constraints are linear inequalities that define the feasible region.
The feasible region is typically a convex polygon in multi-dimensional space.
The Simplex method is a popular algorithm used to solve linear...
Senior Data Scientist Associate Interview Questions asked at other Companies
(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 ...
- 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
Skills evaluated in this interview
Data Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(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
- 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...
- 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
Interview Preparation Tips
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
Shruti Yadav
(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
- 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
Power BI Developer Interview Questions asked at other Companies
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
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.
(1 Question)
- Q1. Simple questions on SQL were asked.
(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...
- 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 ...
- 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...
- 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 ...
- 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...
Interview Preparation Tips
- SQL
- Power Bi
- Tableau
- Excel
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
do achieve
(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...
Skills evaluated in this interview
Data Engineer Interview Questions asked at other Companies
(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
Selected
I applied via Company Website and was interviewed in Mar 2024. There were 3 interview rounds.
(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.
(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...
(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.
Interview Preparation Tips
- SQL
- Python
- ETL
- Datawareshouse
- Cloud
Skills evaluated in this interview
Top trending discussions
Affine Interview FAQs
Some of the top questions asked at the Affine interview -
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 Interviews By Designations
- Affine Data Analyst Interview Questions
- Affine Business Analyst Interview Questions
- Affine Data Scientist Interview Questions
- Affine Senior Associate Interview Questions
- Affine Data Engineer Interview Questions
- Affine Consultant Interview Questions
- Affine Senior Data Scientist Interview Questions
- Affine Power BI Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Business Analyst Interview Questions
- Data Scientist Interview Questions
- Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Accountant Interview Questions
- System Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 41 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Affine Reviews and Ratings
based on 177 reviews
Rating in categories
|
Senior Associate
136
salaries
|  ₹7.7 L/yr - ₹20 L/yr |
|
Business Analyst
96
salaries
| ₹5 L/yr - ₹12.6 L/yr |
|
Senior Business Analyst
87
salaries
| ₹8 L/yr - ₹18 L/yr |
|
Consultant
85
salaries
| ₹12 L/yr - ₹31.4 L/yr |
|
Data Engineer
48
salaries
| ₹6 L/yr - ₹15 L/yr |
HCL Infosystems
Softenger
Capital Numbers Infotech
Accel Frontline
- Home >
- Interviews >
- Affine Interview Questions
