Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Pharmarack Technologies Team. If you also belong to the team, you can get access from here

Pharmarack Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Pharmarack Technologies Technical Support Engineer Interview Questions, Process, and Tips

Updated 13 Nov 2021

Pharmarack Technologies Technical Support Engineer Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Oct 2021. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Types of Joins.
  • Ans. 

    Types of Joins are used in SQL to combine rows from two or more tables based on a related column between them.

    • Inner Join: Returns only the matching rows from both tables.

    • Left Join: Returns all the rows from the left table and the matching rows from the right table.

    • Right Join: Returns all the rows from the right table and the matching rows from the left table.

    • Full Outer Join: Returns all the rows from both tables, inclu...

  • Answered by AI
  • Q2. Difference between Drop and Delete command.
  • Ans. 

    Drop command removes a table from the database while delete command removes rows from a table.

    • Drop command is a DDL (Data Definition Language) command while delete command is a DML (Data Manipulation Language) command.

    • Drop command is irreversible and removes the entire table structure and its data while delete command only removes specific rows.

    • Drop command requires the DROP privilege while delete command requires the ...

  • Answered by AI
  • Q3. What is use of Primary key
  • Ans. 

    Primary key uniquely identifies each record in a database table.

    • Primary key ensures data integrity and consistency.

    • It helps in faster data retrieval and indexing.

    • It can be a single column or a combination of columns.

    • Primary key cannot have null values.

    • Examples of primary keys are social security number, email address, etc.

  • Answered by AI
  • Q4. What is Foreign key
  • Ans. 

    A foreign key is a column or set of columns in a table that refers to the primary key of another table.

    • It is used to establish a relationship between two tables in a database.

    • It ensures referential integrity by preventing invalid data from being inserted into the table.

    • It allows for efficient querying and joining of related data.

    • Example: A customer table may have a foreign key that references the primary key of an orde...

  • Answered by AI
  • Q5. Query to display employees records
  • Ans. 

    Query to display employees records

    • Use SELECT statement to retrieve data from employee table

    • Specify the columns to be displayed in the SELECT statement

    • Use WHERE clause to filter the records based on specific conditions

    • Use ORDER BY clause to sort the records in ascending or descending order

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just do some basic Questions about Sql.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Mar 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Tell Me About Yourself
  • Q2. Tell Me Your Job Role Responsibilities

Interview Preparation Tips

Interview preparation tips for other job seekers - my first Advice is be ready for interview and your dress is be formal & riched timely on interview location
proper eye contact with interviewer
proper answering interview question & be confident
if interviewer interested listen you so prepare different type of introduction version

I applied via Campus Placement and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Coding Test 

90 minute test on hacker rank consisting of 3 coding questions all of medium difficulty. Most candidates are required to solve more than 1 question.

Round 2 - Technical 

(3 Questions)

  • Q1. Questions on concepts of OOPS and Operating Systems.
  • Q2. Find least common ancestor of a binary tree.
  • Ans. 

    Find the lowest common ancestor of a binary tree.

    • Traverse the tree recursively from the root node.

    • If the current node is null or matches either of the given nodes, return the current node.

    • Recursively search for the nodes in the left and right subtrees.

    • If both nodes are found in different subtrees, return the current node.

    • If both nodes are found in the same subtree, continue the search in that subtree.

  • Answered by AI
  • Q3. Find first missing positive integer from an array for non-negative integers.
  • Ans. 

    Find first missing positive integer from an array of non-negative integers.

    • Create a hash set to store all positive integers in the array

    • Loop through the array and add all positive integers to the hash set

    • Loop through positive integers starting from 1 and return the first missing integer not in the hash set

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Design a parking lot
  • Ans. 

    Design a parking lot

    • Consider the size and capacity of the parking lot

    • Decide on the layout and organization of parking spaces

    • Implement a system to manage parking availability and reservations

    • Include features like ticketing, payment, and security

    • Consider scalability and future expansion

  • Answered by AI
