KFintech Senior Data Engineer Interview Questions and Answers

Q1. It was a 1.5 hours if pure technical round based on python, shell scripting and SQL.
Add your answer

Q1. Question on python and shell scripting but tough from 1st round
Add your answer

Q1. This is will be techno managerial round and they will ask about project details ans technical questions on deep big data technologies.
Add your answer

Q1. This is also same as 3rd round with tough questions.
Add your answer

Q1. This was a round arranged specially for me for just rejecting purpose.
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Q1. Angular structure
Add your answer
Q2. Dependency injection
Add your answer

Q1. Manageral questions
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Package discussion
Add your answer

Aptitude, electronics

Q1. Transformer and power supply
Add your answer
Q2. What is a pointer
Ans. 
A pointer is a variable that stores the memory address of another variable.
• Pointers are used to access and manipulate memory locations directly.

• They are commonly used in programming languages like C and C++.

• Example: int *ptr; // declares a pointer to an integer variable
Answered by AI
Add your answer

Q1. What all thinks happen on powering on a device.
Ans. 
When a device is powered on, several processes occur including booting up the operating system, initializing hardware components, loading necessary drivers, and launching user interface.
• Booting up the operating system

• Initializing hardware components

• Loading necessary drivers

• Launching user interface
Answered by AI
Add your answer

Q1. Questions based on selected track.
Add your answer

The programming languages available for coding were determined by the chosen track (AI-ML in my case), which included Python and Java. Two coding challenges centered on array and string manipulation, with difficulty levels categorized as easy and medium.

Q1. Total of 13 questions. No interviewer. AI based Interview. Questions included Technical questions , a coding question and HR questions as well.
Add your answer

Focus on logical reasoning, quantitative analysis, and verbal reasoning.

Two questions were given that pertained to arrays and strings. It is advisable to practice more with array and string manipulation.

It was an elimination round, and the assigned topic was ChatGPT. We discussed it for 30 minutes.

Q1. Can you introduce yourself, and what do you know about the company?
Add your answer
Q2. Data analysis-related questions were asked during the interview
Add your answer

Q1. Explain about the project
Ans. 
Developed a machine learning model to predict customer churn for a telecom company
• Used historical customer data to train the model

• Implemented various classification algorithms such as logistic regression, random forest, and XGBoost

• Evaluated model performance using metrics like accuracy, precision, recall, and F1 score
Answered by AI
Add your answer
Q2. Basic SQLQuestions
Add your answer

Q1. Intermediate level SQL questions
Add your answer
Q2. Intermediate level python/machine learning questions
Add your answer