Upload Button Icon Add office photos
Engaged Employer

i

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

Pythian Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Pythian Interview Questions and Answers

Updated 25 Sep 2024

Pythian Interview Experiences

Popular Designations

6 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Assignment 

Setup a cluster and find the bottleneck of performance.

Round 2 - Technical 

(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

  • Answered by AI

Senior Consultant Interview Questions asked at other Companies

Q1. 1. What's the use of update sets and how do you move update set from one instance to another? Once you imported the update set, what will you do? To check the customisations, You need to do open the update set and do something. What is that... read more
View answer (3)

Consultant Interview Questions & Answers

user image upendra rao moyyila

posted on 25 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - HR 

(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

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Real time DBA issues and scenarios
  • Q2. Questions on HA and Always on

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

T sql assessment and design questions

Round 3 - Technical 

(1 Question)

  • Q1. DB basics on normalization process and table design

Database Developer Interview Questions asked at other Companies

Q1. - Waterfall model - What is cursor in SQL - Normalization and denormalization - SDLC Lifecycle - Why we need SQL - Function and procedure in SQL - What are the main blocks of T-sql or Pl-sql - Column in left table is NULL and Column in righ... read more
View answer (1)

Interview Questions & Answers

user image Anonymous

posted on 5 Jul 2022

I applied via Approached by Company and was interviewed in Jan 2022. There were 4 interview rounds.

Round 1 - Aptitude Test 

Data engineering aptitude like spark, sql, Nosql, mongo,aws basic question also 2 coding question

Round 2 - HR 

(1 Question)

  • Q1. Understanding expectation after clearing test
Round 3 - Technical 

(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
Round 4 - HR 

(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

Topics to prepare for Pythian interview:
  • AWS
  • Spark
  • SQL
  • NoSQL
  • Kubernetes
  • Docker
  • cicd
Interview preparation tips for other job seekers - Try to answer things what you know confidently else skip it. Be truthful on your behavioural round.

Skills evaluated in this interview

Pythian interview questions for popular designations

 Analytics Consultant

 (1)

 Senior Consultant

 (1)

 Database Developer

 (1)

 Consultant

 (1)

 Cloud Consultant

 (1)

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Apr 2022. There were 5 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 - Coding Test 

Section-1: Aptitude - 20 Questions - 30Min
Section-2: SQL - 20 Questions - 30Min

Round 3 - Technical 

(1 Question)

  • Q1. SQL, SAP functional knowledge and Previous Work Experience related
Round 4 - Behavioral 

(1 Question)

  • Q1. SQL, Academics and Work experiences
Round 5 - HR 

(1 Question)

  • Q1. About Company, SQL, CTC discussions, Job location etc

Analytics Consultant Interview Questions asked at other Companies

Q1. What are the different types of Join used in SQL?
View answer (3)
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Feb 2022. 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 - Coding Test 

Hackerrank problem to understand problem solving ability.

Round 3 - Technical 

(1 Question)

  • Q1. Cloud based questions on migration, ingestion pipelines, data warehouse, sql.
Round 4 - Technical 

(1 Question)

  • Q1. Logical/scenario based questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a good knowledge with at least one cloud service provider (GCP / AWS / Azure).
Programming basics and logical questions (similar to aptitude).
SQL is must.
Database and data warehouse concepts.

Cloud Consultant Interview Questions asked at other Companies

Q1. how much do you know about sap and what is its uses
View answer (1)

Jobs at Pythian

View all

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Linked list question to detect cycle
  • Q2. Basic questions from JS
Round 2 - Technical 

(2 Questions)

  • Q1. Some questions related to my projects
  • Q2. Some Questions related to my past experience
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(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.

  • Answered by AI
  • 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

Interview preparation tips for other job seekers - Pleade be ready to face multiple rounds, as the company can take a new round after telling you that you are selected by saying that it is just an interaction, but it will be a complete technical interview.
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 

(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.

  • Answered by AI
  • Q2. Class, object, inheritance, polymorphism,dbms

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on pointers,work on ds, study network analysis, learn more about the job and company

Skills evaluated in this interview

Pythian Interview FAQs

How many rounds are there in Pythian interview?
Pythian interview process usually has 3-4 rounds. The most common rounds in the Pythian interview process are Technical, HR and Resume Shortlist.
How to prepare for Pythian 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 Pythian. The most common topics and skills that interviewers at Pythian expect are Python, microsoft, Recruitment, Troubleshooting and Gaming.
What are the top questions asked in Pythian interview?

Some of the top questions asked at the Pythian interview -

  1. what is star and snowflake schema with some examp...read more
  2. why use snowflake data warehouse why not redsh...read more
  3. day to day routing with agile methodol...read more

Tell us how to improve this page.

Pythian Interview Process

based on 7 interviews

Interview experience

4.6
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 797 Interviews
View all

Pythian Reviews and Ratings

based on 55 reviews

4.1/5

Rating in categories

4.3

Skill development

4.2

Work-life balance

4.2

Salary

3.6

Job security

4.1

Company culture

3.8

Promotions

4.0

Work satisfaction

Explore 55 Reviews and Ratings
Senior Cloud Engineer

Remote

3-6 Yrs

Not Disclosed

Senior SAP Basis Administrator

Bangalore / Bengaluru

2-6 Yrs

Not Disclosed

Senior SAP Basis Administrator

Hyderabad / Secunderabad

2-6 Yrs

Not Disclosed

Explore more jobs
Analytics Consultant
14 salaries
unlock blur

₹4 L/yr - ₹7 L/yr

Database Consultant
13 salaries
unlock blur

₹17 L/yr - ₹37.5 L/yr

Data Engineer
8 salaries
unlock blur

₹14.4 L/yr - ₹35 L/yr

Cloud Consultant
6 salaries
unlock blur

₹16 L/yr - ₹20 L/yr

Oracle Database Administrator
6 salaries
unlock blur

₹10 L/yr - ₹20 L/yr

Explore more salaries
Compare Pythian with

V2soft

3.7
Compare

Kastech Software Solutions Group

3.5
Compare

Eze Software

3.7
Compare

SE2 DIGITAL SERVICE LLP

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