Upload Button Icon Add office photos

Filter interviews by

Balfour Beatty Plc ETL Developer Interview Questions and Answers

Updated 29 Dec 2020

Balfour Beatty Plc ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Shreya Sohan

posted on 29 Dec 2020

I applied via Naukri.com and was interviewed in Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What factors do you consider for dimensional modeling?
  • Ans. 

    Dimensional modeling factors include business requirements, data granularity, and data integration.

    • Identify business requirements for the data warehouse

    • Determine the level of data granularity needed for analysis

    • Ensure data integration across multiple sources

    • Choose appropriate dimensions and hierarchies

    • Consider performance and scalability

    • Examples: time, geography, product, customer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - First interview was a technical one and they wanted to know if you are willing to upskill on the technologies that they switch to. They did not exactly ask technical questions. As per the job description they asked whether you are willing to work as per the company's culture. Second round was behavioral round where you should give real life examples and learning experience. Please go through the job description thoroughly work-by-word and ensure that you convince them that you are a best-fit for the position.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Design tinyurl system design
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is python script
  • Ans. 

    Python script is a set of instructions written in the Python programming language to automate tasks or perform specific functions.

    • Python script is a text file containing Python code.

    • It can be executed using a Python interpreter.

    • Python scripts are commonly used for automation, data analysis, web development, and more.

  • Answered by AI
  • Q2. What is your daily schedule
  • Ans. 

    My daily schedule involves coding, attending meetings, collaborating with team members, and researching new technologies.

    • Start the day by checking emails and planning tasks for the day

    • Code and debug software applications

    • Attend meetings with team members to discuss project progress

    • Collaborate with team members on coding tasks

    • Research new technologies and tools to improve development process

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in building web applications using various technologies.

    • Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

    • Proficient in backend development with Node.js and databases like MongoDB and MySQL

    • Familiar with version control systems like Git and project management tools like Jira

    • Strong problem-solving skills and ab...

  • Answered by AI
  • Q2. Tell me about your projects
  • Ans. 

    I have worked on various projects including a web application for a retail company and a mobile app for a fitness tracker.

    • Developed a web application for a retail company to manage inventory and sales

    • Created a mobile app for a fitness tracker to track workouts and calories burned

    • Implemented a chatbot for customer support in a banking application

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Quants logical vebal essay writing etc

Round 2 - Coding Test 

2 difficuty level medium.. 1 solve is enough

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude ,logical reasoning and quant aptitude

Tell us how to improve this page.

Engineer
4 salaries
unlock blur

₹4 L/yr - ₹10.5 L/yr

Senior Design Engineer
4 salaries
unlock blur

₹12.8 L/yr - ₹13 L/yr

GIS Engineer
4 salaries
unlock blur

₹4 L/yr - ₹8.8 L/yr

BIM Engineer
4 salaries
unlock blur

₹4.8 L/yr - ₹11.6 L/yr

BIM Modeller
4 salaries
unlock blur

₹3.2 L/yr - ₹7.4 L/yr

Explore more salaries
Compare Balfour Beatty Plc with

Larsen & Toubro Limited

4.0
Compare

Tata Projects

4.2
Compare

Shapoorji Pallonji Group

4.2
Compare

Hindustan Construction Company

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