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 Lead Data Engineer Interview Questions and Answers
Accenture Lead Data Engineer Interview Experiences
1 interview found
(3 Questions)
- Q1. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, while also summing the values in column 'C' ?
- Ans.
Group data by column 'A', calculate mean of column 'B' and sum values in column 'C' for each group.
Use groupby() function in pandas to group data by column 'A'
Apply mean() function on column 'B' and sum() function on column 'C' for each group
Example: df.groupby('A').agg({'B':'mean', 'C':'sum'})
- Q2. Explain the difference deepcopy() and copy() methods in Python's copy module. Provide a scenario where you would use deepcopy() over copy().
- Ans.
deepcopy() creates a new object with completely independent copies of nested objects, while copy() creates a shallow copy.
deepcopy() creates a new object and recursively copies all nested objects, while copy() creates a shallow copy of the top-level object only.
Use deepcopy() when you need to create a deep copy of an object with nested structures, to avoid any references to the original object.
Use copy() when you only ...
- Q3. Discuss the concept of Python decorators and provide an example of how you would use decorators to measure the execution time of a function.
- Ans.
Python decorators are functions that modify the behavior of other functions. They are commonly used for adding functionality to existing functions without modifying their code.
Decorators are defined using the @ symbol followed by the decorator function name.
They can be used to measure the execution time of a function by wrapping the function with a timer decorator.
Example: def timer(func): def wrapper(*args, **kwargs...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(3 Questions)
- Q1. SQL Question on window functions to find the highest sale amount per day of the stores
- Q2. Build an ETL Pipeline to read json files which are dropping at irregular times into storage. So how do you transform and match the schema etc.,
- Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does?
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Questions related to the current and past projects.
- Q2. Aws related questions.
- Q3. Data warehousing basics
(2 Questions)
- Q1. Explain about the roles and responsibilities.
- Q2. Discussion about the role in Genpact.
(2 Questions)
- Q1. Asked about expectated salary
- Q2. Why are you switching
Interview Preparation Tips
(2 Questions)
- Q1. Dataguard architecture
- Q2. Rman backup and restoration
(1 Question)
- Q1. Why you join inm
- Ans.
I joined inm because of the company's reputation for innovation and growth in the tech industry.
Attracted to company's reputation for innovation
Excited about opportunities for growth in tech industry
Impressed by company culture and values
Piyusha Mohanty
Selected
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Data Modeling Concepts, SQL Query
- Q2. Data Governance, Data Lineage, ETL process,
SQL Scripts to write and also also asked to design an data model of my choice in Telecom Domain
Selected
(2 Questions)
- Q1. What is database architecture?
- Ans.
Database architecture refers to the design and structure of a database system.
Database architecture includes the organization of data, storage, retrieval, and security mechanisms.
It involves defining the relationships between data elements and how they are stored and accessed.
Examples of database architectures include hierarchical, network, relational, and object-oriented.
Database architecture also includes the choice ...
- Q2. Difference between delete and truncate
- Ans.
Delete removes rows one by one, while truncate removes all rows at once.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Example: DELETE FROM table_name WHERE condi
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Data stage scenario
- Q2. Difference between Data Stage and informatica
- Ans.
Data Stage is an ETL tool by IBM, while Informatica is a popular ETL tool by Informatica Corporation.
Data Stage is developed by IBM, while Informatica is developed by Informatica Corporation.
Data Stage is known for its parallel processing capabilities, while Informatica is known for its ease of use and flexibility.
Data Stage has a graphical interface for designing jobs, while Informatica uses a more traditional workflo...
Interview Preparation Tips
- Complete Data Stage
Skills evaluated in this interview
Oracle Database Administrator Interview Questions & Answers
DXC Technology
Anonymous
posted on 9 Sep 2024
(1 Question)
- Q1. Tell about yourself
- Ans.
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
5+ years of experience as an Oracle DBA
Proficient in database management, performance optimization, and data security
Skilled in troubleshooting and resolving database issues
Strong knowledge of Oracle database architecture and SQL
Certified Oracle Database Administrator (OCA/OCP)
Oracle Database Administrator Interview Questions & Answers
Cognizant
sagar hegde
posted on 2 Apr 2024
(1 Question)
- Q1. About oracle database functionality
(1 Question)
- Q1. Salary discussion
Accenture Interview FAQs
Some of the top questions asked at the Accenture Lead Data Engineer interview -
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
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Data Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Datastage Developer Interview Questions
- Database Architect Interview Questions
- Show more
Accenture Lead Data Engineer Interview Process
based on 4 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Accenture Lead Data Engineer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Application Development Analyst
38.9k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
27k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
|
Team Lead
24.2k
salaries
| ₹7.1 L/yr - ₹25.5 L/yr |
|
Senior Software Engineer
18.3k
salaries
| ₹6 L/yr - ₹19.5 L/yr |
|
Software Engineer
17.5k
salaries
| ₹3.6 L/yr - ₹13.4 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions >
- Accenture Lead Data Engineer Interview Questions
