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, Process, and Tips
Top Pythian Interview Questions and Answers
- Q1. Ways to deal with latency in Cassandraasked in Senior Consultant interview
Pythian Interview Experiences
6 interviews found
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 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
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
Interview questions from similar companies
I applied via Referral
(3 Questions)
- Q1. Overall & Relevant experience in Pega
- Ans.
I have 5 years of experience working with Pega, including designing and implementing automation solutions.
Designed and implemented automation solutions using Pega platform
Worked with various Pega tools and technologies
5 years of experience in Pega development
- Q2. Current & expected salary
- Ans.
I am currently earning $80,000 and expecting a salary of $90,000.
Current salary: $80,000
Expected salary: $90,000
- Q3. Basic questions about Pega
(2 Questions)
- Q1. Introduction, basic discussion about projects, Roles & responsibilities
- Q2. Case Management, Reporting, Integrations, Security, Deployments, UI with COSMOS
(2 Questions)
- Q1. Introduction & basic discussion about previous projects & experiences
- Q2. In depth questions about advanced PEGA topics related to Case Management, Reporting, Integrations, Security, UI
Full Stack Developer Interview Questions & Answers
Sagitec Solutions
Anonymous
posted on 28 Dec 2024
I applied via Campus Placement
Basic aptitude assessment along with some theoretical components.
(1 Question)
- Q1. Basic questions in Java, SQL and React
(2 Questions)
- Q1. Project related questions
- Q2. Coding question->Reverse String(World Hello), pattern, prime number
Selected
I applied via Referral and was interviewed in Dec 2024. There were 3 interview rounds.
Given an input dataset, develop an ETL pipeline and create a view to extract information from it.
(1 Question)
- Q1. Fully based on the submitted assignment and my past experiences in data engineering.
(1 Question)
- Q1. Talk about a time you worked in a dysfunctional team
- Ans.
I worked in a dysfunctional team during a project where communication breakdowns and conflicting priorities led to missed deadlines and tension among team members.
Lack of clear communication and direction from team leaders
Different team members working on conflicting priorities
Missed deadlines and tension among team members
Lack of accountability and responsibility among team members
Senior Automation Engineer Interview Questions & Answers
Zebra Technologies
Anonymous
posted on 10 Jan 2025
(2 Questions)
- Q1. How do agile methodologies function in B2B projects?
- Ans.
Agile methodologies in B2B projects involve frequent communication, adaptability, and collaboration with stakeholders.
Agile methodologies in B2B projects prioritize customer collaboration and responding to change over following a strict plan.
Regular feedback from stakeholders helps in adjusting project scope and priorities in real-time.
Cross-functional teams work together closely to deliver incremental value to the B2B...
- Q2. What is your experience with barcode scanners?
- Ans.
I have extensive experience working with barcode scanners in various automation projects.
Implemented barcode scanning functionality in warehouse management system to track inventory
Integrated barcode scanners with automated testing tools for regression testing
Utilized barcode scanners in manufacturing processes to improve efficiency and accuracy
Pythian Interview FAQs
Tell us how to improve this page.
Pythian Interviews By Designations
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Associate Interview Questions
- Team Lead Interview Questions
- Business Analyst Interview Questions
- Senior Engineer Interview Questions
- Sales Executive Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) 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 |
|
Oracle Database Administrator
7
salaries
| ₹9 L/yr - ₹19.8 L/yr |
|
Cloud Consultant
6
salaries
| ₹16 L/yr - ₹20 L/yr |
|
Network Engineer
5
salaries
| ₹2.8 L/yr - ₹10 L/yr |
Persistent Systems
TCS
Wipro
Infosys
- Home >
- Interviews >
- Pythian Interview Questions
