AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Skewb Analytics Data Engineer Interview Questions, Process, and Tips
Skewb Analytics Data Engineer Interview Experiences
1 interview found
Prakash Khatri
Selected
I applied via Masia Placement Portal and was interviewed before Oct 2023. There was 1 interview round.
(6 Questions)
- Q1. Introduce to the CTO
- Q2. Share the projects created, and asked questions based on that
- Q3. How do you create calculated columns in pandas
- Ans.
Calculated columns in pandas can be created using the assign() method or by directly assigning a new column based on existing columns.
Use the assign() method to create calculated columns by specifying the new column name and the calculation formula.
Directly assign a new column by referencing existing columns and applying the desired calculation.
Example: df.assign(new_column = df['column1'] + df['column2'])
Example: df['
- Q4. How do you treat outliers in an Dataset
- Ans.
Outliers in a dataset can be treated by identifying them using statistical methods and then either removing them, transforming them, or keeping them based on the context.
Identify outliers using statistical methods like Z-score, IQR, or visualization techniques like box plots.
Decide whether to remove outliers, transform them using techniques like winsorization or log transformation, or keep them based on the context of ...
- Q5. What is an Normal Distribution in an Dataset
- Ans.
A normal distribution in a dataset is a bell-shaped curve where the data is symmetrically distributed around the mean.
Data is evenly distributed around the mean
68% of data falls within one standard deviation of the mean
95% of data falls within two standard deviations of the mean
Examples: heights of people, test scores in a class
- Q6. Given in an example how to treat different categorised values based on their frequency.
- Ans.
Treating categorised values based on frequency involves grouping rare values together.
Identify rare values based on their frequency distribution
Group rare values together to reduce complexity
Consider creating a separate category for rare values
Interview Preparation Tips
- Advanced Excel
- pandas
- Python
- SQL
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
Interview Preparation Tips
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.
Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.
Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P
General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore
I was interviewed in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Views on their recruiting process
- Ans.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
Interview Preparation Tips
Experience:
I applied via Job Portal and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic js concepts
Interview Preparation Tips
I applied via LinkedIn and was interviewed in May 2021. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Questions on the data structure and algorithms
- Q2. Questions on the database like MySQL and Cassandra
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
SQL test has been conducted nearer to 12-15 questions.
(2 Questions)
- Q1. Normal discussion, about salary negotiation
- Q2. Asked about my past company experience
Interview Preparation Tips
They have lots of opportunities.....................
(1 Question)
- Q1. NLP based question
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It was a 3 hour test with 144 questions
(1 Question)
- Q1. Why did you select this company?
I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.
Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question
Easy
50% went to next round
(3 Questions)
- Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
- Q2. Difference between UNION and UNION ALL
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the results of two or more SELECT statements and removes duplicates.
UNION ALL merges the results of two or more SELECT statements without removing duplicates.
UNION is slower as it has to remove duplicates, while UNION ALL is faster.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column...
- Q3. Types of SQL commands
- Ans.
SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
SELECT: retrieves data from a database
INSERT: adds new records to a table
UPDATE: modifies existing records in a table
DELETE: removes records from a table
CREATE: creates a new table, view, or index
DROP: deletes a table or index
(1 Question)
- Q1. Common HR questions
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.
Online platform,
SQL coding
(1 Question)
- Q1. In a one-on-one technical round, all they will ask around your resume
(1 Question)
- Q1. Basic HR question on salary and personal backgroung
Skewb Analytics Interview FAQs
Recently Viewed
JOBS
Browse jobs
Discover jobs you love
COMPANY BENEFITS
KNR Constructions
20 benefits
COMPANY BENEFITS
IRB Infrastructure
60 benefits
COMPANY BENEFITS
Dilip Buildcon
304 benefits
COMPANY BENEFITS
Dilip Buildcon
304 benefits
SALARIES
Technip Energies
INTERVIEWS
Fujitsu
No Interviews
INTERVIEWS
Skewb Analytics
No Interviews
INTERVIEWS
YASH Technologies
No Interviews
INTERVIEWS
Hopscotch
No Interviews
Tell us how to improve this page.
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
Skewb Analytics Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Skewb Analytics Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Skewb Analytics Interview Questions >
- Skewb Analytics Data Engineer Interview Questions
