Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by kipi.ai Team. If you also belong to the team, you can get access from here

kipi.ai Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

kipi.ai Associate Solution Architect Interview Questions, Process, and Tips

Updated 3 Jun 2023

kipi.ai Associate Solution Architect Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com 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 - Technical 

(4 Questions)

  • Q1. Walk through of latest project
  • Q2. New changes in snowflake
  • Ans. 

    Snowflake has introduced new features and enhancements to improve performance and usability.

    • Snowflake introduced Snowpark, a new feature that allows users to write custom code in Java or Scala for data processing tasks.

    • They also added support for unstructured data types like JSON and Avro, making it easier to work with semi-structured data.

    • Snowflake has improved security features with the introduction of external token...

  • Answered by AI
  • Q3. What is clustering in snowflake
  • Ans. 

    Clustering in Snowflake is a feature that organizes data in a table based on one or more columns to improve query performance.

    • Clustering keys determine the order in which data is stored in Snowflake, which can help reduce the amount of data scanned during queries.

    • Clustering can be defined at the table level or at the partition level.

    • Clustering can improve query performance by reducing the amount of data that needs to b...

  • Answered by AI
  • Q4. Case study based question
Round 3 - Technical 

(4 Questions)

  • Q1. How data is stored in snowflake
  • Ans. 

    Data in Snowflake is stored in a columnar format, using a combination of micro-partitions and clustering keys.

    • Data is stored in micro-partitions, which are small, self-contained, and immutable units of storage.

    • Clustering keys are used to organize data within micro-partitions based on common values, improving query performance.

    • Snowflake uses a variant of columnar storage, storing data in columns rather than rows for eff...

  • Answered by AI
  • Q2. What is partition
  • Ans. 

    Partition is a division or splitting of a physical or logical structure into separate parts.

    • Partitioning helps in organizing data for better management and performance.

    • In computer science, partitioning can refer to dividing a hard drive into separate sections for storing data.

    • In database management, partitioning can involve splitting a large table into smaller, more manageable parts based on certain criteria.

    • Partitioni...

  • Answered by AI
  • Q3. What is clustering in snowflake
  • Ans. 

    Clustering in Snowflake is a feature that physically organizes data based on a specified column to improve query performance.

    • Clustering helps reduce the amount of data that needs to be scanned during queries by grouping related data together on disk.

    • It can improve query performance by minimizing the amount of data that needs to be read from storage.

    • Clustering keys are defined when creating a table in Snowflake, and the...

  • Answered by AI
  • Q4. Different types of data modeling techniques
  • Ans. 

    Data modeling techniques include conceptual, logical, and physical modeling.

    • Conceptual modeling focuses on high-level concepts and relationships

    • Logical modeling translates conceptual model into specific data structures

    • Physical modeling involves implementation details like tables and columns

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Generally junior person take senior level interview so be ready with what is and where is type of questions

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: It was nice set of mixed bag questions each challenging your brain to scratch more and find the trick.
Tips: Be calm in solving the questions, Practice few tricks to solve

work,time,distance,number series problem etc. quickly to help save the

time.
Duration: 20 minuntes minutes
Total Questions: 25

Round: Resume Shortlist
Experience: I think resume played a important role in selection processes.
Tips: Make it simple and HIGHLIGHT your good work and experiences.Interviewer don't have time to go through whole crap what we write so basically focus on highlighting your achievements and internships.

Round: Group Discussion
Experience: People are dying to take the opportunity and speak.You will be facing a fish market in few cases, rest it is calm and everyone is given a chance to put forward there point.
Tips: Generally u have to decide which side of the boat u want to be on.

Either go against the topic or in favor whichever you are more

comfortable with.

College Name: IIT ROORKEE

I applied via Referral and was interviewed in Nov 2018. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Core informatica. Lot of scenario based questions.
  • Q2. Very basic questions. Simple and easy.
  • Q3. Third round was very difficult. Couldn't answer one question properly. But I gave efforts
  • Q4. Get Fibonacci series in informatica
  • Ans. 

    Fibonacci series can be generated in Informatica using a recursive function.

    • Create a mapping with a recursive function

    • Use a variable port to store the previous two values

    • Use an expression transformation to generate the series

    • Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)

  • Answered by AI

Interview Preparation Tips

General Tips: Informatica prepare well. Sql queries too.
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Presentation Skills
Duration: 1-3 Months

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Object Oriented Concepts and basic list/tuple/dictionary/ datetime conversion
  • Q2. Project done in last company and how will you help Saama?

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to frame answers end to end and stick to what you have done. Don't try to exaggerate.

Interview Questionnaire 

2 Questions

  • Q1. Mostly puzzles and one case study
  • Q2. They asked me questions about my interests and hobbies

Interview Preparation Tips

