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

Clear (1)

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

Interview Preparation Tips

Round: Test
Experience: There was Pool Campus Placement of  4 Colleges together(NIT Jalandhar,NIT Hamirpur ,Candigarh University and CGC Landran ) at Chandigarh University.Written test was taken on Hacker Rank. There were 5 Coding Questions of Linklist , Dynamic Programming,Priority Queues etc . 
You didn't have to do All the questions (3 can get you to the next round).

One thing that need to be beware of is that on Hacker Rank Your Draft is Saved every second(or so). So don't copy from the internet and just paste there(they will get to know).
Tips: Make sure you practice lot of Algorithms.
Duration: 120 minutes
Total Questions: 5

Round: Problem Statement
Experience: Only 8 Students were selected for this round
20 mins were given for it
and afterwards each student had personal discussion(10 mins) with them to explain their schema .
3-4 Questions were also asked related to your schema and how to perform a particular query
Tips: You should Be Through with DBMS
Make sure there is no redundant table and Primary keys are marked

Round: Technical Interview
Experience: 2 were selected for the Interview
Firstly they make you very Comfortable and ask how were the previous Rounds.
Then they asked about the two questions of First Round and my approach 
Then couple of questions on The design that was made Earlier.
Then there were questions on How Internet Works ,gcc,Linux,git,sql.

Then the Interviewer asked if I have any question
I asked about (as the work on doctor's app) how they know the credibility of a doctor which is enlisted in their app.
Interviewer was really Impressed by the question and told me all about it with all details.


Both were selected
Tips: Be cool in the Interview
Think Loudly and Interact with them well.
If they want you to ask any question ,it should not be related to technical stuff ,it should be related to the company

College Name: NIT JALANDHAR

I applied via Referral

Interview Questionnaire 

5 Questions

  • Q1. I was asked to optimize the last program mentioned above
  • Q2. I was asked in detail about my internship experience and projects
  • Q3. I was asked why I did not contribute to any open source projects
  • Q4. I was asked to explain the code of my android app from my dropbox account
  • Q5. The usual HR questions followed after that

Interview Preparation Tips

Skills:
College Name: NA

Software Engineer Interview Questions & Answers

Practo user image BEKKAM VENKATA ADITYA

posted on 27 Sep 2015

I applied via Campus Placement

Interview Questionnaire 

4 Questions

  • Q1. General questions. Where are you from, tell about yourself etc..,
  • Q2. Asked me about the projects which i have mentioned in my resume
  • Q3. Some algorithmic questions including data structures. Time complexity, space complexity etc.,
  • Q4. How would you design a snake game present in basic nokia mobiles. Just the data structure part and some functions which are used as the game goes on

Interview Preparation Tips

Round: Test
Experience: A bit difficult but sensible way to get started with the selection procedure. Questions purely attack the algorithmic and stastitic aspects.
Tips: Get yourself ready with conceptual clartity regarding algorithms and stastics . Don't be ambitious to attempt all the questions, completely solving one problem would be more than enough for getting through this level.
Duration: 120 minutes
Total Questions: 3

Round: Technical Interview
Experience: Believe me. You never feel inferior, it's really interactive and very friendly. Interviewer gave me a few chances and hints whenever i've gone wrong. Overall interview experience was awesome.
Tips: If you're up to this round, they believe you have the potential. So don't panic if you are unable to answer their questions. Just tell them which aspects which you are comfortable with and they will proceed correspondingly, Just be honest whatsoever.

Skill Tips: Prefer having some revision about the above skills before undergoing the selection process.
Skills: Math Puzzles, Algorithmic Approach To Problem Solving, Data Structures
Duration: 2months
College Name: IIT Madras
Funny Moments: Receiving the offer letter from HR official who visited our campus :)

Software Engineer Interview Questions & Answers

Medlife user image nerella saikrishna

posted on 9 Jan 2016

Interview Questionnaire 

