ACG Infotech Interview Questions and Answers

Q1. Support Role Questions 1) Like explaining a case which was done in your previous role and experience
Add your answer
Q2. Questions on Javascript
Add your answer

Q1. Technical Interview questions on Javascript, HTML, CSS and behavioural
Add your answer

Q1. Manager Questions based on Position and previous work experience.
Add your answer

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Mainly data leakage related problems

Q1. Basic Swift and Objective C related questions
Add your answer
Q2. SOLID principle
Add your answer
Q3. Details of SOLID principle with its basic
Add your answer
Q4. How to handle memory leakage
Ans. 
Best practices for handling memory leaks in iOS development
• Use Instruments to identify memory leaks

• Avoid strong reference cycles with weak or unowned references

• Use autorelease pools for temporary objects

• Implement proper memory management with ARC (Automatic Reference Counting)
Answered by AI
Add your answer
Q5. Memory management
Add your answer

Q1. Years of Experience?
Add your answer
Q2. Why you want to relocate?
Add your answer

Q1. What are the different agile ceremonies in your project
Add your answer
Q2. What is Testing Pyramid? What are the different layers in it?
Ans. 
Testing Pyramid is a testing strategy that suggests the right balance of different types of automated tests.
• The Testing Pyramid consists of three layers: Unit Tests, Service Tests, and UI Tests.

• Unit Tests are at the bottom of the pyramid and focus on testing individual components or functions in isolation.

• Service Tests are in the middle layer and focus on testing the interactions between different components or service...read more
Answered by AI
Add your answer
Q3. Who performs unit testing?
Ans. 
Developers perform unit testing to ensure individual units of code are working correctly.
• Developers are responsible for writing unit tests for their own code.

• Unit testing is typically done using testing frameworks like JUnit, NUnit, or pytest.

• Unit tests focus on testing small, isolated parts of the codebase, such as functions or methods.

• Unit testing helps identify bugs early in the development process.

• Automated unit te...read more
Answered by AI
Add your answer
Q4. Write an automation code for handling multiple windows.
Ans. 
Automation code for handling multiple windows
• Use getWindowHandles() method to get handles of all open windows

• Switch between windows using switchTo().window() method

• Perform actions on each window as needed
Answered by AI
Add your answer
Q5. Given a string s1= Apple. Write a code to convert s1 to array and put the vowels to that array
Ans. 
Convert string to array and extract vowels into a new array
• Iterate through each character in the string

• Check if the character is a vowel (a, e, i, o, u)

• Add the vowel to a new array of strings
Answered by AI
Add your answer

Q1. Internal working of hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To retrieve a value, the key is hash...read more
Answered by AI
Add your answer
Q2. Find Anagram from string array
Ans. 
Find anagrams from a string array
• Iterate through each string in the array

• Sort the characters of each string to create a key for comparison

• Use a hashmap to group anagrams together

• Return the grouped anagrams as arrays
Answered by AI
Add your answer

Q1. Top view of binary Tree
Ans. 
A top view of a binary tree shows the nodes visible when looking at the tree from the top.
• The top view of a binary tree is the set of nodes visible when looking at the tree from the top.

• Nodes at the same horizontal distance from the root are considered at the same level.

• Use a map to store the horizontal distance of each node and only keep the first node encountered at each horizontal distance.
Answered by AI
Add your answer
Q2. Java based questions
Add your answer

Q1. Hight of binary tree
Ans. 
Height of a binary tree is the maximum number of edges on the longest path from the root node to a leaf node.
• Height of an empty tree is -1

• Height of a tree with only one node is 0

• Height of a binary tree can be calculated recursively by finding the height of left and right subtrees and adding 1 to the maximum of the two heights
Answered by AI
Add your answer
Q2. Garbage Collector
Add your answer

Q1. Library Management System
Add your answer

Q1. Explain Solid Principles
Ans. 
Solid Principles are a set of five design principles for writing clean, maintainable, and scalable code.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects of its subclasses without affe...read more
Answered by AI
Add your answer
Q2. What are Design Patterns
Ans. 
Design patterns are reusable solutions to common problems encountered in software design and development.
• Design patterns provide a way to communicate solutions to common design problems

• They help in making code more maintainable, scalable, and reusable

• Examples include Singleton, Factory, Observer, and Strategy patterns
Answered by AI
Add your answer

Q1. Explain the current project architecture you are working on.
Ans. 
Our current project architecture follows a microservices design pattern with Docker containers and Kubernetes for orchestration.
• Microservices architecture

• Docker containers

• Kubernetes for orchestration
Answered by AI
Add your answer
Q2. Why you are intrested in NCR
Ans. 
I am interested in NCR because of its reputation for innovation and cutting-edge technology in the software industry.
• NCR has a strong reputation for innovation and cutting-edge technology

• I am excited about the opportunity to work on challenging projects at NCR

• I believe NCR offers a great platform for career growth and development
Answered by AI
Add your answer