AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
MOURI Tech
Compare
Filter interviews by
MOURI Tech Senior Data Engineer Interview Questions and Answers
MOURI Tech Senior Data Engineer Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed in Mar 2023. There was 1 interview round.
(3 Questions)
- Q1. Find the duplicate items in a list
- Ans.
To find duplicate items in a list
Iterate through the list and compare each item with the rest of the list
Use a hash table to keep track of seen items
Sort the list and compare adjacent items
- Q2. When would you use try , else
- Q3. How would you pass connections string if lambda is connecting to database
- Ans.
Pass connection string as environment variable or use AWS Secrets Manager
Store connection string as environment variable in Lambda function configuration
Retrieve connection string from AWS Secrets Manager and use it in Lambda function
Use IAM role to grant Lambda function access to database
Encrypt connection string using AWS KMS for added security
Interview Preparation Tips
- mental health
Skills evaluated in this interview
Senior Data Engineer Jobs at MOURI Tech
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
(3 Questions)
- Q1. What are accumulators in spark?
- Ans.
Accumulators are shared variables that are updated by worker nodes and can be used for aggregating information across tasks.
Accumulators are used for implementing counters and sums in Spark.
They are only updated by worker nodes and are read-only by the driver program.
Accumulators are useful for debugging and monitoring purposes.
Example: counting the number of errors encountered during processing.
- Q2. Explain spark architecture
- Ans.
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
Spark architecture includes a driver program that manages the execution of the Spark application.
It also includes a cluster manager that allocates resources and schedules tasks on worker nodes.
Worker nodes are responsible for executing the tasks and storing data in memory or disk.
Spark architectu...
- Q3. Write a query to find duplicate data using SQL
- Ans.
Query to find duplicate data using SQL
Use GROUP BY and HAVING clause to identify duplicate records
Select columns to check for duplicates
Use COUNT() function to count occurrences of each record
(2 Questions)
- Q1. What is pub/sub?
- Ans.
Pub/sub is a messaging pattern where senders (publishers) of messages do not program the messages to be sent directly to specific receivers (subscribers).
Pub/sub stands for publish/subscribe.
Publishers send messages to a topic, and subscribers receive messages from that topic.
It allows for decoupling of components in a system, enabling scalability and flexibility.
Examples include Apache Kafka, Google Cloud Pub/Sub, and
- Q2. What services have you used in GCP
- Ans.
I have used services like BigQuery, Dataflow, Pub/Sub, and Cloud Storage in GCP.
BigQuery for data warehousing and analytics
Dataflow for real-time data processing
Pub/Sub for messaging and event ingestion
Cloud Storage for storing data and files
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. What is Databricks, and how does it differ from Azure Data Factory?
I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.
It was pair programming round where we need to attempt a couple of Spark Scenario along with the Interviewer. You will have a boiler plate code with some functionalities to be filled up. You will be assessed on writing clean and extensible code and test cases.
(1 Question)
- Q1. Questions will be based on the Project where they try to assess the depth of understading you have on your project, data quality checks, handling failure scenarios, reasoning behind choice of tech stack
Interview Preparation Tips
For Second round, Spark, Cloud Data Processing Components and being thorough with your previous experience will go a long way.
Python and sql questions
I applied via Approached by Company and was interviewed in Oct 2023. There were 2 interview rounds.
(2 Questions)
- Q1. About spark, data factory, Databricks etc
- Q2. Need explain about these tools and technologies
Interview Preparation Tips
- Pyspark
- Adf
- Databricks
- SQL
- Python
- Airflow
Practice pyspark code
Practice python,SQL, Window functions etc.
Selected
I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.
(1 Question)
- Q1. Mainly they asked about Denodo Developer, Snowflake, SQL
(1 Question)
- Q1. Architecture of Denodo , big data engineering , business uses
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
- Denodo
- Snowflake
- SQL
- SSRS
- SSIS
- Python pyspark
- Aws
I applied via Naukri.com and was interviewed in Apr 2023. There was 1 interview round.
(2 Questions)
- Q1. Hadoop spark, SQL scenario based questions on windows functions and hive questions
- Q2. More about spark and SQL
Selected
I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Architecture of spark
- Ans.
Spark is a distributed computing framework that provides in-memory processing capabilities for big data analytics.
Spark has a master-slave architecture with a central coordinator called the Driver and distributed workers called Executors.
It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.
Spark supports various data sources like HDFS, Cassandra, HBase, and S3 for input and outpu...
- Q2. SQL code for situations
- Ans.
SQL code for handling various situations in data analysis
Use CASE statements for conditional logic
Use COALESCE function to handle NULL values
Use GROUP BY and HAVING clauses for aggregating data
Use subqueries for complex filtering or calculations
(1 Question)
- Q1. Manager round- describe about self and where do you see yourself in 5 years
Skills evaluated in this interview
(1 Question)
- Q1. Create spark dataframe
- Ans.
To create a Spark DataFrame, use the createDataFrame() method.
Import the necessary libraries
Create a list of tuples or a dictionary containing the data
Create a schema for the DataFrame
Use the createDataFrame() method to create the DataFrame
Interview Preparation Tips
Skills evaluated in this interview
MOURI Tech Interview FAQs
Tell us how to improve this page.
MOURI Tech Interviews By Designations
- MOURI Tech Associate Software Engineer Interview Questions
- MOURI Tech Associate Trainee Interview Questions
- MOURI Tech Technical Consultant Interview Questions
- MOURI Tech Processing Executive Interview Questions
- MOURI Tech Quality Analyst Interview Questions
- MOURI Tech Senior Software Engineer Interview Questions
- MOURI Tech Senior Specialist Interview Questions
- MOURI Tech Abap Technical Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
MOURI Tech Senior Data Engineer Interview Process
based on 1 interview
Interview experience
Senior Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
4-6 Yrs
₹ 18-20 LPA
|
Software Engineer
275
salaries
|  ₹2.5 L/yr - ₹9.6 L/yr |
|
Associate Software Engineer
262
salaries
| ₹1.6 L/yr - ₹6 L/yr |
|
Senior Specialist
196
salaries
| ₹4.7 L/yr - ₹18 L/yr |
|
Technical Consultant
187
salaries
| ₹1.5 L/yr - ₹8 L/yr |
|
Technical Architect
164
salaries
| ₹9 L/yr - ₹36 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- MOURI Tech Interview Questions >
- MOURI Tech Senior Data Engineer Interview Questions
