Upload Button Icon Add office photos

Accenture

Compare button icon Compare button icon Compare

Filter interviews by

Accenture ETL Talend Developer Interview Questions and Answers

Updated 23 Jul 2024

Accenture ETL Talend Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Filter source data based on department id (assuming 1000+ departments are there) and store in unique files.
  • Ans. 

    Filter source data by department id and store in unique files

    • Use Talend components like tFilterRow to filter data based on department id

    • Create a unique file for each department using tFileOutputDelimited component

    • Loop through all department ids to process data for each department

  • Answered by AI
  • Q2. Various ways to optimize an SQL Query to improve query performance.
  • Ans. 

    Optimizing SQL queries can improve query performance by using indexes, avoiding unnecessary joins, and optimizing the query structure.

    • Use indexes on columns frequently used in WHERE clauses

    • Avoid using SELECT * and only retrieve necessary columns

    • Optimize joins by using INNER JOIN instead of OUTER JOIN when possible

    • Use WHERE clause to filter data early in the query

    • Avoid using functions in WHERE clauses as they can preven...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Mar 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was placed through campus . Did not have to give the appitude / online exam as I was among top 10 students from the college . In the interview panel ,we had 3 people .one manager and two technical / staf...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer all. If something is out of your scope and you don't know ,politely tell them you don't know . Keep yourself engaged with the panel . In between talk to them , just do not give long pause and stares . It make things akward . Hope it helps

ETL Talend Developer Interview Questions Asked at Other Companies

asked in Infosys BPM
Q1. What is scd type 2 and incremental load
Q2. How do you implement parallel processing in Talend? Please provid ... read more
asked in Accenture
Q3. How would you filter source data based on department ID (assuming ... read more
asked in RNTBCIL
Q4. Tools and technologies used for solving the problem
asked in Infosys BPM
Q5. What is the latest version of Talend?

I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. C++ basic
  • Q2. Hh
  • Q3. Yy

Interview Preparation Tips

Interview preparation tips for other job seekers - Hh

Interview Questionnaire 

3 Questions

  • Q1. Process builder. 2.types of relationships. 3.difference in user ,profile and role. 4.workflow. 5.Admin questions
  • Ans. 

    Answering questions related to software development and Salesforce administration.

    • Process Builder is a visual tool in Salesforce used to automate business processes.

    • Types of relationships in Salesforce include lookup, master-detail, and many-to-many relationships.

    • User represents an individual who can log in and access Salesforce, Profile defines the permissions and settings for a user, and Role determines the hierarchy...

  • Answered by AI
  • Q2. What configuration i have done.
  • Ans. 

    I have configured various software systems and tools for development purposes.

    • Configured IDEs such as Eclipse and Visual Studio for development

    • Set up version control systems like Git and SVN

    • Installed and configured build tools like Maven and Gradle

    • Configured application servers like Tomcat and JBoss

    • Set up databases like MySQL and Oracle for development and testing

  • Answered by AI
  • Q3. Salary negotiations

Interview Preparation Tips

Round: Manager round
Experience: Configuration and what work ee have done in your previous company.

Skills evaluated in this interview

What people are saying about Accenture

View All
a cyber security analyst
5d
Disappointed with the Candidate Experience at Accenture
I recently interviewed at Accenture for a Security Architect role. I cleared two rounds of technical interviews and was later told by the HR (verbally) that I was selected and that my offer letter would be released soon. Based on that confirmation, I submitted all required documents and waited patiently for nearly a month. Despite following up multiple times, there was no proper communication or update. My application status remained “Active” on the portal the entire time. Eventually, I received a rejection email with no explanation, feedback, or context, despite being verbally told that I was selected. it’s disappointing when a candidate is given verbal assurance and kept waiting without clarity. I expected more transparent from a company of Accenture’s reputation. If anyone from Accenture here could help me understand what might have happened or possibly refer me for any similar openings in the Security Architect / Data Encryption/ key management, I’d be genuinely grateful.
Got a question about Accenture?
Ask anonymously on communities.

Interview Questionnaire 

2 Questions

  • Q1. What type of challenges excite you professionally
  • Ans. 

    I thrive on challenges that push my technical skills and creativity, especially in problem-solving and innovative project development.

    • Complex problem-solving: I enjoy tackling intricate algorithms, like optimizing search functions in large datasets.

    • Innovative projects: Working on projects that require new technologies, such as developing a mobile app using AI for personalized user experiences.

    • Collaboration: I find exci...

  • Answered by AI
  • Q2. Many challenges I would like to excited professionally that is always I want to choose difficult path.

Interview Questionnaire 

1 Question

  • Q1. How to confidence and Communication skill

Accenture HR Interview Questions

1.3k questions and answers

Q. Can you explain your past experiences and how you can contribute to the org ... read more
Q. Which company conducted your interview?
Q. Where do you envision yourself in the next three years?

Interview Questionnaire 

1 Question

  • Q1. How r u
Are these interview questions helpful?

Interview Questionnaire 

1 Question

  • Q1. Explain defect life cycle

Skills evaluated in this interview

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

Round 1 - Aptitude Test 

Duration was 30 mins, I have followed shakuntaladevi , and apptitude test books, This test was not too hard, You can creak easy if you practice .

Round 2 - Group Discussion 

Group discussion topic was Education in English and Education in Mother tonge Tamil.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and you will get it. Be confident.

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Waterfall model, Software development life cycle
  • Q2. How do you arrive at factorial without recursive function
  • Ans. 

    Factorial can be calculated using a loop by multiplying numbers from 1 to n.

    • Initialize a variable to 1

    • Use a loop to multiply the variable with numbers from 1 to n

    • Return the variable

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your fundamental skills

Accenture Interview FAQs

How many rounds are there in Accenture ETL Talend Developer interview?
Accenture interview process usually has 1 rounds. The most common rounds in the Accenture interview process are One-on-one Round.
What are the top questions asked in Accenture ETL Talend Developer interview?

Some of the top questions asked at the Accenture ETL Talend Developer interview -

  1. Filter source data based on department id (assuming 1000+ departments are there...read more
  2. Various ways to optimize an SQL Query to improve query performan...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4/5

based on 1 interview experience

Accenture ETL Talend Developer Salary
based on 39 salaries
₹3.6 L/yr - ₹8.6 L/yr
5% less than the average ETL Talend Developer Salary in India
View more details

Accenture ETL Talend Developer Reviews and Ratings

based on 5 reviews

4.0/5

Rating in categories

3.6

Skill development

2.3

Work-life balance

3.6

Salary

3.7

Job security

4.4

Company culture

2.4

Promotions

3.5

Work satisfaction

Explore 5 Reviews and Ratings
Application Development Analyst
39.3k salaries
unlock blur

₹4.8 L/yr - ₹11 L/yr

Application Development - Senior Analyst
27.7k salaries
unlock blur

₹8.2 L/yr - ₹16.1 L/yr

Team Lead
27.1k salaries
unlock blur

₹12.7 L/yr - ₹22.6 L/yr

Senior Analyst
20.2k salaries
unlock blur

₹9.1 L/yr - ₹15.7 L/yr

Senior Software Engineer
18.6k salaries
unlock blur

₹10.5 L/yr - ₹18.3 L/yr

Explore more salaries
Compare Accenture with

TCS

3.5
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Infosys

3.6
Compare
write
Share an Interview