12 Questions

  • Q1. Insert a node in a Linked List, if a pointer to a node(it's not a head pointer) of Linked List is given.
  • Q2. What is the Time Complexity of Binary Search and it's derivation
  • Ans. 

    Binary Search has a time complexity of O(log n) and is derived from dividing the search space in half at each step.

    • Binary Search is a search algorithm that works on sorted arrays.

    • It starts by comparing the target value to the middle element of the array.

    • If the target value is smaller, the search continues on the lower half of the array.

    • If the target value is larger, the search continues on the upper half of the array.

    • T...

  • Answered by AI
  • Q3. Write code for QuickSort
  • Ans. 

    QuickSort is a sorting algorithm that uses divide and conquer approach.

    • Choose a pivot element from the array

    • Partition the array into two sub-arrays, one with elements less than the pivot and one with elements greater than the pivot

    • Recursively apply the above steps to the sub-arrays

    • Combine the sorted sub-arrays to get the final sorted array

  • Answered by AI
  • Q4. Write code for Fibonacci Series using Recursion, Iteration and Dynamic Programming
  • Ans. 

    Code for Fibonacci Series using Recursion, Iteration and Dynamic Programming

    • Recursion: Define a function that calls itself with the previous two numbers in the series as arguments

    • Iteration: Use a loop to calculate the series by adding the previous two numbers in each iteration

    • Dynamic Programming: Store the previous two numbers in variables and use them to calculate the next number in the series

  • Answered by AI
  • Q5. How to implement an operation with Stacks which will be similar to Queue
  • Ans. 

    Implementing a Queue using Stacks

    • Use two stacks to implement a queue

    • Push elements onto the first stack

    • When dequeuing, pop all elements from the first stack and push onto the second stack

    • Pop the top element from the second stack to dequeue

    • If the second stack is empty, pop all elements from the first stack and push onto the second stack

  • Answered by AI
  • Q6. Write code for MergeSort
  • Ans. 

    MergeSort is a divide and conquer algorithm that sorts an array of strings.

    • Divide the array into two halves

    • Recursively sort the two halves

    • Merge the sorted halves

  • Answered by AI
  • Q7. 2 types of detective ball puzzles
  • Q8. 25 Horses, 5 Tracks, 3 Fastest Puzzle
  • Q9. How the letters of a text are determined(Basically about OCR)
  • Q10. Write code for Insertion Sort and Selection Sort and find their time complexities and also the cases where their usage is efficient
  • Q11. Explain about Counting Sort
  • Ans. 

    Counting Sort is a sorting algorithm that sorts elements by counting the number of occurrences of each unique element.

    • Count the occurrences of each element in the array

    • Calculate the cumulative sum of the counts

    • Place each element in the sorted array based on its count and cumulative sum

    • Time complexity is O(n+k) where n is the number of elements and k is the range of input

    • Example: Sort an array of strings based on their

  • Answered by AI
  • Q12. When we type a part of a word in chrome, how is it able to show all the types of words, which are consisted of that part
  • Ans. 

    Chrome uses an algorithm to predict and suggest words based on user input.

    • Chrome's algorithm uses a combination of user history, bookmarks, and popular searches to predict and suggest words.

    • The algorithm also takes into account the frequency and recency of the user's input.

    • Chrome's suggestion feature is powered by Google's Autocomplete API, which uses machine learning to predict and suggest words.

    • The suggestions are di...

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: First Question, at the start I was not able to answer and he gave me an hint(He asked me the insertion in an array). So, I got the idea for the insertion in Linked List and was able to answer it.
Remaining questions, I was able to answer confidently.
Tips: Take your own time in answering a question and be clear over your answer before telling about the code that you have written.
If you don't know an answer for some question, just keep telling him simple cases(which are valid), so that the interviewer will sometimes try to guide you through the solution.

Round: Technical Interview
Experience: I was able to answer all the questions confidently, since I know the answers for them, But the last question was out of my scope and I explained based on my intuition and knowledge.
Tips: Take your own time in answering a question and be clear over your answer before telling about the code that you have written.
If you don't know an answer for some question, just keep telling him simple cases(which are valid), so that the interviewer will sometimes try to guide you through the solution.

Round: Technical Interview
Experience: I have given the answers for 1&2 questions with clear explanation. And the third question is again out of my scope and I explained this also based intuition.
Tips: Take your own time in answering a question and be clear over your answer before telling about the code that you have written.
If you don't know an answer for some question, just keep telling him simple cases(which are valid), so that the interviewer will sometimes try to guide you through the solution.

General Tips: Take your own time in answering a question and be clear over your answer before telling about the code that you have written.
If you don't know an answer for some question, just keep telling him simple cases(which are valid), so that the interviewer will sometimes try to guide you through the solution.
Skill Tips: Take your own time in answering a question and be clear over your answer before telling about the code that you have written.
If you don't know an answer for some question, just keep telling him simple cases(which are valid), so that the interviewer will sometimes try to guide you through the solution.
Skills: Logical Puzzles, Algorithms And DataStructures
College Name: IIT Madras
Motivation: 1. Primary Reason: Passionate about Programming and Problem solving.
2. The profile is software Engineer.
3. You can see your idea, having an impact on the society which is possible with this type of company.
4. And a good package.
Funny Moments: Nothing Really...

Skills evaluated in this interview

I applied via Approached by Company and was interviewed in Feb 2022. There were 2 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Waste of time!!!
They took 2 rounds within 2 weeks, all goes well. after that HR confirms that you cleared the round and someone will call you for a final discussion. Post that they never reply. and when you call back to HR every time he says "I will check and let you know" but never ever did it for months.
Don't waste our time if you are not serious about hiring.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Apr 2023. There were 2 interview rounds.

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 3 interview rounds.

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.

Interview experience
4
Good
Difficulty level
Easy
Process Duration
-
Result
-

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

Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

INTERVIEWS

Pharmarack Technologies

No Interviews

INTERVIEWS

Pharmarack Technologies

No Interviews

SALARIES

Simplimadly

JOBS

Elitebutlers Hospitality Solutions

No Jobs

SALARIES

Sterling Talent Solutions

INTERVIEWS

Pharmarack Technologies

10 top interview questions

JOBS

Mantras2Success Consultants

No Jobs

REVIEWS

BOLD Technology Systems

No Reviews

SALARIES

Sterling Talent Solutions

JOBS

Nukkad Shops India

No Jobs

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

Tata 1mg Interview Questions
3.6
 • 146 Interviews
CMS IT Services Interview Questions
3.1
 • 132 Interviews
PharmEasy Interview Questions
3.7
 • 80 Interviews
MedPlus Interview Questions
3.6
 • 79 Interviews
Arcesium Interview Questions
3.6
 • 78 Interviews
Practo Interview Questions
3.2
 • 74 Interviews
Mavenir Systems Interview Questions
3.5
 • 55 Interviews
Netmeds.com Interview Questions
3.6
 • 42 Interviews
View all
Pharmarack Technologies Technical Support Engineer Salary
based on 60 salaries
₹2.6 L/yr - ₹4.3 L/yr
26% 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
112 salaries
unlock blur

₹2.2 L/yr - ₹5.3 L/yr

Marketing Executive
101 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Regional Sales Manager
61 salaries
unlock blur

₹6.9 L/yr - ₹14.2 L/yr

Technical Support Engineer
60 salaries
unlock blur

₹2.6 L/yr - ₹4.3 L/yr

Technical Support Executive
38 salaries
unlock blur

₹2.2 L/yr - ₹4.1 L/yr

Explore more salaries
Compare Pharmarack Technologies with

Netmeds.com

3.6
Compare

Tata 1mg

3.6
Compare

PharmEasy

3.7
Compare

Medlife

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