AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Onward Technologies Inc
Compare
Filter interviews by
Onward Technologies Inc Senior Data Engineer Interview Questions and Answers
Onward Technologies Inc Senior Data Engineer Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 2 interview rounds.
(1 Question)
- Q1. Talend, sql orcal, workbench
(1 Question)
- Q1. Salry expattions. reloaction leaves policy
Interview Preparation Tips
(1 Question)
- Q1. Intro, weakness, strength
Interview Preparation Tips
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
Onward Technologies Inc Interview FAQs
Tell us how to improve this page.
Onward Technologies Inc Interviews By Designations
- Onward Technologies Inc Design Engineer Interview Questions
- Onward Technologies Inc Software Developer Interview Questions
- Onward Technologies Inc Senior Design Engineer Interview Questions
- Onward Technologies Inc Software Engineer Interview Questions
- Onward Technologies Inc Applications Engineer Interview Questions
- Onward Technologies Inc CAE Engineer Interview Questions
- Onward Technologies Inc Electrical Design Engineer Interview Questions
- Onward Technologies Inc Embedded Engineer Interview Questions
- Show more
Onward Technologies Inc Senior Data Engineer Interview Process
based on 2 interviews
Interview experience
Senior Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
|
Design Engineer
662
salaries
|  ₹2.2 L/yr - ₹9.3 L/yr |
|
Senior Design Engineer
326
salaries
| ₹4.1 L/yr - ₹12.5 L/yr |
|
Software Engineer
216
salaries
| ₹2 L/yr - ₹12 L/yr |
|
Project Lead
172
salaries
| ₹5.5 L/yr - ₹16.3 L/yr |
|
Senior Software Engineer
154
salaries
| ₹5.7 L/yr - ₹20.9 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Onward Technologies Inc Interview Questions >
- Onward Technologies Inc Senior Data Engineer Interview Questions
