Upload Button Icon Add office photos

Filter interviews by

ConcertAI Data Engineer Interview Questions and Answers

Updated 10 May 2024

ConcertAI Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 10 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Evaluation was done based on basic SQL queries and basic python scripting knowledge. SQL was based on joins, subqueries, aggregation, analytical functions like row_number, rank, dense rank, lead, lag. Python was mainly on writing pseudocode using list, sets, dictionary, conditional and looping constructs.

Round 2 - One-on-one 

(1 Question)

  • Q1. What are the different AWS Data Analytics services used in your project and explanation for why each service was used? What are the alternate services available and why they were not used in the project? Q...
  • Ans. 

    AWS Data Analytics services used in project, alternate services, and RDBMS concepts

    • AWS Data Analytics services used: Amazon Redshift for data warehousing, Amazon EMR for big data processing, Amazon Athena for interactive querying

    • Explanation for usage: Redshift for storing and analyzing large datasets, EMR for processing and analyzing big data, Athena for ad-hoc querying

    • Alternate services not used: Amazon RDS for relati...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview in Aug 2017.

Interview Preparation Tips

Round: Group Discussion
Experience: every one put their views
Tips: just tell anything. no one listen
Duration: 5 minutes

Round: Test
Experience: online test
Tips: do those question which can be solved without usingpen paper first
Duration: 5 minutes
Total Questions: 50

Skills: Relieving Pressure

I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python data structures
  • Q2. MongoDB database algorithms
  • Ans. 

    MongoDB database algorithms are used for efficient data storage, retrieval, and processing.

    • MongoDB uses various algorithms for indexing, sharding, and aggregation.

    • Indexing algorithms include B-tree, hash, and text search indexes.

    • Sharding algorithms include range-based, hash-based, and zone-based sharding.

    • Aggregation algorithms include map-reduce and aggregation pipeline.

    • MongoDB also uses algorithms for query optimizati

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your basics

Skills evaluated in this interview

I appeared for an interview before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Da tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Get referal

Interview Questionnaire 

3 Questions

  • Q1. About my self and my experience.
  • Q2. What's the reason for leaving previous job?
  • Q3. Technical question depends on process.

I appeared for an interview in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Behavioral questions, what will you choose knowledge or money?Why?, etc . Other curricular activities that showcase your managerial skills, etc
  • Q2. Focused on projects from resume and cross questioning. Can ask you about the tools or languages related questions if you have added that to CV. Followed by guesstimates where you will have to provide detai...

Interview Preparation Tips

Round: Technical + HR Interview
Tips: It is advantageous if you have prior experience with data handling tools eg advanced EXCEL , SPSS

Data Analyst Interview Questions & Answers

TCS user image Mahuya Khan Basak

posted on 12 Nov 2017

I appeared for an interview before Nov 2016.

Interview Preparation Tips

Round: Test
Experience: Only Written
Duration: 1 hour 45 minutes
Total Questions: 100

Skills: Proficiency In English, Basic concepts of computer, Commerce background with 50%

I applied via Walk-in and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Aptitude question
  • Q2. Interview panalam questions

Interview Preparation Tips

Interview preparation tips for other job seekers - How many rounds of interview and aptitude questions models

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

Round 1 - Group Discussion 

There were atleast 200 Aaplicants in which there separation of groups into 30 applicants and names were called out and have to say more that 4 to 5 lines on any topic u want to talk about as extempore.

Round 2 - Aptitude Test 

There were quest as pharmacology, pharmaceutics, reasoning knowledge, mathematics, English section.

Round 3 - Technical 

(1 Question)

  • Q1. The questions were asked on Pharma knowledge with subjective knowledge
Round 4 - HR 

(1 Question)

  • Q1. Question were asked regarding my expectations my working flexibility ets

Interview Preparation Tips

Topics to prepare for Cognizant Data Analyst interview:
  • Pharmacovigilance
  • Clinical Trials
  • ICH - GCP Guidelines
  • Pharmacology
  • Pharmaceutics
  • Current Profile
  • Basic
Interview preparation tips for other job seekers - Please make sure you are fully prepared for the Pharmacovigilance, ICH GCP guidline, basic Pharma knowledge, subjective knowledge. Be presentable and confident.

ConcertAI Interview FAQs

How many rounds are there in ConcertAI Data Engineer interview?
ConcertAI interview process usually has 2 rounds. The most common rounds in the ConcertAI interview process are Coding Test and One-on-one Round.
How to prepare for ConcertAI Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at ConcertAI. The most common topics and skills that interviewers at ConcertAI expect are Python, Data Structures, SQL, Healthcare and NoSQL.

Tell us how to improve this page.

ConcertAI Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Data Engineer Interview Questions from Similar Companies

View all
ConcertAI Data Engineer Salary
based on 6 salaries
₹22 L/yr - ₹30 L/yr
131% more than the average Data Engineer Salary in India
View more details
Medical Data Analyst
39 salaries
unlock blur

₹4 L/yr - ₹6.4 L/yr

Clinical Data Analyst
16 salaries
unlock blur

₹4 L/yr - ₹4.5 L/yr

Data Analyst
16 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Analyst
14 salaries
unlock blur

₹4 L/yr - ₹12.9 L/yr

Senior Data Analyst
12 salaries
unlock blur

₹6.9 L/yr - ₹19.2 L/yr

Explore more salaries
Compare ConcertAI with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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