AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
LeanIX Data Engineer Interview Questions and Answers
LeanIX Data Engineer Interview Experiences
1 interview found
Selected
I applied via Job Fair and was interviewed before Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Walk through on the project you had worked on as a data engineer in azure environment.
- Ans.
Developed a data pipeline in Azure for real-time analytics on customer behavior.
Designed and implemented data ingestion process using Azure Data Factory
Utilized Azure Databricks for data transformation and analysis
Implemented Azure SQL Database for storing processed data
Developed Power BI dashboards for visualization of insights
- Q2. Scenario based question on SQL and Azure data factory
(2 Questions)
- Q1. Understanding on different schema like star and snowflake schema, Dimension and fact table.
- Q2. Questions on Advance SQL
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.
Basic Aptitude (prob, )
(1 Question)
- Q1. Basic sql and exel
(1 Question)
- Q1. Tell me about your self
2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).
(1 Question)
- Q1. 1 easy coding and design problem on how would you design a web app like book my show.
Interview Preparation Tips
Coding test with simple questions, related to the role
Interview Preparation Tips
I appeared for an interview in Apr 2020.
Interview Questionnaire
4 Questions
- Q1. Explain the most challenging problem you faced at work
- Q2. Given the following design - A university has colleges, colleges have departments, departments have students. There are department level elections being held where students nominate themselves to stand fo...
- Ans.
Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.
Use a relational database like MySQL or PostgreSQL
Create tables for colleges, departments, students, and elections
Use foreign keys to establish relationships between tables
Add columns for election details like candidate names and vote counts
Write a query to join tables and filter for maximum vot
- Q3. Explain how you would design a bit.ly URL shortening service. What would be the choice of database. What would be your table design what would be the endpoints
- Ans.
Design a bit.ly URL shortening service with database choice, table design, and endpoints.
Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.
Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.
Endpoints should include URL shortening, redirection, and analytics.
Implement caching to improve performance and reduce database load...
- Q4. Coding test - knapsack problem, 2 sum problem, alien language problem. All from leetcode.
Interview Preparation Tips
Read or watch system design questions explained on Youtube.
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.
It was a simple case study with a regression problem
(4 Questions)
- Q1. The interview was focused on basics of data analytics and python.
- Q2. What is the imp stw in data analytics?
- Ans.
The importance of data analytics lies in its ability to help organizations make informed decisions, identify trends, and improve overall performance.
Data analytics helps organizations make data-driven decisions
It allows businesses to identify trends and patterns in data
Data analytics can improve operational efficiency and performance
It enables organizations to gain insights and make predictions based on data
Data analyt...
- Q3. What is rank and dense rank
- Ans.
Rank and dense rank are functions used in SQL to assign a rank to each row based on a specified column.
Rank function assigns a unique rank to each distinct row based on the specified column.
Dense rank function assigns a unique rank to each distinct row based on the specified column, but does not leave gaps between ranks.
Example: If we have a table of students with their scores, using rank function will assign ranks lik...
- Q4. Advanced excel formulas were asked
Skills evaluated in this interview
They will provide you with dataset and we need to find insights from that
(1 Question)
- Q1. Why do want to join as a data analyst
- Ans.
I am passionate about uncovering insights from data and using them to drive informed decision-making.
I have a strong background in statistics and data analysis
I enjoy working with large datasets and finding patterns within them
I am excited about the opportunity to make a meaningful impact through data-driven decision-making
I am proficient in data visualization tools like Tableau and Power BI
Selected
I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.
(1 Question)
- Q1. It was basic data analyst non technical quesions
(1 Question)
- Q1. Salary Discussion
There was a data with some 6000 rows and we have to derive 5 useful insights from it
To know yourself like it was a kind of OPQ
(1 Question)
- Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
(1 Question)
- Q1. It was a discussion with CEO of company
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Sciflare Technologies Private Limited
Anonymous
posted on 18 Oct 2023
Database realted task
(1 Question)
- Q1. Oops concept ,kotlin related question
(1 Question)
- Q1. What is your strength and weakness
LeanIX Interview FAQs
Some of the top questions asked at the LeanIX Data Engineer interview -
Tell us how to improve this page.
LeanIX Interviews By Designations
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
LeanIX Data Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Research Analyst
11
salaries
|  ₹5.1 L/yr - ₹5.8 L/yr |
|
Senior Research Analyst
5
salaries
| ₹7 L/yr - ₹9 L/yr |
|
Salesforce Developer
5
salaries
| ₹6 L/yr - ₹11 L/yr |
|
Software Engineer
4
salaries
| ₹13.5 L/yr - ₹15 L/yr |
|
Engineering Manager
3
salaries
| ₹31 L/yr - ₹45 L/yr |
GrapplTech
Rialtes Technologies
Wilco Source
TraviYo
- Home >
- Interviews >
- LeanIX Interview Questions >
- LeanIX Data Engineer Interview Questions
