Upload Button Icon Add office photos
Engaged Employer

i

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

Exponentia.ai Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Exponentia.ai ETL Talend Developer Interview Questions and Answers

Updated 14 Sep 2024

Exponentia.ai ETL Talend Developer Interview Experiences

1 interview found

ETL Talend Developer Interview Questions & Answers

user image Pintu Prajapati

posted on 14 Sep 2024

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

(2 Questions)

  • Q1. On which Talend version u are working ?
  • Ans. 

    I am currently working on Talend version 7.3.1.

    • Working on Talend version 7.3.1

    • Familiar with the features and updates in this version

    • Experience in developing ETL processes using this version

  • Answered by AI
  • Q2. How to do parallel processing in Talend with examples?
  • Ans. 

    Parallel processing in Talend allows for executing multiple tasks simultaneously, improving performance.

    • Use tParallelize component to run subjobs in parallel

    • Enable parallel execution in job settings

    • Utilize tFlowToIterate to process data in parallel

    • Implement parallel processing for large data sets to optimize performance

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed before Aug 2023. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL query on joins, window function, remove duplicates, 2nd highest rank
  • Q2. Azure Data Factory, ETL questions
Round 2 - Technical 

(2 Questions)

  • Q1. SQL, python technical questions
  • Q2. Managerial questions
Round 3 - HR 

(2 Questions)

  • Q1. Strength and weakness
  • Q2. Typical hr questions
Round 4 - Aptitude Test 

Quantitative Analysis, Data Interpretation, Logical Reasoning

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
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Sql questions and python
Round 2 - Behavioral 

(1 Question)

  • Q1. About last projects
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. The HR representative will seek to understand your experience and its alignment with the role.
  • Q2. Salary expectations, Offers in hand
Round 2 - Technical 

(3 Questions)

  • Q1. What are the key features and functionalities of Snowflake?
  • Ans. 

    Snowflake is a cloud-based data warehousing platform known for its scalability, performance, and ease of use.

    • Snowflake uses a unique architecture called multi-cluster, which separates storage and compute resources for better scalability and performance.

    • It supports both structured and semi-structured data, allowing users to work with various data types.

    • Snowflake offers features like automatic scaling, data sharing, and ...

  • Answered by AI
  • Q2. The interviewer asked several complex SQL questions that utilized analytical functions.
  • Q3. I was asked to write some syntax-level code for Jinja statements in dbt.
Round 3 - Technical 

(2 Questions)

  • Q1. The interviewer, who was part of the senior management, inquired about dbt, its features, and my experience with dbt thus far.
  • Q2. The interviewer reviewed my resume and inquired about the challenges I encountered in my previous roles and the methods I used to resolve them.
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiations, Bonus discussions

Interview Preparation Tips

Topics to prepare for Fractal Analytics Data Engineer interview:
  • dbt
  • Snowflake
  • AWS
  • Python
  • PySpark
  • SQL
  • Data Modelling
  • Data Quality
  • Airflow
Interview preparation tips for other job seekers - Stick to the basics while also addressing some complex topics relevant to your role and job expectations. Be honest about what you know and what you don't. Always approach discussions diplomatically regarding what is valuable to you.
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
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - Coding Test 

Basic Pyspark/python question with some mcqs

Round 2 - Technical 

(2 Questions)

  • Q1. Project overview
  • Q2. Pyspark, python , sql related questions.
Round 3 - Technical 

(2 Questions)

  • Q1. Basic technical question on spark and one python Dasa question and one sql
  • Q2. Sql + python + spark + Adf + Databricks
Round 4 - HR 

(2 Questions)

  • Q1. Why you want to join even though you have offers from good mnc
  • Ans. 

    I am passionate about data engineering and believe this company offers unique opportunities for growth and learning.

    • Exciting projects and challenges at this company

    • Opportunities for growth and learning in data engineering

    • Alignment with company values and culture

    • Potential for career advancement and development

    • Interest in the industry or specific technologies used by the company

  • Answered by AI
  • Q2. Salary expectations and work culture
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Walk-in

Round 1 - Aptitude Test 

A general round having mix of maths,aptitude,english,puzzle and quiz. level was easy

Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell about yourself
  • Q2. What step would you take in this situatiion
  • Ans. 

    I would analyze the situation, identify the root cause, and propose a solution based on data-driven insights.

    • Analyze the data to understand the problem

    • Identify the root cause of the issue

    • Propose a solution based on data-driven insights

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Basic sql online assessment with some queries and mcq

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain project
  • Ans. 

    Developed a data pipeline to ingest, process, and analyze customer behavior data for targeted marketing campaigns.

    • Designed and implemented ETL processes to extract data from various sources

    • Utilized Apache Spark for data processing and analysis

    • Built machine learning models to predict customer behavior

    • Collaborated with marketing team to optimize campaign strategies

  • Answered by AI
  • Q2. Pipeline optimization
Round 3 - One-on-one 

(1 Question)

  • Q1. Behavioral question

I applied via LinkedIn and was interviewed in Aug 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. A program was given and asked to identify the number of stages.
  • Q2. In a word count spark program which command will run on driver and which will run on executor
  • Ans. 

    Commands that run on driver and executor in a word count Spark program.

    • The command to read the input file and create RDD will run on driver.

    • The command to split the lines and count the words will run on executor.

    • The command to aggregate the word counts and write the output will run on driver.

    • Driver sends tasks to executors and coordinates the overall job.

    • Executor processes the tasks assigned by the driver.

  • Answered by AI
  • Q3. SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the spark architecture and sql

Skills evaluated in this interview

Exponentia.ai Interview FAQs

How many rounds are there in Exponentia.ai ETL Talend Developer interview?
Exponentia.ai interview process usually has 1 rounds. The most common rounds in the Exponentia.ai interview process are Technical.
What are the top questions asked in Exponentia.ai ETL Talend Developer interview?

Some of the top questions asked at the Exponentia.ai ETL Talend Developer interview -

  1. How to do parallel processing in Talend with exampl...read more
  2. On which Talend version u are workin...read more

Tell us how to improve this page.

Exponentia.ai ETL Talend Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Fractal Analytics Interview Questions
4.0
 • 207 Interviews
Zeta Interview Questions
3.4
 • 70 Interviews
embedUR Systems Interview Questions
3.2
 • 48 Interviews
Subex Interview Questions
3.5
 • 35 Interviews
CoinDCX Interview Questions
3.7
 • 29 Interviews
Seclore Interview Questions
4.1
 • 26 Interviews
MoEngage Interview Questions
4.0
 • 26 Interviews
View all
Data Engineer
42 salaries
unlock blur

₹5 L/yr - ₹14.8 L/yr

Senior Associate
31 salaries
unlock blur

₹5.5 L/yr - ₹12.5 L/yr

Business Intelligence Engineer
23 salaries
unlock blur

₹7.5 L/yr - ₹15 L/yr

Data Scientist
22 salaries
unlock blur

₹6.5 L/yr - ₹17 L/yr

Software Engineer
21 salaries
unlock blur

₹4.3 L/yr - ₹14.5 L/yr

Explore more salaries
Compare Exponentia.ai with

Fractal Analytics

4.0
Compare

Subex

3.5
Compare

Innovatiview India Ltd

3.9
Compare

Watchyourhealth.com

4.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview