Upload Button Icon Add office photos
Engaged Employer

i

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

ProcDNA Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ProcDNA Technical Analyst Interview Questions and Answers

Updated 13 Sep 2024

ProcDNA Technical Analyst Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

1 hour test total 60 questions

Round 2 - Case Study 

Business related case study

Round 3 - HR 

(2 Questions)

  • Q1. Your introduction
  • Ans. 

    I am a technical analyst with 5 years of experience in analyzing market trends and data to make informed investment decisions.

    • Experience in analyzing market trends and data

    • Ability to make informed investment decisions

    • Proficient in using technical analysis tools and software

  • Answered by AI
  • Q2. Your hobbies and projects
  • Ans. 

    My hobbies include coding personal projects, participating in hackathons, and learning new technologies.

    • Coding personal projects in languages like Python, JavaScript, and Java

    • Participating in hackathons to collaborate with others and solve real-world problems

    • Learning new technologies through online courses and tutorials

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - be honest
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Mar 2023. There were 5 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 Resume tips
Round 2 - Aptitude Test 

The aptitude test was standard not something out of the league of general aptitude tests.

Round 3 - Group Discussion 

Topic: AI in Healthcare

Round 4 - Case Study 

Was given a case study and asked to solve 7 questions which required to write sql queries and analyse datasets

Round 5 - Technical 

(1 Question)

  • Q1. Case study discussion and was required to write a python code to change date time format from any type of input to dd-mm-yyyy

Technical Analyst Interview Questions Asked at Other Companies

asked in Coforge
Q1. Write a program to get a employee list whose salary is greater th ... read more
Q2. Optimize the code for job scheduling written in the first round
asked in Coforge
Q3. Explain Security authentication implementation and what are the d ... read more
asked in Coforge
Q4. How did you implemented the microservices in your project, What a ... read more
asked in Coforge
Q5. How did you configure Api gateway to manage your microservices?

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Introduce yourself. Roles and Projects you were part of.
  • Q2. SQL joins, CTEs, Snowflake
  • Q3. Python libraries, data cleaning techniques

Interview Preparation Tips

Topics to prepare for IQVIA Technical Analyst interview:
  • MySQL
  • Python
  • Power Bi
Interview preparation tips for other job seekers - Basic to medium level questions were asked in SQL, Python and Power BI.

I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Tell me about yourself
  • Q2. Interest in job role
  • Q3. Previous work experience if any
  • Q4. Hobbies,interests, project details
  • Q5. Family background
  • Q6. Why should we hire you
  • Q7. How much salary you are expecting
  • Q8. Any questions you can ask

Interview Preparation Tips

Interview preparation tips for other job seekers - Be stick on to your CV and some basic subject details, company details and job details

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, BI Reporting related questions asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Good..
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Coding Test 

A question expecting the prod code with out clear instructions

Round 2 - Technical 

(1 Question)

  • Q1. Buy and Sell Stock
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Aug 2023. There were 4 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Basic chemistry
Round 3 - HR 

(1 Question)

  • Q1. General discussion
Round 4 - Technical 

(1 Question)

  • Q1. Chemistry nmr, reaction n mechanism

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. What is meant by MedDRA??
  • Ans. It is medical dictionary for regulatory activities, which is used to code the adverse events
  • Answered Anonymously
  • Q2. What is hierarchy of MedDRA?
  • Ans. 1. SOC (System Organ Class); 2. HLGT (High level group term); 3. HLT ( high level term); 4. PT (Preferred term); 5. LLT ( lower level term)
  • Answered Anonymously
  • Q3. What is dechallange and rechallange?
  • Q4. What is ADR?
  • Ans. 

    ADR stands for Alternative Dispute Resolution. It is a process of resolving disputes outside of the court system.

    • ADR includes methods such as mediation, arbitration, and negotiation.

    • It is often used as a quicker and less expensive alternative to traditional litigation.

    • ADR can be voluntary or mandatory, depending on the situation.

    • Examples of ADR include settling a divorce through mediation, resolving a business dispute ...

  • Answered by AI
  • Q5. What are the minimum criteria for valid case?
  • Ans. 

    Valid case criteria

    • The case must have a clear and specific problem or issue

    • The case must have relevant and reliable data or information

    • The case must have a logical and coherent structure

    • The case must have realistic and feasible solutions

    • The case must have potential for learning and application

    • The case must have ethical and legal considerations

    • The case must have appropriate scope and complexity

  • Answered by AI
  • Q6. When do you consider an event to be serious?
  • Q7. What do you mean by causality?
  • Ans. 

    Causality refers to the relationship between an event (the cause) and a second event (the effect), where the second event is a result of the first.

    • Causality is the principle that everything has a cause and effect.

    • It is the relationship between an action and its consequences.

    • For example, smoking causes lung cancer.

    • Causality is important in scientific research to establish cause-and-effect relationships.

    • It is also import...

  • Answered by AI
  • Q8. What is co-morbid condition

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a technical round which majorly focused on our knowledge of Pharmacovigilance, communication and knee observation towards the subject. And also focused on project we undertaken and medical terminology knowledge.