Round: Test
Experience: There were three sets of question paper. We were sitting according to our roll number then question paper with rough sheet were distributed and we were allowed 1 hour to finish that. There was no negative marking.
Tips: For aptitude practice data interpretation and data sufficiency
Duration: 1 hour
Total Questions: 30

Round: Group Discussion
Duration: 15 minutes

Round: Technical Interview
Tips: Practice puzzles and case study for this round

Round: HR Interview
Tips: Be yourself

College Name: NIT Rourkela

Interview Questionnaire 

18 Questions

  • Q1. Tell me about your yourself
  • Ans. 

    I am a detail-oriented business analyst with experience in data analysis and process improvement.

    • I have a Bachelor's degree in Business Administration

    • I have worked with various stakeholders to identify business needs and requirements

    • I am proficient in SQL and Excel for data analysis

    • I have experience in process improvement and project management

    • I am a strong communicator and collaborator

  • Answered by AI
  • Q2. Tell us about your training and internships
  • Ans. 

    I have completed a business analyst certification course and have interned at a software development company.

    • Completed a business analyst certification course from XYZ Institute

    • Interned at ABC Software Development Company for 6 months

    • Worked on requirement gathering, documentation and analysis for a project

    • Assisted senior business analysts in creating project plans and reports

  • Answered by AI
  • Q3. What is the role of Instrumentation Department? (my training)
  • Ans. 

    The Instrumentation Department is responsible for designing, installing, and maintaining control systems and instruments used in industrial processes.

    • Designing and implementing control systems for industrial processes

    • Installing and maintaining instruments used in industrial processes

    • Ensuring accuracy and reliability of instruments and control systems

    • Collaborating with other departments to optimize processes and improve...

  • Answered by AI
  • Q4. Why do you want to join Affine Analytics?
  • Ans. 

    I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.

    • Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.

    • I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.

    • I am excited about the opportunity to work...

  • Answered by AI
  • Q5. Why Data anayltics? Why not a technical job in your field?
  • Ans. 

    Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.

    • Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.

    • It allows me to work with large datasets and use statistical methods to extract insights.

    • I can use my technical skills to develop and implement data models and algorithms.

    • Data analytics is a growing fi...

  • Answered by AI
  • Q6. If I keep two diodes in series will it work as a transistor? (EC branch)
  • Ans. 

    No, two diodes in series cannot work as a transistor.

    • Transistors have three terminals while diodes have two.

    • Transistors can amplify signals while diodes cannot.

    • Transistors can be used as switches while diodes cannot.

    • Diodes in series will only increase the voltage drop.

    • Transistors have different modes of operation such as common emitter, common base, and common collector.

  • Answered by AI
  • Q7. What exactly have you accomplished with the drone? (my final year project)
  • Ans. 

    I developed a drone that can detect and monitor forest fires.

    • Designed and built a drone with thermal imaging camera

    • Integrated machine learning algorithm to detect fire

    • Tested and validated the drone in a controlled forest environment

    • Presented the project at a national engineering conference

  • Answered by AI
  • Q8. How frequently do you play Badminton? (Hobby)
  • Ans. 

    I play badminton twice a week as a hobby.

    • I enjoy playing badminton as a way to stay active and relieve stress.

    • I usually play with friends or family members at a local community center.

    • I have been playing badminton for several years and have improved my skills over time.

  • Answered by AI
  • Q9. Do you have any problem working in Bangalore?
  • Ans. 

    No, I don't have any problem working in Bangalore.

    • I am familiar with the city and its culture

    • I have worked in Bangalore before and enjoyed my experience

    • I am open to new experiences and challenges

    • I am willing to adapt to the local environment and work culture

  • Answered by AI
  • Q10. Do you have any questions for us?
  • Q11. Which football club do you follow? (My answer: Real Madrid) (Que based on hobby)
  • Q12. Why is Real Madrid your favorite?
  • Ans. 

    Real Madrid is my favorite because of their rich history, success, and style of play.

    • Real Madrid has won a record 13 Champions League titles, which is a testament to their success

    • Their style of play is attractive and entertaining to watch

    • The club has a rich history and has had some of the greatest players in football history, such as Cristiano Ronaldo and Zinedine Zidane

  • Answered by AI
  • Q13. Assume you are the CEO of Flipkart. Your board has decided to go App only. What factors would you consider before making your final decision. (You have the relevant data from your website of last 7 years ...
  • Ans. 

    Factors to consider before going App only as CEO of Flipkart

    • Analyze the data from website and app to understand user behavior

    • Evaluate the impact on sales and revenue

    • Consider the potential loss of customers who prefer website over app

    • Assess the cost of developing and maintaining the app

    • Evaluate the competition and their strategies

    • Consider the impact on brand image and customer loyalty

    • Assess the feasibility of providing ...

  • Answered by AI
  • Q14. The Horse Puzzle
  • Q15. 3 Ants triangle puzzle
  • Q16. 3 Jars puzzle (Apple/Orange puzzle)
  • Q17. I have two jars of 5 litres and 3 litres. How can I measure 4 litres? (Assume: Infinite supply of water and no third jar is present)
  • Q18. A revolver with 2 bullets puzzle

Interview Preparation Tips

Round: Test
Experience: The first 10 questions were Data Interpretation type. There were around 4 to 5 logic questions. The rest were quantitative questions.
The questions were pretty basic.
Tips: The aim is to check the speed of your calculations.
Duration: 30 minutes
Total Questions: 23

Round: Group Discussion
Tips: Speak relevant points and you will be fine.
High proficiency in English is a must.
Duration: 10 minutes

Round: Puzzle Interview
Experience: The interview was great and lasted around 35-40 minutes. The interviewer gave ample amount of time to solve the questions.
To answer the questions was ofcourse important but approach to your final answer is very important as well. If you already know the answer but fail to explain the approach to the interviewer, you will get rejected.
Tips: Keep the interviewer in the loop and keep explaining him what you are thinking.
Fluent English is very important as well.

Round: HR Interview
Experience: The interviewers were very friendly and the interview lasted around 15 min.
Tips: Have one or two favorite subject/s from which you can answer any question thrown at you.
Be well versed about your final year project.
Do not put rubbish in your resume as they read the entire resume.

Skills: Enthusiasm, Projects, Proficiency In English, Logical Puzzles, Logical Thinking
College Name: NIT Surat
Funny Moments: As the HR interviewer is an alumni of my college, we had some chat about the college. This made the interview mood very light.

I applied via Campus Placement and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was asked a question on counting continuous max occurences of 1 in a string

Interview Preparation Tips

Interview preparation tips for other job seekers - Deep knowledge of programming is a must

I applied via Campus Placement and was interviewed before Jul 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Check if binary tree is balanced or not.
  • Ans. 

    Check if binary tree is balanced or not.

    • A balanced binary tree has the height of left and right subtrees differ by at most 1.

    • Recursively check the height of left and right subtrees and compare.

    • Use a helper function to calculate the height of a subtree.

    • Time complexity: O(nlogn) for a balanced tree, O(n^2) for a skewed tree.

  • Answered by AI
  • Q2. Detect loops in linked list.
  • Ans. 

    Detect loops in a linked list.

    • Use two pointers, one moving at a faster pace than the other.

    • If there is a loop, the faster pointer will eventually catch up to the slower one.

    • To detect the start of the loop, reset one pointer to the head and move both pointers at the same pace.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview experience was good, do your DS Algo questoin thoroughly.

Skills evaluated in this interview

I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Round 2 - One-on-one 

(1 Question)

  • Q1. Javascript basics, Angular react general questions depends upon profile.
Round 3 - Behavioral 

(1 Question)

  • Q1. They asked general questions related to some hectic situation faced in previous company / project..

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm . Clear your basics . That's it.

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. It was mostly puzzles.
  • Q2. One algo question invoving recursive function .

Interview Preparation Tips

Interview preparation tips for other job seekers - For freshers - prepare puzzles and basic computer science fundamentals

kipi.ai Interview FAQs

How many rounds are there in kipi.ai Associate Solution Architect interview?
kipi.ai interview process usually has 3 rounds. The most common rounds in the kipi.ai interview process are Technical and Resume Shortlist.
How to prepare for kipi.ai Associate Solution Architect interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at kipi.ai. The most common topics and skills that interviewers at kipi.ai expect are Data Warehousing, Data Analysis, Data Architecture, Data Integration and Data Modeling.
What are the top questions asked in kipi.ai Associate Solution Architect interview?

Some of the top questions asked at the kipi.ai Associate Solution Architect interview -

  1. How data is stored in snowfl...read more
  2. different types of data modeling techniq...read more
  3. What is clustering in snowfl...read more

Tell us how to improve this page.

kipi.ai Associate Solution Architect Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 49 Interviews
Cyfuture Interview Questions
3.0
 • 45 Interviews
View all
kipi.ai Associate Solution Architect Salary
based on 24 salaries
₹30 L/yr - ₹46 L/yr
68% more than the average Associate Solution Architect Salary in India
View more details

kipi.ai Associate Solution Architect Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

4.0

Salary

3.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Senior Software Engineer
164 salaries
unlock blur

₹6 L/yr - ₹17 L/yr

Lead Engineer
108 salaries
unlock blur

₹10.6 L/yr - ₹30 L/yr

Software Engineer
64 salaries
unlock blur

₹5 L/yr - ₹10 L/yr

Senior Leader Engineer
55 salaries
unlock blur

₹18.5 L/yr - ₹42 L/yr

Solution Architect
40 salaries
unlock blur

₹28 L/yr - ₹56 L/yr

Explore more salaries
Compare kipi.ai with

Medcode

4.5
Compare

Maxgen Technologies

4.5
Compare

Cyfuture

3.0
Compare

Value Point Systems

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