Upload Button Icon Add office photos

K12 Techno Services

Compare button icon Compare button icon Compare

Filter interviews by

K12 Techno Services ETL Architect Interview Questions and Answers

Updated 19 Feb 2021

K12 Techno Services ETL Architect Interview Experiences

1 interview found

ETL Architect Interview Questions & Answers

user image Anonymous

posted on 19 Feb 2021

Interview Questionnaire 

2 Questions

  • Q1. What are the various ways to optimize a huge and heavy table and database?
  • Ans. 

    Various ways to optimize a huge and heavy table and database

    • Partitioning the table

    • Indexing the table

    • Using materialized views

    • Optimizing queries

    • Removing unnecessary data

    • Using compression techniques

    • Upgrading hardware

    • Using database sharding

  • Answered by AI
  • Q2. A view has millions of data, how to update one attribute and reflect the same in view?

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Why should we hire you?
  • Q2. Please tell me about the machine learning projects you have done
  • Ans. 

    I have worked on several machine learning projects, including image recognition and natural language processing.

    • Developed an image recognition model using convolutional neural networks

    • Implemented a natural language processing algorithm for sentiment analysis

    • Collaborated on a recommendation system using collaborative filtering

    • Applied machine learning techniques to predict customer churn in a telecom company

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Because I feel I have the skills and expertise for the position I have applied for. Also, be honest, and if you dont know something say that you are unaware but will learn the subject in the due course of time.

Skills evaluated in this interview

I applied via Job Fair and was interviewed before Feb 2021. There were 5 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 

What is aptitude test?

Round 3 - Group Discussion 

Online study and off-line which one is better?

Round 4 - Case Study 

Someone not interested in assignments.

Round 5 - One-on-one 

(2 Questions)

  • Q1. Why you choice to join with us
  • Ans. Because write now Indias largest and most trusted education system is BYJU'S. thats why not one me everyone want to join his/her children in BYJU'S.
  • Answered Anonymously
  • Q2. What is more important to you education or money?
  • Ans. Obviously is education because educated person make money so easily and how to hold the mobey they know very well
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand what they needs to us

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They ask about how you handle the pressure and why toppr. Are you really think to complete target on this sector.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are bold to answer without having any fear. They dont cut your head. Simply they reject you. So say what you think. How you handle the pressure. Be bold and be confident that's the only thing to get the job in marketing...
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2023. There were 3 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 - Knowledge round 

(1 Question)

  • Q1. Subject knowledge
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. How will you manage in another city away from home?
Round 2 - Technical 

(1 Question)

  • Q1. What do you expect from upGrad as a employee?
Round 3 - One-on-one 

(1 Question)

  • Q1. What is the required interpersonal skills for customer support?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself?
  • Q2. Why do you wish to join this organization?
Round 2 - HR 

(2 Questions)

  • Q1. What do you know about upgrad ?
  • Q2. Describe your strength or strong points.

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Know the company's products, history, mission ,values and achievement's.
2. understand the job requirement.
3. connect with employees and get information about the working environment.
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 

Just basic maths and it was good and I think everyone can do it!!

Round 3 - HR 

(2 Questions)

  • Q1. What’s your salary expectations?
  • Q2. What made you leave your tenuous job

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself. Be happy
The process is smooth. Be confident . Have some good communication skills
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. What do you understand by the role?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Based on previous experience

K12 Techno Services Interview FAQs

What are the top questions asked in K12 Techno Services ETL Architect interview?

Some of the top questions asked at the K12 Techno Services ETL Architect interview -

  1. What are the various ways to optimize a huge and heavy table and databa...read more
  2. A view has millions of data, how to update one attribute and reflect the same i...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.2k Interviews
Whitehat jr Interview Questions
3.5
 • 305 Interviews
Unacademy Interview Questions
3.0
 • 209 Interviews
upGrad Interview Questions
3.7
 • 208 Interviews
Vedantu Interview Questions
3.3
 • 193 Interviews
NxtWave Interview Questions
3.8
 • 177 Interviews
Chegg Interview Questions
4.1
 • 155 Interviews
Simplilearn Interview Questions
3.2
 • 101 Interviews
Testbook.com Interview Questions
3.6
 • 99 Interviews
View all
Business Development Manager
157 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Manager
99 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Associate
97 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Academic Manager
86 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
74 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare K12 Techno Services with

BYJU'S

3.1
Compare

Educomp Solutions

3.5
Compare

MeritNation

3.6
Compare

Extramarks Education

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