AmbitionBox
Search
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
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
Anonymous
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
- Q2. A view has millions of data, how to update one attribute and reflect the same in view?
Answered by
AI
Add your answer
Add your answer
Top trending discussions
View All
Salary Discussions, Hike & Promotions
2w
an instructional designer
Salary Negotiation Suggestions
Need suggestions on a few fronts as this is my first big switch.
1. I've a current offer in hand which is offering me 40% hike. I want a bit higher percentage. My current company hasn't started negotiations yet but I'm positive that they'd do it. Putting this aside, can I tell my new employer that my company has matched the new offer, so I want a better offer from them? If yes, how to go about it professionally?
2. I might crack another offer from another org within a week (which should be better than the one I have). Meanwhile, I'll have to accept my current offer letter within 2-3 days. If let's say, I crack the second offer, how can I turn down the first organisation?
Would really appreciate positive responses, guys
Got a question about K12 Techno Services?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.
Round 1 - Technical
(7 Questions)
- Q1. 1. Started with the Introduction? Ans; brief about yourself and previous company details along with technology used.
- Q2. 2. Explain specific role for your the current project End to End and most of the questions from previous project
- Q3. 3. Snowflake CDC process
- Q4. 4. I worked on DBT so most of the question on how to transform data, how to implement CDC process , macro's and different layers in DBT tool.
- Q5. 5. GIT related questions Ans: how Git is connected and explain how you create branch and merge the pull request etc..
- Q6. 6. Scenario based question on the data load.
- Q7. 7. Windows functions
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for PowerSchool India ETL Developer interview:
Be confident on what you explain
Got offer and I am joining.
- SQL
- DBT
- Cloud
Be confident on what you explain
Got offer and I am joining.
Interview experience
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Technical
(1 Question)
- Q1. Python coding requirements - scenario based.
Add your answer
Round 3 - Technical
(1 Question)
- Q1. Techno managerial abilities.
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be technically good. Don't overcommit.
K12 Techno Services Interview FAQs
What are the top questions asked in K12 Techno Services ETL Architect interview?
Tell us how to improve this page.
K12 Techno Services Interviews By Designations
- K12 Techno Services Business Development Manager Interview Questions
- K12 Techno Services Academic Manager Interview Questions
- K12 Techno Services Business Development Associate Interview Questions
- K12 Techno Services Curriculum Developer Interview Questions
- K12 Techno Services Sales Manager Interview Questions
- K12 Techno Services Associate Software Developer Interview Questions
- K12 Techno Services Branch Accountant Interview Questions
- K12 Techno Services Front end Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- ETL Developer Interview Questions
- Data Architect Interview Questions
- Database Architect Interview Questions
- Informatica ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- ETL Lead Interview Questions
- Oracle Database Administrator Interview Questions
- Architect Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Business Development Manager
147
salaries
|  ₹3.2 L/yr - ₹10 L/yr |
|
Operations Manager
99
salaries
| ₹4.1 L/yr - ₹15 L/yr |
|
Business Development Associate
97
salaries
| ₹3.2 L/yr - ₹5.6 L/yr |
|
Academic Manager
86
salaries
| ₹3.5 L/yr - ₹9 L/yr |
|
Assistant Manager
74
salaries
| ₹3.6 L/yr - ₹8.5 L/yr |
Explore more salaries
Compare K12 Techno Services with
BYJU'S
Compare
Educomp Solutions
Compare
MeritNation
Compare
Extramarks Education
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- K12 Techno Services Interview Questions >
- K12 Techno Services ETL Architect Interview Questions
Share an Interview