Upload Button Icon Add office photos
Engaged Employer

i

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

ZapCom Group Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

ZapCom Group Senior QA Consultant Interview Questions and Answers for Experienced

Updated 16 Jun 2020

ZapCom Group Senior QA Consultant Interview Experiences for Experienced

1 interview found

I applied via Naukri.com and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mavens, POM, framework creation, Work done in Projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Knowledge, confidence and Work Experience on different technologies at depth helps

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics of python, project related questions
  • Q2. Basic SQL, few simple problem solving questions
Round 2 - HR 

(2 Questions)

  • Q1. Interests, hobbies ,general HR questions
  • Q2. Expected hike, salary, work timings preferred

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for basic python and sql.

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

Interview Questionnaire 

3 Questions

  • Q1. SQL window functions
  • Q2. Basic SQL queries
  • Q3. Basic Power BI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be kind and humble and don't cheat. The interview will be a cup of cake if you even have some decent experience. Just get your basic right. There won't be much scenarios and coding questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Aug 2022. 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 tips
Round 2 - Coding Test 

Test of SQL, Tableau and other skills based on your resume on Skillate

Round 3 - Technical 

(1 Question)

  • Q1. SQL and other skills technical questions
Round 4 - One-on-one 

(1 Question)

  • Q1. Manager round / 2nd technical round

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

Interview Questionnaire 

3 Questions

  • Q1. Drill Down,Drill through
  • Q2. Dax functions like date add,date diff,time Intelligence
  • Q3. Import direct query

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewer was very nice.If u are confident u can easily crack the interview

Interview Questionnaire 

2 Questions

  • Q1. Fsmo roles
  • Q2. Office 365

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

Interview Questionnaire 

5 Questions

  • Q1. Given an input string "neeraj chopra" Write Python code to get output string as "jareen arpohc".
  • Ans. 

    The Python code to get the output string as 'jareen arpohc' from the input string 'neeraj chopra' is provided.

    • Split the input string into individual words

    • Reverse each word

    • Join the reversed words with a space in between

  • Answered by AI
  • Q2. Given a list of 10 numbers. Write a code to list only even numbers out of the original list.
  • Ans. 

    Code to list even numbers from a given list of 10 numbers.

    • Loop through the list of numbers

    • Check if each number is even using the modulo operator

    • If the number is even, add it to a new list of even numbers

    • Return the new list of even numbers

  • Answered by AI
  • Q3. SQL queries using Window Functions Rank() , Dense Rank() etc
  • Q4. Reversal of string in python code
  • Ans. 

    Reversing a string in Python code

    • Use slicing to reverse the string

    • Use the built-in function 'reversed()'

    • Convert the string to a list, reverse it, and then join it back to a string

  • Answered by AI
  • Q5. SQL queries in general.

Interview Preparation Tips

Interview preparation tips for other job seekers - There is hiring surge in the company so one should go for it .
Basic Python , SQL knowledge is enough to crack the interviews.

Skills evaluated in this interview

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

I appeared for an interview before Apr 2024, where I was asked the following questions.

  • Q1. SQL joins, window functions, scenario based questions on data cleaning, data processing
  • Q2. What strategies can be employed for the optimization of ETL processes and Spark jobs?

I applied via Referral and was interviewed in Nov 2018. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Core informatica. Lot of scenario based questions.
  • Q2. Very basic questions. Simple and easy.
  • Q3. Third round was very difficult. Couldn't answer one question properly. But I gave efforts
  • Q4. Get Fibonacci series in informatica
  • Ans. 

    Fibonacci series can be generated in Informatica using a recursive function.

    • Create a mapping with a recursive function

    • Use a variable port to store the previous two values

    • Use an expression transformation to generate the series

    • Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)

  • Answered by AI

Interview Preparation Tips

General Tips: Informatica prepare well. Sql queries too.
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Presentation Skills
Duration: 1-3 Months

Skills evaluated in this interview

I applied via Company Website and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Interview based on your programming language , how good you know like java or python or scala
  • Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
  • Q3. Explain your recent project in detail
Round 2 - Technical 

(2 Questions)

  • Q1. More deep dive in your expertise technologies like Spark DAG working explain
  • Q2. How you do data validation in hive
  • Ans. 

    Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.

    • Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

    • Use regular expressions and pattern matching to validate data formats

    • Write custom scripts to perform more complex data validation tasks

    • Perform data profiling to identify potential data quality issues

    • Use data...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary , why changing job etc..
  • Q2. Your complete background of career

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your resume things strong for interview tthats it.

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 49 Interviews
IT By Design Interview Questions
3.5
 • 40 Interviews
ConsultAdd Interview Questions
3.5
 • 36 Interviews
View all
ZapCom Group Senior QA Consultant Salary
based on 4 salaries
₹12 L/yr - ₹18 L/yr
9% more than the average Senior QA Consultant Salary in India
View more details
Senior Software Engineer
61 salaries
unlock blur

₹9.5 L/yr - ₹30.5 L/yr

Software Engineer
44 salaries
unlock blur

₹5 L/yr - ₹18.5 L/yr

Associate Software Engineer
27 salaries
unlock blur

₹5 L/yr - ₹8 L/yr

Scrum Master
21 salaries
unlock blur

₹12 L/yr - ₹24 L/yr

Devops Engineer
16 salaries
unlock blur

₹6.5 L/yr - ₹15 L/yr

Explore more salaries
Compare ZapCom Group with

Saama Technologies

3.7
Compare

JoulestoWatts Business Solutions

2.9
Compare

Gigleaz

2.3
Compare

MQSYS Technologies

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