AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Accenture ETL Talend Developer Interview Questions and Answers
Accenture ETL Talend Developer Interview Experiences
1 interview found
Anonymous
(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
- 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...
Skills evaluated in this interview
Interview questions from similar companies
I applied via Company Website and was interviewed before Jun 2020. There were 7 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Project planning
- Q2. Achievements
- Q3. Coding questions
- Q4. Many more other
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
(1 Question)
- Q1. Basic question from C++.Some questions from Data structure and computer architecture.
Interview Preparation Tips
- C++
I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.
First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.
(1 Question)
- Q1. 2nd round included tr and mr round went quite enegritic
Interview Preparation Tips
What people are saying about Accenture
I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Related to final year project and basic programming.
Interview Preparation Tips
The first round was basic aptitude and essay writing the level of difficulty is average and this is also elimination round.
The second was pseudo coding round It has mcq based programing question like arrays, looping and some data structure question.
Depending on the score in coding round they split us into two groups infra and non infra. Infra for cloud and infrastructure related roles and non-infra for programming related role.
The third round was technical Hr. The level of the interview is average he asked basic questions in c and java like inheritance, Polymorphism, encapsulates etc.. and some final project related questions.
The last round was General Hr. He is very friendly and ask about some basic hr question. More importantly know something about the company before getting into this round.
I cleared the interview and got my LOI after 2 months.
Capgemini follows the pre joining course for fresher as ADAPT. It's very useful those are from non IT background.
Clearing ADAPT is not mandatory but you need to participate.
Due to pandemic I got the offer letter on Feb 2021 and now I have completed my training and looking for project.
I applied via LinkedIn and was interviewed before Jul 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Which technologies your interested to work
- Q2. Question related to Java coding
- Q3. Question from C language
- Q4. Question from AI & ML
Interview Preparation Tips
Trisha Kundu
I applied via Campus Placement and was interviewed in Apr 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Are you willing to relocate?
- Ans.
Yes, I am open to relocating for the right opportunity that aligns with my career goals and personal growth.
Relocation can provide exposure to new technologies and methodologies.
I am excited about the prospect of working in diverse teams and cultures.
For example, moving to a tech hub like San Francisco could enhance my career.
I understand the challenges of relocating, but I see them as opportunities for growth.
- Q2. Why should I hire you?
- Ans.
I bring a unique blend of skills, experience, and passion for software development that aligns perfectly with your team's goals.
Proven experience in developing scalable applications, such as a recent project where I improved performance by 30%.
Strong problem-solving skills demonstrated through my contributions to open-source projects, enhancing functionality and fixing bugs.
Excellent teamwork and communication abilitie...
Interview Preparation Tips
I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about your experience
Interview Preparation Tips
I applied via Amcat and was interviewed before Jul 2021. There were 2 interview rounds.
Refer R S Agarwal book for apptitude
(1 Question)
- Q1. Write a c program on fractional numbers
- Ans.
A C program to perform arithmetic operations on fractional numbers.
Use float or double data type to store fractional numbers.
Use scanf() to take input from the user.
Perform arithmetic operations like addition, subtraction, multiplication, and division.
Use printf() to display the result.
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Tell me about software system
Accenture Interview FAQs
Tell us how to improve this page.
Accenture Interviews By Designations
- Accenture Associate Software Engineer Interview Questions
- Accenture Application Developer Interview Questions
- Accenture Application Development Analyst Interview Questions
- Accenture Software Developer Interview Questions
- Accenture Software Engineer Interview Questions
- Accenture Analyst Interview Questions
- Accenture Application Development Associate Interview Questions
- Accenture Senior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Software Engineer Interview Questions
- System Engineer Interview Questions
- Data Engineer Interview Questions
- Developer Interview Questions
- Azure Data Engineer Interview Questions
- ETL Developer Interview Questions
- Informatica Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
Accenture ETL Talend Developer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Application Development Analyst
39.3k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
27.7k
salaries
| ₹7 L/yr - ₹20.5 L/yr |
|
Team Lead
26.3k
salaries
| ₹7.2 L/yr - ₹26.7 L/yr |
|
Senior Analyst
19.2k
salaries
| ₹5.6 L/yr - ₹21.3 L/yr |
|
Senior Software Engineer
18.5k
salaries
| ₹6.1 L/yr - ₹21 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions
