Aester India Interview Questions and Answers

Q1. Basic question on the tool I use in previous company and ask question on the components of it.
Add your answer

Q1. More on what is my role and managerial round.
Add your answer

Q1. 2 hour long interview with a panel of 4. Possibly every single question that can be asked and repeatedly same things. They tried understanding the process and functions elaborately way too much which was ...read more
Add your answer

Q1. Everything was already asked. But they need to drench and waste time of the candidate and themselves so they set up another round of technical to ask the same questions again and again.
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. How do you assess if a user story is complete or not. Have you heard about INVEST.
Add your answer
Q2. Are you aware of RACI matrix.
Add your answer
Q3. If there are multiple stakeholders and one of the stakeholder is old school and against the new requirement, how do you handle such stakeholder.
Add your answer

Q1. What is the difference between requirement gathering and requirement elicitation.
Add your answer
Q2. What are the 3Cs of a user story.
Add your answer
Q3. Traceability matrix
Add your answer

The group discussion is the we work with team and the team (Group). The discussion is the company group had the meeting an they think what they do on next and etc....

Q1. What is the meaning of Teleperformance?
Ans. 
Teleperformance is a global outsourcing company specializing in customer experience management.
• Global outsourcing company

• Specializes in customer experience management

• Provides services such as customer support, technical support, sales, etc.
Answered by AI
Add your answer
Q2. What motivated you to select this job?
Ans. 
Passion for problem-solving and interest in software development drove me to choose this job.
• Passion for problem-solving

• Interest in software development

• Opportunity to learn and grow in the field
Answered by AI
Add your answer
Q3. Are you interested to do work
Ans. 
Yes, I am very interested in doing work as a Junior Software Programmer.
• I am passionate about coding and problem-solving

• I enjoy learning new technologies and improving my skills

• I have completed relevant courses or certifications in software development
Answered by AI
Add your answer
Q4. Did you work Before in Teleperformance
Ans. 
No, I have not worked at Teleperformance before.
• I have not worked at Teleperformance in the past.

• My previous work experience does not include Teleperformance.

• I am a new candidate for this position and have not worked at Teleperformance.
Answered by AI
Add your answer
Q5. Are you Happy with thus job
Ans. 
Yes, I am happy with this job because I enjoy coding and problem-solving.
• I enjoy coding and problem-solving

• I appreciate the opportunities for growth and learning in this role

• I have a positive relationship with my team and enjoy collaborating on projects
Answered by AI
Add your answer

Q1. Myself and experience in english
Add your answer
Q2. Selected for the peocess
Add your answer
Q3. Last drawn salary why you are not another process
Add your answer
Q4. Why you left last job
Add your answer
Q5. Rate ur english 1 to 10 numbers
Add your answer
Q6. Introduce yourself as a employee
Add your answer
Q7. Season topic talk for two minutes
Add your answer
Q8. How is good english
Add your answer
Q9. Your favourite place on this topic
Add your answer

Assessment via link MCQ

Q1. Microservices theory, Kafka
Add your answer
Q2. Singoloton design pattern, concurrent package, core java, collection questions, Java 8 related problem solving stream api questions
Add your answer

Q1. Same like round 1, little bit managerial
Add your answer
Q2. Producer consumer multithreading, Java 8 , core java, project
Add your answer

Q1. Behavioral questions
Add your answer
Q2. Situation based questions
Add your answer

Q1. Command to check disk utilisation and health in Hadoop
Ans. 
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
• Run 'hdfs diskbalancer -report' to get a report on disk utilisation

• Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage

• Check the Hadoop logs for any disk health issues
Answered by AI
Add your answer
Q2. Spark Architecture & the significance of each member of spark Architecture
Ans. 
Spark Architecture consists of Driver, Cluster Manager, and Executors. Driver manages the execution of Spark jobs.
• Driver: Manages the execution of Spark jobs, converts user code into tasks, and coordinates with Cluster Manager.

• Cluster Manager: Manages resources across the cluster and allocates resources to Spark applications.