Round 4 - Technical 

(2 Questions)

  • Q1. Given a grid which represents an ocean( For all index i,j if mat[i][j] = 1 is island and mat[i][j] = 0 means water). Find the island with largest area.
  • Q2. Given list of strings group them into distinct anagrams.
  • Ans. 

    Group list of strings into distinct anagrams.

    • Create a hash table with sorted string as key and list of anagrams as value.

    • Iterate through the list of strings and add each string to its corresponding anagram list in the hash table.

    • Return the values of the hash table as a list of lists.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Arcesium Senior Software Engineer interview:
  • Low Level Design
  • Object Oriented Programming
  • Data Structures
  • Algorithms
  • DBMS
Interview preparation tips for other job seekers - Focus on Data Structures & Algorithms and Low Level Designing. Some brushup of DBMS will also help.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Introduction about yourself
  • Q2. Some personal information
Round 3 - Technical 

(1 Question)

  • Q1. Technical questions about troubleshooting

Interview Preparation Tips

Interview preparation tips for other job seekers - Experience was good
My colleagues was good

But salary is very low

I applied via Company Website and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions from array, linkedlist , tree were asked. Also, they will give importance on your current job and projects, one single round was there only on current role.

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice more on platform like Leetcode to clear DSA problems. Medium hard will be enough to clear the rounds.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Jun 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

C++ coding question with multiple choice output and 1 code to write.

Round 3 - Technical 

(1 Question)

  • Q1. Data structure, virtual pointer, oops concept
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and basic bavkground check.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Javascript basic question was asked

Round 3 - One-on-one 

(2 Questions)

  • Q1. Email regex, angular framework
  • Q2. That all the question asked
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

C and Golang related questions, 2 Hours assement, The test involved writing code by hand in paper in the office (Bengaluru)

Round 2 - Technical 

