Accenture Data Engineer Interview Questions, Process, and Tips

2 Hackerrank problems

Q1. Technical interview
Add your answer
Q2. Mostly on project and programming basics
Add your answer

Q1. Behavioral round
Add your answer

Q1. Brief about Hadoop and kafka
Ans. 
Hadoop is a distributed storage and processing system for big data, while Kafka is a distributed streaming platform.
• Hadoop is used for storing and processing large volumes of data across clusters of computers.

• Kafka is used for building real-time data pipelines and streaming applications.

• Hadoop uses HDFS (Hadoop Distributed File System) for storage, while Kafka uses topics to publish and subscribe to streams of data.

• Had...read more
Answered by AI
Add your answer
Q2. Streaming tools for big data
Ans. 
Streaming tools for big data are essential for real-time processing and analysis of large datasets.
• Apache Kafka is a popular streaming tool for handling real-time data streams.

• Apache Spark Streaming is another tool that enables real-time processing of big data.

• Amazon Kinesis is a managed service for real-time data streaming on AWS.
Answered by AI
Add your answer
Q3. Question on spark
Add your answer
Q4. Working of spark framework
Ans. 
Spark framework is a distributed computing system that provides in-memory processing capabilities for big data analytics.
• Spark framework is built on top of the Hadoop Distributed File System (HDFS) for storage and Apache Mesos or Hadoop YARN for resource management.

• It supports multiple programming languages such as Scala, Java, Python, and R.

• Spark provides high-level APIs like Spark SQL for structured data processing, ...read more
Answered by AI
Add your answer
Q5. Cloud basic questions
Add your answer

Q1. Why would you like to join us?
Add your answer

Q1. Questions about previous work experience and responsibilities
Add your answer

Multiple choice questions related to your primary skills..

Q1. Technical Round ... where they will ask some questions related to your skills.. and they can ask to write some code as well with respect to Spark, Python, Java and might be SQL query as well. Abd have know...read more
Add your answer
Q2. What is difference between hadoop and spark? Difference between coalesce and repartition? Sql query HDFS
Ans. 
Hadoop is a distributed storage and processing framework, while Spark is a fast and general-purpose cluster computing system.
• Hadoop is primarily used for batch processing of large datasets, while Spark is known for its in-memory processing capabilities.

• Hadoop uses MapReduce for processing data, while Spark uses Resilient Distributed Datasets (RDDs).

• Coalesce is used to reduce the number of partitions in a DataFrame or R...read more
Answered by AI
Add your answer

Q1. Why do you want to change your job? What do you know about Accenture?
Add your answer

Q1. What to import data from RDMS via sqoop without primary key
Ans. 
Use --split-by option in sqoop to import data from RDMS without primary key
• Use --split-by option to specify a column to split the import into multiple mappers

• Use --boundary-query option to specify a query to determine the range of values for --split-by column

• Example: sqoop import --connect jdbc:mysql://localhost/mydb --username root --password password --table mytable --split-by id

• Example: sqoop import --connect jdbc:m...read more
Answered by AI
Add your answer

Aptitude test was medium

Q1. Containers in ssis
Ans. 
Containers in SSIS are used to group and organize tasks and workflows.
• Containers provide a way to group related tasks together.

• They help in organizing and managing complex workflows.

• There are different types of containers in SSIS, such as Sequence Container, For Loop Container, and Foreach Loop Container.

• Containers can be nested within each other to create hierarchical structures.

• They allow for better control flow and
Answered by AI
Add your answer

Q1. Salary expectation
Add your answer