Upload Button Icon Add office photos

Filter interviews by

Self Employed Architect Data Analyst Interview Questions, Process, and Tips

Updated 8 Nov 2024

Self Employed Architect Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 8 Nov 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is ETL Process
  • Ans. 

    ETL process stands for Extract, Transform, Load. It is a data integration process used to collect data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.

    • Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.

    • Transform: Data is cleaned, formatted, and transformed into a consistent structure.

    • Load: Transformed data is loaded into...

  • Answered by AI
  • Q2. How to Merge two data sets
  • Ans. 

    To merge two data sets, use a common key to combine the rows from each set into a single data set.

    • Identify a common key in both data sets to merge on

    • Use a join operation (e.g. inner join, outer join) to combine the data sets based on the common key

    • Choose the appropriate join type based on the desired outcome (e.g. keep all rows from both sets, only matching rows, etc.)

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. What is data mining
  • Ans. 

    Data mining is the process of discovering patterns and relationships in large datasets.

    • Data mining involves extracting useful information from large datasets

    • It uses various techniques such as machine learning, statistics, and database systems

    • Examples include market basket analysis, clustering, and classification

  • Answered by AI
  • Q2. What is data cleaning
  • Ans. 

    Data cleaning is the process of identifying and correcting errors or inconsistencies in data to improve its quality and accuracy.

    • Removing duplicate entries

    • Correcting spelling errors

    • Handling missing values

    • Standardizing data formats

    • Identifying and removing outliers

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

(2 Questions)

  • Q1. Basic questions on our previous work experince
  • Q2. What are the charters you have worked on
Round 2 - One-on-one 

(1 Question)

  • Q1. Some technical questions on excel and sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is pretty easy
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed before Nov 2022. There were 4 interview rounds.

Round 1 - Coding Test 

Sql Coding round questions were asked

Round 2 - Technical 

(1 Question)

  • Q1. SQL coding round
Round 3 - Technical 

(1 Question)

  • Q1. Sql Coding round
Round 4 - HR 

(1 Question)

  • Q1. Basic questions salary expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Pls don’t join this company until it’s a last option
Interview experience
4
Good
Difficulty level
-
Process Duration
More than 8 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Coding Test 

Python sql coading questions with mcqa

Round 2 - Technical 

(1 Question)

  • Q1. What is Acid Properties
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic questions on our previous work experince
  • Q2. What are the charters you have worked on
Round 2 - One-on-one 

(1 Question)

  • Q1. Some technical questions on excel and sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is pretty easy
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Aug 2023. There were 4 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 - Aptitude Test 

Basic computer knowledge, English grammar

Round 3 - One-on-one 

(4 Questions)

  • Q1. Tell me about yourself Common question
  • Q2. Tell me about yourself
  • Q3. Common topic we say about that topic
  • Q4. Testing english knowledge
Round 4 - One day observation 

(1 Question)

  • Q1. Just observe how we work
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. What is bias variance tradeoff in machine learning
  • Ans. 

    Bias-variance tradeoff is the balance between underfitting and overfitting in machine learning models.

    • Bias refers to error from erroneous assumptions in the learning algorithm, leading to underfitting.

    • Variance refers to error from sensitivity to small fluctuations in the training set, leading to overfitting.

    • The tradeoff involves finding the right level of model complexity to minimize both bias and variance.

    • Regularizati...

  • Answered by AI
  • Q2. Explain your project
  • Q3. Write a SQL code to find 2nd highest salary
  • Ans. 

    SQL code to find 2nd highest salary

    • Use the MAX() function to find the highest salary

    • Use the WHERE clause to exclude the highest salary

    • Order the salaries in descending order and limit the result to 1

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about your profile
  • Q2. Past experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be crisp and to the point
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed before Nov 2022. There were 4 interview rounds.

Round 1 - Coding Test 

Sql Coding round questions were asked

Round 2 - Technical 

(1 Question)

  • Q1. SQL coding round
Round 3 - Technical 

(1 Question)

  • Q1. Sql Coding round
Round 4 - HR 

(1 Question)

  • Q1. Basic questions salary expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Pls don’t join this company until it’s a last option
Interview experience
4
Good
Difficulty level
-
Process Duration
More than 8 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Coding Test 

Python sql coading questions with mcqa

Round 2 - Technical 

(1 Question)

  • Q1. What is Acid Properties

Self Employed Architect Interview FAQs

How many rounds are there in Self Employed Architect Data Analyst interview?
Self Employed Architect interview process usually has 2 rounds. The most common rounds in the Self Employed Architect interview process are One-on-one Round.
What are the top questions asked in Self Employed Architect Data Analyst interview?

Some of the top questions asked at the Self Employed Architect Data Analyst interview -

  1. How to Merge two data s...read more
  2. What is data clean...read more
  3. What is ETL Proc...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

LivSpace Interview Questions
3.6
 • 137 Interviews
Urban Company Interview Questions
3.4
 • 133 Interviews
HomeLane Interview Questions
3.5
 • 84 Interviews
MagicBricks Interview Questions
3.2
 • 52 Interviews
Pepperfry Interview Questions
3.2
 • 31 Interviews
Quikr Interview Questions
3.8
 • 31 Interviews
99acres Interview Questions
3.8
 • 29 Interviews
Birla White Interview Questions
4.2
 • 24 Interviews
FreshToHome Interview Questions
3.5
 • 23 Interviews
View all
Architect
31 salaries
unlock blur

₹2.2 L/yr - ₹10.8 L/yr

Freelancer
9 salaries
unlock blur

₹2 L/yr - ₹8.9 L/yr

Self Owner
7 salaries
unlock blur

₹1.5 L/yr - ₹9.4 L/yr

Freelance Architect
5 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Architectural Designer
5 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Explore more salaries
Compare Self Employed Architect with

Urban Company

3.4
Compare

Houzz

4.8
Compare

LivSpace

3.6
Compare

HomeLane

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