AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Accenture
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Accenture ETL Developer Interview Questions and Answers
Accenture ETL Developer Interview Experiences
2 interviews found
Anonymous
(2 Questions)
- Q1. Informatica powercenter architecture, scd1, scd2 etc
- Q2. Lookups and where to use them
- Ans.
Lookups are used to retrieve related data from another table based on a common key.
Lookups are used in ETL processes to enrich data by adding additional information from a reference table.
They are commonly used to replace codes with corresponding descriptions, such as replacing product IDs with product names.
Lookups can be performed using SQL joins or lookup transformations in ETL tools like Informatica or Talend.
Skills evaluated in this interview
Interview Questionnaire
4 Questions
- Q1. Whats is mapping
- Ans.
Mapping is the process of defining the relationship between source and target data in ETL.
Mapping involves identifying the source and target data structures.
It also involves defining the transformation rules to be applied to the source data.
Mappings can be simple or complex depending on the complexity of the data.
Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target
- Q2. What is sesson
- Ans.
Session refers to a period of time during which a user interacts with a computer system or application.
A session is created when a user logs into a system or application.
It is used to track user activity and maintain user-specific data.
Sessions can be terminated manually or automatically after a certain period of inactivity.
Session management is important for security purposes.
Examples of session management techniques
- Q3. Which role u did
- Q4. Oracle sqi pl sqi
Interview questions from similar companies
I appeared for an interview in Jun 2024.
(2 Questions)
- Q1. Rank and dense rank
- Q2. Scenario based etl question
I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.
(2 Questions)
- Q1. Question on logic SCD types
- Q2. Dynamic lookup along with lookup
Interview Preparation Tips
(1 Question)
- Q1. About the ETL Process
(1 Question)
- Q1. What are your salary expectations?
Interview Preparation Tips
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(1 Question)
- Q1. Which version of talend you are using
- Ans.
I am using Talend version 7.3.1 for ETL development.
I am currently using Talend version 7.3.1 for ETL development.
The specific version of Talend being used is 7.3.1.
Talend 7.3.1 offers various features and improvements for ETL processes.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Apr 2023. There was 1 interview round.
(1 Question)
- Q1. SQL query and informatica scenario based questions
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.
(1 Question)
- Q1. Introduction, projects worked, technology stack, scenario based questions, challenges
(1 Question)
- Q1. Salary negotiation and general discussion
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.
(1 Question)
- Q1. General, project overview, technology stack, scenario based questions, challenges and experiences
(1 Question)
- Q1. General, salary negotiation
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
(1 Question)
- Q1. Oracle DWH concept Informatica
Interview Preparation Tips
get a job you don't try
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
- Informatica ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- Database Developer Interview Questions
- Informatica Developer Interview Questions
- SQL Server Developer Interview Questions
- ETL Lead Interview Questions
- Datastage Developer Interview Questions
- Software Developer Interview Questions
- Show more
Accenture ETL Developer Interview Process
based on 2 interviews
Interview experience
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
Accenture ETL Developer Reviews and Ratings
based on 20 reviews
Rating in categories
|
Application Development Analyst
38.9k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
27.4k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
|
Team Lead
24.6k
salaries
| ₹7.1 L/yr - ₹26 L/yr |
|
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹20 L/yr |
|
Senior Analyst
17.7k
salaries
| ₹5.5 L/yr - ₹21.3 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions >
- Accenture ETL Developer Interview Questions
