Upload Button Icon Add office photos

Pyramid IT Consulting

Compare button icon Compare button icon Compare

Filter interviews by

Pyramid IT Consulting Data Engineer Interview Questions and Answers for Freshers

Updated 11 Jul 2024

Pyramid IT Consulting Data Engineer Interview Experiences for Freshers

1 interview found

Data Engineer Interview Questions & Answers

user image Siva Tirri

posted on 11 Jul 2024

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

(2 Questions)

  • Q1. Create datafram, create new column, find the consucutive user id by date
  • Ans. 

    Create dataframe, add new column, find consecutive user IDs by date

    • Create a dataframe with user IDs and dates

    • Add a new column to calculate the difference in dates for each user ID

    • Identify consecutive user IDs based on the date difference

  • Answered by AI
  • Q2. Azure, dalta tables,
Round 2 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Why do you want to switch

Interview questions from similar companies

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

Interview Questionnaire 

1 Question

  • Q1. How to get daily updated data to my email?
  • Ans. 

    To get daily updated data to your email, you can use automated scripts or tools that fetch the data and send it to your email address.

    • Use a programming language like Python to write a script that fetches the data from a source and sends it to your email using SMTP.

    • Utilize APIs provided by the data source to retrieve the data and then use an email service's API to send it to your email address.

    • Use third-party tools like...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. If you don't know anything, straight forward tell them.

Skills evaluated in this interview

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

Interview Questionnaire 

3 Questions

  • Q1. React basic
  • Q2. Javascript ES6 features.
  • Q3. Redux work flow.
  • Ans. 

    Redux is a predictable state container for JavaScript apps.

    • Actions are dispatched to the store

    • Reducers update the state based on the action

    • Components subscribe to the store to get updated state

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy interview

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Quick introduction, followed by previous work experience.
  • Q2. SQL joins, constraints, aggregate functions, analytic functions, stored procedures and functions, cursors, triggers, views, indexes, common table expression, temporary tables, materialized views.
  • Q3. Python datatypes, functions, simple programs to code, methods, exception handling.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and composed. Be confident in answering all questions. If you fail to answer some question, find out its answer later. Explain things clearly.
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Practical questions on Tableau

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover scenario based questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(1 Question)

  • Q1. General discussion
Round 2 - Technical 

(1 Question)

  • Q1. Complete overview of technology you are working
Round 3 - Technical 

(1 Question)

  • Q1. Client interview

Interview Preparation Tips

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

I applied via Approached by Company and was interviewed before Sep 2022. There were 2 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. Related to Power Sector
  • Ans. Power cycle piping. Erection sequence of Boiler primary and secondary structure. T&P required at time of starting work.
  • Answered Anonymously
  • Q2. Related to Erection planning
  • Q3. How much manpower required to complete the plan
  • Ans. 

    The manpower required to complete a plan depends on the scope, complexity, and timeline of the project.

    • Manpower requirements can vary based on the size and complexity of the project.

    • Consider the skills and expertise needed for each task in the plan.

    • Factor in the timeline and deadlines for completing the plan.

    • Utilize project management tools to estimate manpower needs accurately.

    • Example: A large-scale construction proje...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Start your carrier and And get experience of MNC
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

General text and communication

Round 2 - Coding Test 

Sap data sql python excel ms office

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

I applied via Job Portal and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Joins and null value handling
  • Q2. Tableau server in depth
  • Ans. 

    Tableau Server is a business intelligence tool that allows organizations to share and collaborate on data visualizations.

    • Tableau Server is a platform for sharing and distributing Tableau workbooks and dashboards.

    • It allows users to access and interact with visualizations through a web browser.

    • Administrators can manage permissions, schedules, and data sources on Tableau Server.

    • Tableau Server can be integrated with other ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep learning

Skills evaluated in this interview

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 - HR 

(2 Questions)

  • Q1. Basic details like as previous employment, academic
  • Q2. Discussion about salary
Round 3 - Technical 

(2 Questions)

  • Q1. How to make box segment
  • Ans. 

    A box segment can be made by cutting a box into two parts along one of its faces.

    • Choose a face of the box to cut along

    • Use a saw or knife to cut through the box along the chosen face

    • Sand the edges of the cut to smooth them out if necessary

  • Answered by AI
  • Q2. Different Question about major bridge

Interview Preparation Tips

Interview preparation tips for other job seekers - Enhance your current experience,focus on what are you doing,dont get out of your way

Pyramid IT Consulting Interview FAQs

How many rounds are there in Pyramid IT Consulting Data Engineer interview for freshers?
Pyramid IT Consulting interview process for freshers usually has 2 rounds. The most common rounds in the Pyramid IT Consulting interview process for freshers are Technical and HR.
How to prepare for Pyramid IT Consulting Data Engineer interview for freshers?
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 Pyramid IT Consulting. The most common topics and skills that interviewers at Pyramid IT Consulting expect are Python, SCALA, SQL, Docker and Kubernetes.
What are the top questions asked in Pyramid IT Consulting Data Engineer interview for freshers?

Some of the top questions asked at the Pyramid IT Consulting Data Engineer interview for freshers -

  1. Create datafram, create new column, find the consucutive user id by d...read more
  2. Azure, dalta tabl...read more

Tell us how to improve this page.

Pyramid IT Consulting Data Engineer Interview Process for Freshers

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Randstad Interview Questions
3.7
 • 271 Interviews
Team Lease Interview Questions
3.9
 • 210 Interviews
LanceSoft Interview Questions
3.1
 • 58 Interviews
PeopleStrong Interview Questions
3.4
 • 52 Interviews
CIEL HR Interview Questions
3.9
 • 52 Interviews
IMS People Interview Questions
3.5
 • 37 Interviews
IMPACT Infotech Interview Questions
3.4
 • 37 Interviews
View all
Pyramid IT Consulting Data Engineer Salary
based on 4 salaries
₹5 L/yr - ₹9.5 L/yr
38% less than the average Data Engineer Salary in India
View more details

Pyramid IT Consulting Data Engineer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Senior Executive Resourcing
118 salaries
unlock blur

₹3.5 L/yr - ₹11.6 L/yr

Executive Resourcing
113 salaries
unlock blur

₹2.3 L/yr - ₹7.6 L/yr

Information Technology Recruiter
60 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Senior Software Engineer
59 salaries
unlock blur

₹7.6 L/yr - ₹23.1 L/yr

Technical Lead
55 salaries
unlock blur

₹14 L/yr - ₹30.9 L/yr

Explore more salaries
Compare Pyramid IT Consulting with

Randstad

3.7
Compare

Team Lease

3.9
Compare

Innovsource Services

3.9
Compare

IMPACT Infotech

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