Upload Button Icon Add office photos

Filter interviews by

Aptino Interview Questions, Process, and Tips

Updated 19 Apr 2024

Aptino Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Count Sum of sales by customer in MySQL.
  • Ans. 

    Use GROUP BY clause to count sum of sales by customer in MySQL.

    • Use GROUP BY customer_id to group sales by customer

    • Use SUM(sales_amount) to calculate total sales for each customer

  • Answered by AI
  • Q2. Count Max sales by customer
  • Ans. 

    Use SQL query to count the maximum sales by customer.

    • Use GROUP BY clause to group the sales by customer.

    • Use MAX() function to find the maximum sales for each customer.

    • Use COUNT() function to count the maximum sales for each customer.

  • Answered by AI
  • Q3. Introduced your self and share details about your roles and responsibilities.
  • Q4. What is tableau blend and join
  • Ans. 

    Tableau blend is combining data from different data sources, while join is combining data from the same data source.

    • Tableau blend is used to combine data from different data sources in a single view.

    • Join is used to combine data from the same data source based on a common key.

    • Blending is done at the visualization level, while joining is done at the data source level.

    • Blending allows for combining data that may not have a...

  • Answered by AI
  • Q5. Explain more about filter
  • Ans. 

    Filters in SQL are used to restrict the result set based on specified criteria.

    • Filters are used in the WHERE clause of a SQL query to specify conditions that must be met for a row to be included in the result set.

    • Filters can be used to restrict the result set based on one or more columns, using comparison operators such as =, <>, >, <, >=, <=, etc.</p>

    • Filters can also be combined using logical oper...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL questions about group by and Max and min function.

Skills evaluated in this interview

SQL and BI Developer Interview Questions asked at other Companies

Q1. What is tableau blend and join
View answer (1)

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. They will ask the questions on your background and working experience

Interview Questionnaire 

1 Question

  • Q1. General Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself

Interview Questionnaire 

2 Questions

  • Q1. Speak 5 minutes on Delhi metro, Women empowerment, Facebook, Social media, Politics, motivation, trending Etc.
  • Q2. Tell me about your previous day that what you have done from morning to evening?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident because if you are not confident in front of the interviewed then you can't reply properly to any question of him, You should have to be confident.

Interview Questionnaire 

1 Question

  • Q1. Python questions on data structure, pandas, beautifulsoup.

I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. It's was basic testing questios, specific to selenium and Java.
  • Q2. Explain framework
  • Ans. 

    A framework is a set of guidelines, standards, and tools used to develop software applications.

    • A framework provides a structure for developers to build upon

    • It includes pre-written code and libraries to simplify development

    • Frameworks can be specific to a programming language or platform

    • Examples include React for web development and TensorFlow for machine learning

  • Answered by AI
  • Q3. Basic java programs

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared, basically on manual testing, Selenium and Java

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Basically in any interview most common question is Biodata, next the things included in resume..... nothing more than that
  • Q2. Literally my answer is empty.....I started saying out of box so that the interviewer might get impressed but end of day I got rejected...😂😂😂
  • Q3. Not only these I faced more than 79 interview....not less than 250-300 rounds....but none has picked me

I applied via Campus Placement and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Swap two number with and without temporary variable
  • Ans. 

    Swap two numbers with and without temporary variable

    • Without temporary variable: Use addition and subtraction

    • With temporary variable: Use a third variable to store the value of one of the numbers

    • Example without temporary variable: a=5, b=7; a=a+b; b=a-b; a=a-b;

    • Example with temporary variable: a=5, b=7; temp=a; a=b; b=temp;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be afraid. It companies take interview to select you. And if you are selected in this company you are not lucky enough so try hard.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jan 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Normal Accounts related question like describe Depreciation, ammortization, and what do you mean by Reporting (RTR Activity).
  • Q2. Some interviewer may ask what do you mean by EBITDA as in my case be prepared for this type of bouncers as well .
  • Q3. Then they will ask you your previous work related question. In my case they ask if there is GL to SL mismatch what will you do to solve it.
  • Q4. Then why do we do depreciation of companies what is the need for it
  • Ans. 

    Depreciation is necessary to allocate the cost of an asset over its useful life.

    • Depreciation helps in matching the cost of an asset with the revenue it generates.

    • It allows for the recognition of the wear and tear, obsolescence, and loss of value of assets over time.

    • Depreciation expense reduces taxable income, resulting in tax savings for companies.

    • It helps in determining the true profitability and financial position of...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be confident remember it's not that the interviewer knows everything but be convincing don't say blah blah if you don't know anything .
Read the basics and if you are experienced be sure to explain every detail of how you used to do work.
Best of luck.

I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. What is second level cache?How to implement second level cache?How to optimize sql query?what are solid principles?
  • Ans. 

    Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.

    • Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.

    • To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.

    • SOLID principles are a set of design principles for writing maintainable and scalable cod...

  • Answered by AI
  • Q2. Mostly FAQ but somewhat in depth?
  • Q3. How to deploy application in aws?
  • Ans. 

    To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.

    • Create an EC2 instance in the desired region and select the appropriate instance type

    • Configure security groups to allow traffic to and from the instance

    • Install necessary software and dependencies on the instance

    • Upload your application code to the instance

    • Start the ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic faq but in depth,Interview level is easy to medium.They will ask only theory .No practical algorithm test.

Skills evaluated in this interview

Aptino Interview FAQs

How many rounds are there in Aptino interview?
Aptino interview process usually has 1 rounds. The most common rounds in the Aptino interview process are Technical.
How to prepare for Aptino interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Aptino. The most common topics and skills that interviewers at Aptino expect are SQL, Data Analytics, ETL Testing, Power BI and Cloud.
What are the top questions asked in Aptino interview?

Some of the top questions asked at the Aptino interview -

  1. What is tableau blend and j...read more
  2. Count Sum of sales by customer in MyS...read more
  3. Count Max sales by custo...read more

Tell us how to improve this page.

Aptino Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Amazon Interview Questions
4.0
 • 5.1k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
View all

Aptino Reviews and Ratings

based on 5 reviews

3.6/5

Rating in categories

2.5

Skill development

3.9

Work-life balance

3.5

Salary

2.8

Job security

3.1

Company culture

2.7

Promotions

2.9

Work satisfaction

Explore 5 Reviews and Ratings
Technical Recruiter
10 salaries
unlock blur

₹2.4 L/yr - ₹5 L/yr

US IT Recruiter
5 salaries
unlock blur

₹2.5 L/yr - ₹5.6 L/yr

Real Time Analyst
5 salaries
unlock blur

₹5 L/yr - ₹5.7 L/yr

Executive Accountant
4 salaries
unlock blur

₹3.7 L/yr - ₹5 L/yr

Power BI Developer
4 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

Explore more salaries
Compare Aptino with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview