AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Aptino Interview Questions, Process, and Tips
Aptino Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(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
- 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.
- 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...
- 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...
Interview Preparation Tips
Skills evaluated in this interview
SQL and BI Developer Interview Questions asked at other Companies
Jobs at Aptino
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement
Interview Questionnaire
3 Questions
- Q1. What is your final year project?what technology did i used for it?Basic oops concepts.
- Ans.
My final year project was on developing a web-based inventory management system using Java and MySQL.
Developed using Java and MySQL
Web-based inventory management system
Implemented basic OOPs concepts
Used MVC architecture for better code organization
Included features like user authentication, product management, and order tracking
- Q2. What did you do in lockdown?
- Q3. Tell me something about yourself.
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Jun 2021. There were 2 interview rounds.
They give some topics related to present situation like in my GD in 2020 co. HR give topics related to that situation in our country like difference between offline education and online education system. and covid-19 pandemic related topics.
(4 Questions)
- Q1. Tell me About your self ?
- Q2. What do you know about this job position ?
- Q3. What is your favourite colour ? Can i know the speciality of your favourite colour ?
- Q4. Who inspired you to go to job daily and work hard ?
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2021. There were 2 interview rounds.
(1 Question)
- Q1. All types of test steeps
- Ans.
Types of test steps in software testing
Unit testing - testing individual units or components of the software
Integration testing - testing how different units or components work together
System testing - testing the entire system as a whole
Acceptance testing - testing if the software meets the requirements and is ready for release
Regression testing - testing to ensure that changes or updates to the software did not intro...
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Questions related to COBOL,JCL,VSAM,DB2,CICS,Vision plus
Interview Questionnaire
2 Questions
- Q1. Resume based questions
- Q2. Basics with application
I applied via Walk-in and was interviewed before Nov 2021. There was 1 interview round.
(4 Questions)
- Q1. My self , Previous work knowledge, Salary expectations.
- Q2. Why you left last organisation?
- Q3. What is your salary expectations ?
- Q4. Where do you live at ?
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Tell me about yourself and basic questions related to programming.
Interview Questionnaire
1 Question
- Q1. Occurs, precompile , file status codes , sql queries and scenarios on sql.
Interview Questionnaire
7 Questions
- Q1. Solid principles
- Q2. Extension methods
- Q3. Static class and static constructor
- Ans.
Static class and static constructor in C#
Static class can only contain static members and cannot be instantiated
Static constructor is called only once when the class is first accessed
Static constructor is used to initialize static members of the class
Example: Math class in C# is a static class
Example: static constructor can be used to initialize a static variable with a value
- Q4. Polymorphism
- Q5. Dependency injection
- Q6. Angular life cycle hook
- Q7. Performance improvement in Angular app
- Ans.
Performance improvement in Angular app
Use lazy loading to load modules on demand
Optimize change detection strategy
Use trackBy function in ngFor loops
Minimize DOM manipulation
Use AOT compilation
Implement server-side rendering
Use web workers for heavy computations
Use caching for frequently accessed data
Skills evaluated in this interview
Aptino Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Aptino Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
5-7 Yrs
Not Disclosed
3-5 Yrs
Not Disclosed
3-4 Yrs
Not Disclosed
|
Technical Recruiter
10
salaries
|  ₹2.4 L/yr - ₹5 L/yr |
|
US IT Recruiter
5
salaries
| ₹2.5 L/yr - ₹5.6 L/yr |
|
Real Time Analyst
5
salaries
| ₹5 L/yr - ₹5.7 L/yr |
|
Executive Accountant
4
salaries
| ₹3.7 L/yr - ₹5 L/yr |
|
Power BI Developer
4
salaries
| ₹10 L/yr - ₹24 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Aptino Interview Questions
