Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
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'})
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 ...
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...
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.
Various data warehousing techniques include dimensional modeling, star schema, snowflake schema, and data vault.
Dimensional modeling involves organizing data into facts and dimensions to facilitate easy querying and analysis.
Star schema is a type of dimensional modeling where a central fact table is connected to multiple dimension tables.
Snowflake schema is an extension of star schema where dimension tables are normali...
My analytics work has helped the organization make data-driven decisions, improve operational efficiency, and identify new opportunities for growth.
Developed data models and algorithms to optimize business processes
Generated insights from large datasets to drive strategic decision-making
Identified trends and patterns to improve customer experience and retention
Implemented data governance policies to ensure data quality
I would respond in various situations by remaining calm, assessing the situation, and providing a thoughtful and strategic solution.
Remain calm and composed
Assess the situation thoroughly
Provide a thoughtful and strategic solution
Communicate effectively with all parties involved
Both career and team are important, but ultimately career growth should be prioritized.
Career growth is essential for personal development and achieving professional goals.
A strong team can support career growth by providing mentorship, collaboration, and opportunities for learning.
Balancing career and team dynamics is key to long-term success in any role.
I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
I have used HUDI and Iceberg in my previous project for managing large-scale data lakes efficiently.
Implemented HUDI for incremental data ingestion and managing large datasets in real-time
Utilized Iceberg for efficient table management and data versioning
Integrated HUDI and Iceberg with Apache Spark for processing and querying data
posted on 28 Oct 2024
DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.
DBA is responsible for installing, configuring, and upgrading database software.
They monitor database performance and troubleshoot issues.
DBA designs and implements backup and recovery strategies to prevent data loss.
They also manage user access and security permissions within...
Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.
Regularly monitor database performance and usage
Perform routine maintenance tasks such as applying patches and updates
Take regular backups to ensure data integrity and disaster recovery
Implement security measures to protect the database from unauthorized access
Optimize database performanc
Join is used to combine rows from two or more tables based on a related column, while lookup is used to retrieve data from a reference table based on a matching key.
Join combines rows from multiple tables based on a related column
Lookup retrieves data from a reference table based on a matching key
Join can result in duplicate rows if there are multiple matches, while lookup returns only the first matching row
Join is use...
Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.
Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)
Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)
Fact table is typically normalized, while dimension table is denormalized for faster queries
Fact table is usually larger in s
Use sed command to display the line before a specific pattern
Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern
Replace 'pattern' with the specific pattern you are looking for
This command will display the line before the pattern in the file
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 2 interview rounds.
SQL Scripts to write and also also asked to design an data model of my choice in Telecom Domain
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 ...
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
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
Some of the top questions asked at the Accenture Lead Data Engineer interview -
based on 4 interviews
Interview experience
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 - ₹17.5 L/yr |
Team Lead
24.3k
salaries
| ₹7.1 L/yr - ₹25.6 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹19.5 L/yr |
Software Engineer
17.4k
salaries
| ₹3.6 L/yr - ₹13.4 L/yr |
TCS
Cognizant
Capgemini
Infosys