AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Advent Informatics Interview Questions and Answers
Advent Informatics Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed before Dec 2021. There were 4 interview rounds.
(1 Question)
- Q1. Introduction Project flow Why did you use HBase in your project? How did you query for data in HBase? What was the purpose of Hive? What are external partitioned tables? Optimization done in your projects
- Ans.
Discussion on project flow, HBase, Hive, external partitioned tables, and optimization in a Data Engineer interview.
Explained project flow and the reason for using HBase in the project
Discussed querying data in HBase and the purpose of Hive
Described external partitioned tables and optimization techniques used in the project
(3 Questions)
- Q1. Spark scenario based questions
- Q2. SQL handling data redundancy
- Q3. Python code for getting rid of more than 2 spaces in a long text file.
- Ans.
Python code to remove more than 2 spaces in a long text file.
Read the text file and store it in a variable
Use regular expressions to replace more than 2 spaces with a single space
Write the updated text back to the file
(5 Questions)
- Q1. Introduction of yourself
- Ans.
I am a Data Engineer with expertise in data pipelines, ETL processes, and big data technologies to drive data-driven decisions.
Data Pipeline Development: I have built robust data pipelines using Apache Airflow to automate data workflows, ensuring timely data availability.
ETL Processes: I have experience in designing ETL processes with tools like Talend and Apache NiFi, transforming raw data into actionable insights.
Big...
- Q2. Why are you leaving the current organization?
- Ans.
I am seeking new challenges and opportunities for growth that align better with my career aspirations and skill set.
Career Growth: I feel that my current role has limited opportunities for advancement, and I am looking for a position that offers a clearer path for professional development.
Skill Utilization: I want to leverage my data engineering skills more effectively, as my current job does not fully utilize my exper...
- Q3. What kind of tools have you worked on?
- Ans.
I have worked on various tools including Hadoop, Spark, Kafka, and SQL Server.
Worked on Hadoop for distributed storage and processing of large datasets
Used Spark for in-memory data processing and machine learning
Implemented Kafka for real-time data streaming and messaging
Worked with SQL Server for relational database management and querying
- Q4. Where do you see yourself in 5 years?
- Ans.
In five years, I envision myself as a senior data engineer, leading projects and mentoring junior engineers in data architecture.
Career Advancement: I aim to progress to a senior data engineer role, where I can lead complex data projects and make strategic decisions.
Mentorship: I want to mentor junior engineers, sharing my knowledge in data pipelines and ETL processes to help them grow professionally.
Technical Expertis...
- Q5. Salary negotiations and discussion
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed in Apr 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. How to change the process
Interview Preparation Tips
I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. After 5 year in which position you will be
- Ans.
In five years, I envision myself as a senior analyst, leading projects and mentoring junior team members while driving impactful data-driven decisions.
I aim to develop expertise in advanced analytics tools, such as Python and R, to enhance data modeling capabilities.
I plan to take on leadership roles in projects, guiding teams to deliver actionable insights that align with business goals.
I aspire to mentor junior analy...
Interview Preparation Tips
You have basic knowledge of your qualifications
Interview Questionnaire
1 Question
- Q1. Bmide, Rac, itk, migration.
Interview Questionnaire
1 Question
- Q1. In 5 programs without effecting one by one how can you debug a particular program and how can you know tha program is calling in debug
- Ans.
To debug a particular program without affecting others, use breakpoints and step through the code.
Set a breakpoint in the program you want to debug
Step through the code using a debugger to identify the issue
Use logging statements to track the flow of the program
Check the call stack to see which functions are being called
Use conditional breakpoints to stop the program at specific points
Skills evaluated in this interview
I applied via Walk-in and was interviewed before Jun 2021. There were 2 interview rounds.
HR told about the company on the first day, how it works, told the rules, showed the management and a lot
Interview Preparation Tips
- Safery
- Environment
- Cleaning
I applied via Approached by Company and was interviewed before Jul 2021. There were 3 interview rounds.
(1 Question)
- Q1. It would be a short listing process to check if you fit the role
(1 Question)
- Q1. Questions would be based on the LP’s
(1 Question)
- Q1. Leadership principles
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
Interview Questionnaire
5 Questions
- Q1. What are the differences between C and C++?
- Q2. Explain the scenarios where If and Switch Case statements are used.
- Ans.
If and Switch Case statements are used for conditional branching in programming.
If statements are used for simple conditional branching.
Switch Case statements are used for multiple conditional branching.
If statements are more flexible than Switch Case statements.
Switch Case statements are more efficient than If statements for large number of conditions.
If statements can be nested, but Switch Case statements cannot.
Exam...
- Q3. Do you think algorithms and pseudocodes still play a role in the world of IT Services?
- Ans.
Yes, algorithms and pseudocodes are still important in IT Services.
Algorithms are used in various fields of IT such as machine learning, data analysis, and cryptography.
Pseudocodes are used to plan and design algorithms before coding them.
Understanding algorithms and pseudocodes is essential for software engineers to write efficient and optimized code.
Examples of algorithms include sorting algorithms, search algorithms...
- Q4. Are you comfortable using Command Line Interfaces (CLIs) or Integrated Development Environments (IDEs) as part of your daily tasks?
- Ans.
Yes, I am comfortable using both CLIs and IDEs for my daily tasks.
I have experience using various CLIs such as Git Bash, Windows Command Prompt, and Terminal on macOS.
I am proficient in using IDEs such as Visual Studio Code, Eclipse, and IntelliJ IDEA.
I understand the benefits and drawbacks of both CLIs and IDEs and can choose the appropriate tool for the task at hand.
- Q5. Are you okay to learn front end and back end technologies to ensure you are a complete developer in the longer run? Would you be able to learn the concepts if a timeline is given?? If yes, explain your lea...
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
3 Questions
- Q1. Mathematical ,verbal, logical, puzzles, pseudo code
- Q2. Verbal
- Q3. Logical
Interview Preparation Tips
I applied via Referral and was interviewed in Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. About skills.
Interview Preparation Tips
Advent Informatics Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Advent Informatics Reviews and Ratings
based on 23 reviews
Rating in categories
|
Data Engineer
55
salaries
|  ₹4 L/yr - ₹7.5 L/yr |
|
Softwaretest Engineer
23
salaries
| ₹3.6 L/yr - ₹7 L/yr |
|
Associate Consultant
11
salaries
| ₹4 L/yr - ₹6.9 L/yr |
|
Salesforce Administrator
11
salaries
| ₹3.8 L/yr - ₹7 L/yr |
|
Power BI Developer
8
salaries
| ₹3.9 L/yr - ₹5 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Advent Informatics Interview Questions
