AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Aventra Group Interview Questions and Answers
Aventra Group Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.
Group discussion was purely technical, concepts related etl, azure,big data, SQL etc.
Whoever knows the answer should raise their hands and start answering.
(1 Question)
- Q1. Questions on SQL stored procedure Pipelines Etl Pyspark Python code for data manipulation and importing Excel sheet Big data Azure ADF and Synapse
(1 Question)
- Q1. Interview with CEO General HR questions like strength and weakness Willing to relocate Latest technologies like generative AI, NLP
Interview Preparation Tips
Data Engineer Interview Questions asked at other Companies
ETL quiz and python questions
(2 Questions)
- Q1. Questions on azure big data
- Q2. Sql pyspark adn python
Data Engineer Interview Questions asked at other Companies
Jobs at Aventra Group
Interview questions from similar companies
Interview Preparation Tips
Experience: Relevant experience matters, a lot!
Round: HR Interview
Experience: Nothing specific. Just resume based.
Round: Technical Interview
Experience: 7 rounds. Across SQL, Python, Shell Script (bash), platform architectures and Amazon web services (AWS).
Tips: Prepare well - SQL and data architectures for various use cases.
Round: Behavioural Interview
Experience: On Amazons leadersh
I applied via Walk-in and was interviewed before Feb 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Interview mainly asked about spark architecture.
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Cloud Data Warehousing
- Q2. SQL, ETL related Questions
Interview Preparation Tips
I applied via Job Portal and was interviewed before Jul 2021. There were 2 interview rounds.
Coding test in hacker rank, easy
(1 Question)
- Q1. Questions related to dbms, Computer network, basic programming language
Interview Preparation Tips
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Design booking.com.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. 1. Programming Logic for loops and majorly In python
- Ans.
Python has for and while loops. For loop iterates over a sequence and while loop executes a block of code while a condition is true.
For loop syntax: for variable in sequence: block of code
While loop syntax: while condition: block of code
Example: for i in range(5): print(i) will print 0 to 4
Example: while x < 5: print(x); x += 1 will print 0 to 4
- Q2. Data warehouse concept
- Q3. Cloud Concepts Aws
- Q4. SQL writing SQL query important
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed before Jun 2021. There were 5 interview rounds.
About your tech stack along with 2 Programming question basic DS Problems, and 2-3 SQL Queries moderate level.
3-4 SQL queries medium to high level and 2 programming question moderate level
Data modeling and Data warehousing questions along with SQL queries Hard level
(2 Questions)
- Q1. Create a Data model for the use case like CCD, Pizza hut and questions from that Data model
- Q2. Data Warehousing and Big data related problems Data pipelines and ETL related Question Cloud computing related questions
(1 Question)
- Q1. Techno manager round on case studies to come complex problems.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Describe your projects?
- Q2. What are the technologies you have worked on?
- Ans.
I have worked on various technologies including Hadoop, Spark, SQL, Python, and AWS.
Experience with Hadoop and Spark for big data processing
Proficient in SQL for data querying and manipulation
Skilled in Python for data analysis and scripting
Familiarity with AWS services such as S3, EC2, and EMR
Knowledge of data warehousing and ETL processes
- Q3. Behavioral Questions
Interview Preparation Tips
Aventra Group Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Aventra Group Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Aventra Group Reviews and Ratings
based on 8 reviews
Rating in categories
4-9 Yrs
Not Disclosed
3-7 Yrs
Not Disclosed
|
Data Analyst
7
salaries
|  ₹3.9 L/yr - ₹4 L/yr |
|
Associate Software Engineer
6
salaries
| ₹3.8 L/yr - ₹6.5 L/yr |
|
Data Engineer
5
salaries
| ₹4 L/yr - ₹4.5 L/yr |
|
Senior Software Engineer
4
salaries
| ₹23 L/yr - ₹28 L/yr |
|
Junior Data Analyst
4
salaries
| ₹4 L/yr - ₹4.4 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Aventra Group Interview Questions