Skills evaluated in this interview

Interview Questionnaire 

7 Questions

  • Q1. Asked basic questions of sql server & ssis
  • Q2. What are views and will the alter command on table changes anything in views created? Will the values change in views, if the table values changes?
  • Ans. 

    Alter command on table affects views created on the table.

    • Views are virtual tables created from one or more tables.

    • Alter command on a table can change the structure of the table, which can affect the views created on it.

    • If the columns used in the view are altered or dropped, the view will become invalid.

    • If the data in the table is changed, the data in the view will also change accordingly.

  • Answered by AI
  • Q3. What are the data transformations in ssis? What is lookup?
  • Ans. 

    Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.

    • Lookup is used to retrieve data from a source based on a matching condition

    • It can be used to perform joins between two data sources

    • Lookup can be used to update or insert data into a destination based on a match

    • Other data transformations in SSIS include sorting, aggregating, and merging data

  • Answered by AI
  • Q4. Difference between drop, truncate & delete?
  • Ans. 

    Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.

    • Drop: removes the table and all its data permanently

    • Truncate: removes all data from the table but keeps the structure

    • Delete: removes specific rows from the table based on a condition

    • Drop and truncate cannot be rolled back, but delete can be

    • Drop and truncate reset the identity of the table, but delete does not

  • Answered by AI
  • Q5. When identity property is inserted in the table. Will the truncate or delete change the identity value? If it changes what will be the value?
  • Ans. 

    Truncate resets identity value, delete does not.

    • Truncate resets the identity value to the original seed value

    • Delete does not change the identity value

    • Example: Truncate table resets identity value to 1

    • Example: Delete from table does not change identity value

  • Answered by AI
  • Q6. What are joins and name the types? Why is self join useful?
  • Ans. 

    Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.

    • Inner join returns only the matching rows from both tables.

    • Outer join returns all rows from both tables, with null values for non-matching rows.

    • Left join returns all rows from the left table and matching rows from the right table.

    • Right join returns all rows from the right table and m...

  • Answered by AI
  • Q7. Write a query using self join to join the employees who are all managers using id in the table.
  • Ans. 

    Query to join employees who are all managers using id in the table.

    • Use self join to join the table on manager id and employee id

    • Filter the result to only include employees who are also managers

    • Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL

    • Ensure that the table has a manager_id column

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview went well. Be confident and tell exactly about your experience so that interview will be based on your experience.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Case Study 

Market research on multiple sclerosis drugs and competition

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

ProcDNA Interview FAQs

How many rounds are there in ProcDNA Technical Analyst interview?
ProcDNA interview process usually has 4 rounds. The most common rounds in the ProcDNA interview process are Aptitude Test, Case Study and HR.

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

WSP

No Interviews

INTERVIEWS

Credera

10 top interview questions

SALARIES

ePack Durables Solutions

SALARIES

ProcDNA

SALARIES

Porter

Tell us how to improve this page.

ProcDNA Technical Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

IQVIA Interview Questions
3.9
 • 464 Interviews
Biocon Limited Interview Questions
3.9
 • 152 Interviews
Webdew Interview Questions
4.5
 • 106 Interviews
HyScaler Interview Questions
4.5
 • 91 Interviews
Piramal Group Interview Questions
3.9
 • 62 Interviews
View all
Business Analyst
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Programmer Analyst
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ProcDNA with

Genotypic Technology

3.0
Compare

Mapmygenome- Genetic Testing/Counseling

3.5
Compare

Medgenome Labs

3.6
Compare

Xcelris Labs

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