AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Pythian
Compare
Filter interviews by
Pythian Interview Questions and Answers
Pythian Interview Experiences
6 interviews found
Anonymous
Selected
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
Setup a cluster and find the bottleneck of performance.
(1 Question)
- Q1. Ways to deal with latency in Cassandra
- Ans.
Ways to optimize latency in Cassandra
Use appropriate data modeling to reduce the number of queries needed
Optimize queries by using appropriate indexes and clustering keys
Tune the Cassandra configuration settings for better performance
Use caching mechanisms like Memcached or Redis to reduce latency
Consider using partitioning strategies to distribute data evenly across nodes
Senior Consultant Interview Questions asked at other Companies
upendra rao moyyila
Selected
I applied via Instahyre and was interviewed before Sep 2023. There were 2 interview rounds.
(1 Question)
- Q1. Reason for changing job and why should we hire you
- Ans.
Seeking new challenges and opportunities for growth. I bring a unique blend of skills and experience to add value to your team.
Looking for new challenges and opportunities for professional growth
Seeking a more dynamic work environment to utilize my skills effectively
Excited about the possibility of contributing to a new team and organization
Believe my diverse skill set and experience make me a valuable addition to your
(2 Questions)
- Q1. Real time DBA issues and scenarios
- Q2. Questions on HA and Always on
Consultant Interview Questions asked at other Companies
I applied via Job Portal and was interviewed in Nov 2022. There were 3 interview rounds.
T sql assessment and design questions
(1 Question)
- Q1. DB basics on normalization process and table design
Database Developer Interview Questions asked at other Companies
I applied via Approached by Company and was interviewed in Jan 2022. There were 4 interview rounds.
Data engineering aptitude like spark, sql, Nosql, mongo,aws basic question also 2 coding question
(1 Question)
- Q1. Understanding expectation after clearing test
(6 Questions)
- Q1. In depth understanding of technical abilities like previous projects data engineering, data modelling basic questions and some scenario based questions duraton was 60-90 minutes
- Q2. What is star and snowflake schema with some examples
- Q3. Why use snowflake data warehouse why not redshift
- Q4. Current project description and cross questions
- Q5. Some sql questions by providing soe scenarios
- Q6. Python codes by giving some scenarios
(6 Questions)
- Q1. It was behavioural round and to test the stress ability
- Q2. Introduction and expectation from company
- Q3. Day to day routing with agile methodology
- Q4. Development and production support
- Q5. Prioritizing the problems
- Q6. What will you do if you will get a lot of money?
Interview Preparation Tips
- AWS
- Spark
- SQL
- NoSQL
- Kubernetes
- Docker
- cicd
Skills evaluated in this interview
Pythian interview questions for popular designations
Selected
I applied via LinkedIn and was interviewed before Apr 2022. There were 5 interview rounds.
Section-1: Aptitude - 20 Questions - 30Min
Section-2: SQL - 20 Questions - 30Min
(1 Question)
- Q1. SQL, SAP functional knowledge and Previous Work Experience related
(1 Question)
- Q1. SQL, Academics and Work experiences
(1 Question)
- Q1. About Company, SQL, CTC discussions, Job location etc
Analytics Consultant Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Feb 2022. There were 4 interview rounds.
Hackerrank problem to understand problem solving ability.
(1 Question)
- Q1. Cloud based questions on migration, ingestion pipelines, data warehouse, sql.
(1 Question)
- Q1. Logical/scenario based questions.
Interview Preparation Tips
Programming basics and logical questions (similar to aptitude).
SQL is must.
Database and data warehouse concepts.
Cloud Consultant Interview Questions asked at other Companies
Jobs at Pythian
Top trending discussions
Interview questions from similar companies
Selected
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Linked list question to detect cycle
- Q2. Basic questions from JS
(2 Questions)
- Q1. Some questions related to my projects
- Q2. Some Questions related to my past experience
Ritika
I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Map reduce filter in javascript
- Ans.
Map, reduce, and filter are higher-order functions in JavaScript used to manipulate arrays.
Map: Transforms each element in an array and returns a new array with the transformed elements.
Reduce: Reduces an array to a single value by applying a function to each element.
Filter: Creates a new array with elements that pass a certain condition.
- Q2. Exception handling
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions were mainly on the Data Structure and System Design.
Interview Preparation Tips
(2 Questions)
- Q1. What is a pointer to pointer
- Ans.
A pointer to pointer is a variable that stores the memory address of another pointer variable.
It is used to create dynamic data structures like linked lists and trees.
It allows multiple levels of indirection.
It is denoted by ** in C and C++.
Example: int **ptr;
Example: ptr = &p; where p is a pointer variable.
- Q2. Class, object, inheritance, polymorphism,dbms
Interview Preparation Tips
Skills evaluated in this interview
Pythian Interview FAQs
Tell us how to improve this page.
Pythian Interviews By Designations
Interview Questions for Popular Designations
- Associate Interview Questions
- Business Analyst Interview Questions
- Senior Engineer Interview Questions
- Sales Executive Interview Questions
- Associate Software Engineer Interview Questions
- Accountant Interview Questions
- Senior Software Engineer Interview Questions
- System Engineer Interview Questions
- Show more
Pythian Interview Process
based on 7 interviews
Interview experience
Interview Questions from Similar Companies
|
Analytics Consultant
14
salaries
|  ₹4 L/yr - ₹7 L/yr |
|
Database Consultant
13
salaries
| ₹17 L/yr - ₹37.5 L/yr |
|
Data Engineer
8
salaries
| ₹14.4 L/yr - ₹35 L/yr |
|
Cloud Consultant
6
salaries
| ₹16 L/yr - ₹20 L/yr |
|
Oracle Database Administrator
6
salaries
| ₹10 L/yr - ₹20 L/yr |
V2soft
Kastech Software Solutions Group
Eze Software
SE2 DIGITAL SERVICE LLP
- Home >
- Interviews >
- Pythian Interview Questions