(9 Questions)

  • Q1. Write a go code to remove duplicate elements from a slice.
  • Ans. 

    Go code to remove duplicate elements from a slice of strings

    • Use a map to keep track of unique elements

    • Iterate over the slice and add elements to the map

    • Create a new slice with unique elements from the map

  • Answered by AI
  • Q2. Difference between array and slice in Go.
  • Ans. 

    Arrays have fixed length, slices are dynamic and can grow/shrink. Slices are references to arrays.

    • Arrays have fixed length, specified at compile time.

    • Slices are dynamic, can grow or shrink at runtime.

    • Slices are references to arrays, allowing for more flexibility.

    • Example: var arr [3]string // array with fixed length of 3

    • Example: slice := make([]string, 0) // slice with dynamic length

  • Answered by AI
  • Q3. Explain struct and interface
  • Ans. 

    Struct is a user-defined data type that groups related data fields together. Interface defines a set of methods that a type must implement.

    • Struct is used to create complex data structures by grouping related data fields together.

    • Interface defines a set of methods that a type must implement. It allows for polymorphism in Go.

    • Example: type Person struct { Name string; Age int }

    • Example: type Shape interface { Area() float6...

  • Answered by AI
  • Q4. What is containerization.
  • Ans. 

    Containerization is a method of packaging, distributing, and running applications in isolated environments called containers.

    • Containers are lightweight, portable, and can run on any platform that supports containerization.

    • They include everything needed to run the application, such as code, runtime, system tools, libraries, and settings.

    • Popular containerization tools include Docker, Kubernetes, and Podman.

    • Containerizati...

  • Answered by AI
  • Q5. Write a go code to implement struct.
  • Ans. 

    Implementing a struct in Go code

    • Define a struct using the 'type' keyword

    • Add fields to the struct with their respective data types

    • Access struct fields using dot notation

  • Answered by AI
  • Q6. Explain goroutine.
  • Ans. 

    Goroutine is a lightweight thread managed by Go runtime, allowing concurrent execution of functions.

    • Goroutines are created using the 'go' keyword in Go programming language.

    • They are more lightweight than threads and are managed by the Go runtime.

    • Goroutines allow for concurrent execution of functions without the need for manual thread management.

    • Example: go myFunction()

    • Example: go func() { // code here }

  • Answered by AI
  • Q7. How do you achieve concurrency in Go?
  • Ans. 

    Concurrency in Go is achieved using goroutines and channels.

    • Use goroutines to run functions concurrently

    • Communicate between goroutines using channels

    • Avoid using shared memory for synchronization

  • Answered by AI
  • Q8. What is channel in Go? What are the differences between buffered and unbuffered channel?
  • Ans. 

    A channel in Go is a communication mechanism that allows goroutines to communicate with each other.

    • Buffered channels have a specific capacity and can send multiple values without the need for a corresponding receive operation immediately.

    • Unbuffered channels have no capacity and require both a send and receive operation to be ready at the same time for communication to occur.

  • Answered by AI
  • Q9. What is scaling? Horizontal and vertical scaling.
  • Ans. 

    Scaling refers to the ability of a system to handle increasing amounts of work or its potential to accommodate growth.

    • Horizontal scaling involves adding more machines to distribute the load, while vertical scaling involves increasing the resources of a single machine.

    • Horizontal scaling is more cost-effective and provides better fault tolerance, but can be more complex to implement.

    • Vertical scaling is simpler to impleme...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Study basic DSA. Learn C properly (Including deep concepts in pointer). Practice Golang. Also try to write solve some basic dsa problem in Go.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Coding Test 

1 hour interview for data structure coding

I appeared for an interview in Jan 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain about yourself
  • Q2. Daily activity in current job role

Interview Preparation Tips

Interview preparation tips for other job seekers - Cool and calm is very important in interview

Pharmarack Technologies Interview FAQs

What are the top questions asked in Pharmarack Technologies Technical Support Engineer interview?

Some of the top questions asked at the Pharmarack Technologies Technical Support Engineer interview -

  1. Difference between Drop and Delete comman...read more
  2. What is use of Primary ...read more
  3. Types of Join...read more

Tell us how to improve this page.

Pharmarack Technologies Technical Support Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

CMS IT Services Interview Questions
3.1
 • 138 Interviews
Arcesium Interview Questions
3.5
 • 79 Interviews
Mavenir Systems Interview Questions
3.4
 • 56 Interviews
DotPe Interview Questions
3.1
 • 38 Interviews
Hike Interview Questions
3.6
 • 32 Interviews
Junglee Games Interview Questions
3.1
 • 32 Interviews
Black Knight Interview Questions
3.6
 • 28 Interviews
View all
Pharmarack Technologies Technical Support Engineer Salary
based on 60 salaries
₹2.6 L/yr - ₹4.3 L/yr
28% less than the average Technical Support Engineer Salary in India
View more details

Pharmarack Technologies Technical Support Engineer Reviews and Ratings

based on 8 reviews

3.1/5

Rating in categories

2.0

Skill development

2.3

Work-life balance

2.7

Salary

1.3

Job security

2.5

Company culture

1.3

Promotions

2.5

Work satisfaction

Explore 8 Reviews and Ratings
Business Development Executive
110 salaries
unlock blur

₹2.2 L/yr - ₹5 L/yr

Marketing Executive
97 salaries
unlock blur

₹2 L/yr - ₹4.2 L/yr

Technical Support Engineer
60 salaries
unlock blur

₹2.6 L/yr - ₹4.3 L/yr

Regional Sales Manager
56 salaries
unlock blur

₹6.9 L/yr - ₹14.2 L/yr

Technical Support Executive
38 salaries
unlock blur

₹2.2 L/yr - ₹4.1 L/yr

Explore more salaries
Compare Pharmarack Technologies with

CMS IT Services

3.1
Compare

Quantiphi Analytics Solutions Private Limited

3.2
Compare

PrimEra Medical Technologies

3.5
Compare

Mavenir Systems

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