Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
1 hour aptitude test
The platform used to build the study is Microsoft SQL Server.
Microsoft SQL Server is a relational database management system developed by Microsoft.
It is commonly used for building and managing databases in various applications.
It supports SQL (Structured Query Language) for querying and managing data.
It offers features like data storage, retrieval, and security.
Examples of platforms using Microsoft SQL Server include ...
I have been with my existing company for 5 years.
I started working at my current company in 2016.
I have gained valuable experience and knowledge during my time here.
I have been involved in various database design projects, contributing to the growth of the company.
posted on 31 Jul 2024
I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.
Java program to check if two strings are anagrams
Create a function that takes two strings as input
Convert both strings to character arrays and sort them
Check if the sorted arrays are equal to determine if they are anagrams
Insert and select data in MySQL using SQL queries
Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data
Use SELECT * FROM table_name; to select all data from a table
Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition
GET and POST are HTTP methods used in REST APIs for retrieving and sending data.
GET method is used to retrieve data from a server
POST method is used to send data to a server
GET requests are idempotent, while POST requests are not
GET requests should only be used for retrieving data, not for modifying data
Example: GET request to retrieve a list of users - GET /users
Example: POST request to create a new user - POST /users
I applied via Company Website and was interviewed in Jun 2023. There were 2 interview rounds.
I applied via AmbitionBox and was interviewed before Sep 2023. There were 3 interview rounds.
General aptitude along with reasoning
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
SQL is necessary for most projects involving databases to manage and query data efficiently.
SQL is essential for creating, updating, and querying databases in most projects.
Without SQL, it would be challenging to interact with databases and retrieve specific data.
Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.
SQL can help optimize database performance and ensure data integrity.
HQL stands for Hibernate Query Language, a query language similar to SQL but used for Hibernate ORM framework.
HQL is used to perform database operations in Hibernate ORM framework.
It is similar to SQL but operates on Hibernate objects instead of database tables.
HQL queries are written in Hibernate-specific syntax.
Example: 'FROM Employee e WHERE e.department = :dept'
HQL queries are translated into SQL queries by Hiberna
Views in Java are user interface components that display data from a model in a specific format.
Views are used to represent the user interface in Java applications.
They display data from a model in a visually appealing format.
Examples include buttons, text fields, labels, and checkboxes.
Cross joins are a type of join operation in SQL that combines each row from one table with each row from another table.
Cross joins do not have a join condition specified, resulting in a Cartesian product of the two tables.
They can be used when you want to combine every row from one table with every row from another table.
Cross joins can lead to a large result set if the tables being joined have many rows.
Delete removes rows one by one, while truncate removes all rows at once.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
posted on 12 Dec 2023
I applied via Approached by Company and was interviewed in Nov 2023. There were 4 interview rounds.
They send an mail which have the link about assessment test
In hall all are discussed and written an interview test
posted on 9 Feb 2021
I applied via Company Website and was interviewed in Jan 2021. There was 1 interview round.
I know Python, R, SQL, and Java.
Python
R
SQL
Java
Quantity, reasonning, English question and have coding
I am a dedicated and experienced consultant with a strong background in problem-solving and client management.
Over 5 years of experience in consulting roles
Skilled in analyzing data and providing strategic recommendations
Excellent communication and interpersonal skills
Proven track record of successfully managing client relationships
Strong ability to work under pressure and meet deadlines
posted on 17 Jul 2024
I applied via Naukri.com and was interviewed in Jun 2024. There were 2 interview rounds.
Normal question of reasoning and maths
Sorting arraylist , sorted map
based on 1 interview
Interview experience
Consultant
1.1k
salaries
| ₹8.5 L/yr - ₹26.8 L/yr |
Associate Consultant
1.1k
salaries
| ₹5 L/yr - ₹19.5 L/yr |
Clinical Data Specialist
766
salaries
| ₹3.5 L/yr - ₹11.1 L/yr |
Drug Safety Associate
744
salaries
| ₹2 L/yr - ₹8.5 L/yr |
Software Developer
726
salaries
| ₹4.9 L/yr - ₹19 L/yr |
Syngene International
Aragen Life Sciences
SAI Life Sciences
Parexel International