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
7 interviews found
Anonymous
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
Selected
I appeared for an interview in Jun 2025, where I was asked the following questions.
- Q1. What is python provided for users
- Ans.
Python provides users with a versatile programming language for various applications, including web development, data analysis, and automation.
Easy to learn and use: Python's syntax is clear and intuitive, making it accessible for beginners. Example: 'print("Hello, World!")'.
Rich libraries and frameworks: Python has extensive libraries like NumPy for numerical computing and Django for web development.
Cross-platform com...
- Q2. What are you doing in python
- Ans.
I am developing Python applications, focusing on data analysis, web development, and automation tasks.
Building web applications using frameworks like Flask and Django.
Performing data analysis with libraries such as Pandas and NumPy.
Automating repetitive tasks using scripts and libraries like Selenium.
Creating RESTful APIs to serve data to front-end applications.
Implementing machine learning models using Scikit-learn an...
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
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
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
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
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.
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Python file handling, input,output, in a file, Sql joins, list sort in python, basics of GIS, Web service how to test
Interview Preparation Tips
Software Engineer Interview Questions & Answers
American Megatrends
R. Arockia Ratheesh Sahayaraj
posted on 6 Nov 2015
Interview Preparation Tips
Experience: Only 24 people from my campus attended the placement process of this company.The experience wasn't really good.I wasn't
short-listed for next round as my CGPA was 7.5 and need was of above 7.5 ,as they were maintaining standards.
Round: Test
Experience: 1.C aps was really tough.
2.Section 2 we had to choose either Microprocessor or Java,I preferred microprocessor . 3.Simple Questions on 8085 and 8086 instruction set was asked.
4.How much memory are there are 20 address lines,
5.Difference between SRAM and DRAM.
6.ROM is used for stack or not.
7.What are contents of Stack Pointer after PUSH and POP operation.
8.What happens after RET instruction?
9.What is CMC equivalent instruction?
Round: Test
Experience: 16 questions on Quant which are :-
Odd number in a series, Area and Volume, Games of Skill, Time and Work, Average, Trains, Boats
and Streams, Profit and Gain were asked.
If no. of handshakes is 66,find total number of People.?
A lotus in a pond doubles in size everyday,if it fills the pond on 20th day,when will be the pond would be half?
LOGICAL REASONING-
4 men are on the side of a bridge.One torch light is with them and without it they cannot cross
the bridge.The bridge can withstand only 2 people at a time.The time required by the persons are 1
min,2 mins,7 mins,10 mins respectively.Find the shortest time required by all of em to cross the
bridge.
(Answer: 17 minutes)
Round: SOFT SKILLS
Experience: scenario based questions were asked:-
1.working on a project in your company and your brother is in urgent need of a project.What will you do?
2.Your friend mails the project details to some other company.what will be you reaction?
3.Your boss allows to take your team members for a treat.Whether you choose costly one or within budget?
4.Your favorite subject in your curriculum and Why?
5.Where you would view yourself in 5 years?
6.What is a dream company in your terms?
7.Any situation were your work was criticized and what was your reaction?
Skills:
College Name: Anna University Chennai
Interview Questionnaire
1 Question
- Q1. What js difference between === and ==
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
Overall Interview Experience Rating
based on 8 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Analytics Consultant
16
salaries
|  ₹4 L/yr - ₹7 L/yr |
|
Database Consultant
11
salaries
| ₹20.6 L/yr - ₹37.5 L/yr |
|
Data Engineer
9
salaries
| ₹19.5 L/yr - ₹30.6 L/yr |
|
Oracle Database Administrator
7
salaries
| ₹11.3 L/yr - ₹20 L/yr |
|
Cloud Consultant
6
salaries
| ₹16 L/yr - ₹20 L/yr |
Pitney Bowes
Dataflow Group
Sapphire Software Solutions (India)
Sagitec Solutions
- Home >
- Interviews >
- Pythian Interview Questions