• Executors: Execute tasks assigned by the Driver and store data in memory or disk for further pr...read more
Answered by AI
Add your answer
Q3. Partitioning and bucketing
Add your answer
Q4. Spark optimization techniques
Ans. 
Optimization techniques in Spark improve performance and efficiency of data processing.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data in memory

• Using broadcast variables for small lookup tables

• Avoiding shuffling operations whenever possible

• Tuning memory settings and garbage collection parameters
Answered by AI
Add your answer
Q5. Second highest salary
Ans. 
I am unable to provide this information as it is confidential.
• Confidential information about salaries in previous organizations should not be disclosed.

• It is important to respect the privacy and confidentiality of past employers.

• Discussing specific salary details may not be appropriate in a professional setting.
Answered by AI
Add your answer
Q6. Pivot table creation in SQL from not pivot one
Ans. 
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
• Use the CASE statement to categorize data into columns

• Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category

• Group the data by the columns you want to pivot on
Answered by AI
Add your answer
Q7. How to create triggers
Ans. 
Creating triggers in a database involves defining the trigger, specifying the event that will activate it, and writing the code to be executed.
• Define the trigger using the CREATE TRIGGER statement

• Specify the event that will activate the trigger (e.g. INSERT, UPDATE, DELETE)

• Write the code or actions to be executed when the trigger is activated

• Test the trigger to ensure it functions as intended
Answered by AI
Add your answer

Q1. Explain projects worked on and benefits
Add your answer
Q2. What is agile , SDLC, user stories
Ans. 
Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.
• Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.

• SDLC is the process of planning, creating, testing, and deploying software applications.

• User stories ...read more
Answered by AI
Add your answer

Q1. How will to create a new market in vietnam for LC/BG
Ans. 
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
• Conduct market research to understand the needs and preferences of Vietnamese businesses

• Build relationships with local banks, businesses, and government agencies to establish credibility and trust

• Offer tailored financial ...read more
Answered by AI
Add your answer
Q2. What is acceptance criteria
Ans. 
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
• Acceptance criteria are typically defined during the planning phase of a project.

• They are used to determine whether a product or feature is complete and functioning as expected.

• Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'

• They help ensure that the product mee...read more
Answered by AI
Add your answer

Shortlisted students were divided in group of 19

Selected students from gd got the call for case study round

Q1. Questions were based on the case study and guesstimates
Add your answer
Q2. No. of aeroplane flying in the sky right now
Ans. 
It is impossible to accurately determine the exact number of airplanes flying in the sky at any given moment.
• The number of airplanes in the sky constantly changes due to take-offs, landings, and flights being at different stages.

• Factors such as time of day, weather conditions, and air traffic also affect the number of airplanes in the sky.

• Air traffic control systems may provide estimates of the number of airplanes in a
Answered by AI
Add your answer
Q3. How will u utilise 1 acre of land provided to u near ur college
Ans. 
I would utilize the 1 acre of land near my college for creating a sustainable community garden.
• Establishing vegetable and fruit gardens to promote healthy eating among students

• Setting up a composting area to reduce waste and enrich the soil

• Creating a space for outdoor classes and events to enhance learning and community engagement
Answered by AI
Add your answer
Q4. How to start a starbuck franchisein ur town
Ans. 
To start a Starbucks franchise in your town, you need to follow a specific process set by the company.
• Contact Starbucks corporate office to inquire about franchise opportunities

• Meet the financial requirements and submit a franchise application

• Find a suitable location for the Starbucks store

• Complete the required training and adhere to Starbucks' standards and guidelines
Answered by AI
Add your answer
Q5. Sql extraction of the given table and data
Ans. 
Use SQL query to extract data from a given table
• Use SELECT statement to retrieve data from the table

• Specify the columns you want to retrieve after SELECT

• Use FROM clause to specify the table name

• Add conditions using WHERE clause if needed

• Use ORDER BY clause to sort the results if necessary
Answered by AI
Add your answer