Upload Button Icon Add office photos

Filter interviews by

Intelliquity Consulting Services Data Engineer Interview Questions and Answers

Updated 19 Oct 2023

Intelliquity Consulting Services Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 19 Oct 2023

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

I applied via LinkedIn and was interviewed in Sep 2023. 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 - Technical 

(3 Questions)

  • Q1. Explain about your skills and previous projects? Questions related to what you mentioned in resume.
  • Q2. Which GCP services You used in your project?
  • Ans. 

    I have used Google Cloud Storage, BigQuery, Dataflow, and Pub/Sub in my project.

    • Google Cloud Storage for storing large amounts of data

    • BigQuery for analyzing and querying data

    • Dataflow for processing and transforming data in real-time

    • Pub/Sub for messaging and event-driven systems

  • Answered by AI
  • Q3. Write SQL query to remove duplicate rows from table/
  • Ans. 

    Use SQL query with DISTINCT keyword to remove duplicate rows from a table.

    • Use SELECT DISTINCT * FROM table_name;

    • Identify the columns that should be used to determine duplicates and include them in the query.

    • Consider using GROUP BY clause if needed to remove duplicates based on specific columns.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Basic introduction. Salary discussion.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on what you mentioned in resume.

Skills evaluated in this interview

Interview questions from similar companies

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

Round 1 - Technical 

(1 Question)

  • Q1. 1) Optimizations techniques used while working on Spark and hive. 2) difference between partitioning and bucketing 3) How to add column in Data frame 4) Difference between cache and persistent
  • Ans. 

    Answers to questions related to Spark, Hive, and Data Frames

    • Optimization techniques in Spark and Hive include partitioning, bucketing, and caching

    • Partitioning divides data into smaller, more manageable chunks while bucketing groups data based on a specific column

    • Adding a column to a Data Frame can be done using the 'withColumn' method

    • Caching stores data in memory for faster access while persistence stores data on disk

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. All questions related to current and previous projects. What is mean by ETL Day to day responsibilities

Interview Preparation Tips

Interview preparation tips for other job seekers - Should focus on job description. The technology they have mentioned should be prepared theoretically and practically. Some common tricky questions should be prepared.

Skills evaluated in this interview

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

General mathematics, pseudo code.

Round 2 - Group Discussion 

Time: 30min
GD: lead tech concepts

Round 3 - Coding Test 

Select a primary coding language and ensure that the fundamental concepts are well understood.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

Logical reasoning 20 character

Interview Preparation Tips

Topics to prepare for Anywhere Data Analyst interview:
  • Advanced Excel SQL
Interview preparation tips for other job seekers - Aptitude test
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Normal questions are there

Round 2 - Coding Test 

Printing star pattern

Round 3 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. Family introduction
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I was interviewed in Jul 2024.

Round 1 - Aptitude Test 

Directions, sitting arrangement, blood relations, etc

Round 2 - JAM 

(2 Questions)

  • Q1. Self introduction
  • Q2. JAM about any topic that we choose
  • Ans. 

    The topic I will be discussing is the impact of artificial intelligence on the future of work.

    • AI is revolutionizing industries by automating tasks and increasing efficiency

    • Concerns about AI replacing human jobs and the need for upskilling and reskilling

    • Opportunities for new job creation in AI-related fields such as data science and machine learning

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was held by some other third party other then the Zithara. The interview went well but recruited few members only like 12 members.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Assignment 

Ask you basic input output questions and oops concepts as well as Sql theory and pattern printing or basic of dsa like convert inorder to post order expression and many things like this and aptitude questions as well .

Round 2 - HR 

(2 Questions)

  • Q1. Family background
  • Q2. Oops concepts and basic Cs fundamental

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well basic in programming input and output questions and oops or sql and pattern programming.
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
-

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

Round 1 - Coding Test 

Write a code for HTML DOM

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What programming language are you most proficient?
  • Ans. 

    I am most proficient in Java.

    • Extensive experience in developing applications using Java

    • Strong understanding of object-oriented programming principles

    • Familiarity with popular Java frameworks like Spring and Hibernate

  • Answered by AI
  • Q2. .NET, Angular and Sql Server
Round 2 - One-on-one 

(1 Question)

  • Q1. How would you design a system that needs to handle million of records
  • Ans. 

    I would design a system using scalable architecture, efficient data storage, and optimized query processing.

    • Utilize a distributed database system like Cassandra or Hadoop for storing large volumes of data

    • Implement data partitioning and sharding to distribute the data across multiple servers

    • Use indexing and caching mechanisms to optimize query performance

    • Employ load balancing techniques to evenly distribute incoming req...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Best place to learn and work

Skills evaluated in this interview

I applied via campus placement at Manipal Institute of Technology (MIT) and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Coding Test 

Coding on python programming, any language is used in in coding.

Round 2 - Technical 

(2 Questions)

  • Q1. Good ask simple question and simple program
  • Q2. Python programming string reverse the string
  • Ans. 

    Python provides a simple way to reverse a string using slicing.

    • Use slicing to reverse the string: string[::-1]

    • Assign the reversed string to a new variable or print it directly

    • Alternatively, use the reversed() function to create a reversed iterator and join it back into a string

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Study oops concepts, algorithm , logical questions , -----

Skills evaluated in this interview

Intelliquity Consulting Services Interview FAQs

How many rounds are there in Intelliquity Consulting Services Data Engineer interview?
Intelliquity Consulting Services interview process usually has 3 rounds. The most common rounds in the Intelliquity Consulting Services interview process are Resume Shortlist, Technical and HR.
How to prepare for Intelliquity Consulting Services 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 Intelliquity Consulting Services . The most common topics and skills that interviewers at Intelliquity Consulting Services expect are GCP and SQL.
What are the top questions asked in Intelliquity Consulting Services Data Engineer interview?

Some of the top questions asked at the Intelliquity Consulting Services Data Engineer interview -

  1. Which GCP services You used in your proje...read more
  2. Write SQL query to remove duplicate rows from tab...read more

Tell us how to improve this page.

Intelliquity Consulting Services Data Engineer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

2.0

Skill development

2.0

Work-life balance

3.0

Salary

1.0

Job security

1.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Software Developer
15 salaries
unlock blur

₹2.4 L/yr - ₹9.8 L/yr

Android Developer
11 salaries
unlock blur

₹3.6 L/yr - ₹9.1 L/yr

Senior Software Engineer
10 salaries
unlock blur

₹10.2 L/yr - ₹28.9 L/yr

Software Engineer
6 salaries
unlock blur

₹2 L/yr - ₹9.7 L/yr

Business Analyst
4 salaries
unlock blur

₹9 L/yr - ₹9.5 L/yr

Explore more salaries
Compare Intelliquity Consulting Services with

KPMG India

3.5
Compare

Deloitte

3.8
Compare

PwC

3.4
Compare

Ernst & Young

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