i
Dilyt
Filter interviews by
posted on 29 Jun 2024
I applied via Walk-in and was interviewed in May 2024. There were 3 interview rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
SLA stands for Service Level Agreement, which outlines the level of service expected from a vendor.
SLA defines the agreed upon level of service between a provider and a customer.
It includes metrics like response time, uptime, and resolution time.
SLAs are important for ensuring accountability and quality of service.
Example: An SLA might specify that the vendor will respond to support tickets within 24 hours.
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
DDL is used to create, modify, and delete database objects such as tables, indexes, and views.
DML is used to insert, update, delete, and retrieve data from database tables.
Examples of DDL statements include CREATE TABLE, ALTER TABLE...
Use SQL query with ORDER BY and LIMIT to fetch employee record with second highest salary.
Write a SQL query to select the employee record with the second highest salary from the employees table.
Use ORDER BY clause to sort the salaries in descending order.
Use LIMIT 1,1 to fetch the second row after sorting.
Example: SELECT * FROM employees ORDER BY salary DESC LIMIT 1,1;
One of the trickiest incidents I faced was resolving a complex data integration issue with multiple sources.
Identified root cause by analyzing data flow and dependencies
Collaborated with cross-functional teams to gather insights and solutions
Implemented a step-by-step plan to address the issue and conducted thorough testing
Documented the process for future reference and prevention
SQL is divided into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
Data Definition Language (DDL) - used to define the structure of database objects like tables, indexes, and views. Examples include CREATE, ALTER, DROP.
Data Manipulation Language (DML) - used to manipulate data stored in the database. Examples include SELECT, INSERT, ...
To prepare an employee's attendance record, I would gather data on their attendance, create charts and graphs to visualize trends and patterns.
Gather attendance data including dates, times, and reasons for absence or tardiness
Create a spreadsheet or database to organize the data
Use software like Excel or Tableau to create charts and graphs showing attendance trends
Include metrics such as overall attendance rate, late a...
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL is a standard language used to interact with databases, while MySQL is a specific database management system.
SQL is an ANSI (American National Standards Institute) standard language, while MySQL is an open-source relational database management system.
SQL can be used with various database ma...
Joins are used to combine rows from two or more tables based on a related column between them.
Joins are used in SQL to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: INNER JOIN retrieves rows from both tables where the join condition is met.
Example: LEFT JOIN retrieves all rows from the left table and the matched rows ...
Top trending discussions
I appeared for an interview before Mar 2024, where I was asked the following questions.
I appeared for an interview before Aug 2016.
posted on 18 May 2021
I applied via Walk-in and was interviewed before May 2020. There were 4 interview rounds.
For loop is used for iterating over a range of values while for each loop is used for iterating over elements of an array.
For loop is used when the number of iterations is known beforehand.
For each loop is used when the number of iterations is not known beforehand.
For loop can be used with any iterable object.
For each loop can only be used with arrays and other iterable objects.
For loop uses an index variable to access...
posted on 22 Jul 2024
20 General MCQs were asked
Group discussion on any topic
I applied via Walk-in and was interviewed before Jun 2023. There was 1 interview round.
An interface in software development defines a contract for classes to implement, specifying methods and properties.
Interfaces in programming languages like Java and C# allow for multiple inheritance by defining a set of methods that a class must implement.
Interfaces provide a way to achieve abstraction and polymorphism in object-oriented programming.
Interfaces are used to define common behavior that multiple classes c...
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
Encapsulation helps in hiding the internal state of an object and restricting access to it.
It allows for better control over the data by preventing direct access from outside the class.
Encapsulation promotes code reusability and makes the code easier to maintain.
Example: In a class representing a car, the variables lik...
10 apti questions and 10 technical mcq on cpp
posted on 1 Oct 2024
Oops topic and aptitude
based on 1 interview
Interview experience
based on 1 review
Rating in categories
BI Developer
20
salaries
| ₹2.4 L/yr - ₹4.5 L/yr |
ETL Developer
9
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
Business Intelligence Developer
8
salaries
| ₹2.4 L/yr - ₹3.5 L/yr |
Software Engineer
5
salaries
| ₹2 L/yr - ₹6.7 L/yr |
Business Development Executive
4
salaries
| ₹4 L/yr - ₹8.5 L/yr |
HCL Infosystems
Accel Frontline
Diverse Lynx
Pitney Bowes