AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Agilisium
Compare
Filter interviews by
Agilisium Data Engineer Interview Questions and Answers
Agilisium Data Engineer Interview Experiences
6 interviews found
Anonymous
Selected
I appeared for an interview in Feb 2025.
Basic questions python spark, sql
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
3 SQL and 2 Python questions were asked, SQL was moderate, Python was tough
Interview Preparation Tips
I applied via Walk-in and was interviewed in Sep 2023. There were 2 interview rounds.
(3 Questions)
- Q1. Ranking code in sql
- Ans.
Ranking code in SQL
Use the RANK() function to assign a rank to each row based on a specified column
Use the ORDER BY clause to determine the order of ranking
Handle ties in ranking using the DENSE_RANK() function
Use the ROW_NUMBER() function to assign a unique number to each row
- Q2. Read a file using python
- Ans.
To read a file using Python, use the open() function and specify the file path and mode.
Use the open() function to open the file
Specify the file path and mode (e.g., 'r' for reading)
Read the contents of the file using the read() method
Close the file using the close() method
- Q3. Reverse a array string using python
- Ans.
Reverses an array of strings using Python.
Use the reverse() method to reverse the array in-place.
Alternatively, use slicing with a step of -1 to create a new reversed array.
Remember to convert the array to a list before reversing if necessary.
Skills evaluated in this interview
(1 Question)
- Q1. It was a basic screening round as it was a virtual walk-in drive so was asked basic details about my work experience
Agilisium interview questions for designations
Selected
I applied via Approached by Company and was interviewed before Oct 2023. There were 3 interview rounds.
(3 Questions)
- Q1. What do you worked on AWS
- Q2. SQL aggregate and window question
- Q3. Coding In python
(3 Questions)
- Q1. AWS S3 Questions
- Q2. AWS lambda Questions
- Q3. AWS Redshift Questions
(2 Questions)
- Q1. Why left previous company
- Ans.
Seeking new challenges and growth opportunities
Desire for new challenges and growth
Looking for a more innovative environment
Seeking better work-life balance
- Q2. Salary Discussion
Interview Preparation Tips
- AWS
sathya priya
It was easy to attend only general topics can be asked
(1 Question)
- Q1. Coding choise question
(1 Question)
- Q1. It was technical interview questions about python and sql
Interview Preparation Tips
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(1 Question)
- Q1. 3rd largest salary from each department(window function)
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed before May 2022. There were 2 interview rounds.
Coding test was bad. they asked irrelevant things that were not related to the field
(2 Questions)
- Q1. What is data engineering
- Ans.
Data engineering is the process of designing, building, and maintaining the infrastructure for data storage and processing.
Data engineering involves creating and managing data pipelines
It includes tasks such as data modeling, data integration, and data warehousing
Data engineers work with big data technologies such as Hadoop, Spark, and NoSQL databases
They also ensure data quality, security, and scalability
Examples of d...
- Q2. What is resilient distributed database
- Ans.
A resilient distributed database is a database that can continue to function even if some of its nodes fail.
It is designed to be fault-tolerant and highly available.
Data is distributed across multiple nodes to ensure redundancy.
If one node fails, the database can continue to function using data from other nodes.
Examples include Apache Cassandra, Riak, and HBase.
Interview Preparation Tips
Skills evaluated in this interview
Srinivasa moorthy
(1 Question)
- Q1. Explain process in adf
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.
You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.
ADF supports a wide range of d...
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Feb 2022. There were 3 interview rounds.
2 hr duration test it was. It had the topics like reasoning, number system. Technical section was also there which has sql questions
(11 Questions)
- Q1. Based on my final year project. Some questions based the programming language I added in my resume and other questions asked on sql queries on joins, union, union all difference.
- Q2. Then HR round was there in which asked some behavioral questions and tested some decision making skills
- Q3. Tell me about your final year project is a common question that every interviewer ask for fresher
- Q4. What is inheritance and type of inheritance? if you mentioned c or Java as your skill
- Q5. Tell me about yourself?
- Q6. What are your hobbies?
- Q7. What is your salary expectation.
- Q8. Are you willing to relocate?
- Q9. Are you ready to sign agreement if there is any?
- Q10. Tell me about your family background
- Q11. Is there any for future studies
Interview Preparation Tips
Do not read or practice before 10 mins of your interview.
Practice and research all the possible questions and scenarios before going to an interview
Agilisium Interview FAQs
Tell us how to improve this page.
Agilisium Interviews By Designations
- Agilisium Data Engineer Interview Questions
- Agilisium Senior Software Engineer Interview Questions
- Agilisium Software Engineer Interview Questions
- Agilisium Full Stack Developer Interview Questions
- Agilisium Ai Ml Engineer Interview Questions
- Agilisium Automation Tester Interview Questions
- Agilisium PMO Analyst Interview Questions
Interview Questions for Popular Designations
- Senior 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
Agilisium Data Engineer Interview Process
based on 7 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Agilisium Data Engineer Reviews and Ratings
based on 12 reviews
Rating in categories
|
Senior Software Engineer
97
salaries
|  ₹6.2 L/yr - ₹21 L/yr |
|
Software Engineer
90
salaries
| ₹4 L/yr - ₹12.4 L/yr |
|
Data Engineer
64
salaries
| ₹4.5 L/yr - ₹16.1 L/yr |
|
Specialist
18
salaries
| ₹9 L/yr - ₹20.5 L/yr |
|
Architect
12
salaries
| ₹22 L/yr - ₹38 L/yr |
Cyfuture
Value Point Systems
JoulestoWatts Business Solutions
Black Knight
- Home >
- Interviews >
- Agilisium Interview Questions >
- Agilisium Data Engineer Interview Questions
