Stats Perform Support Engineer Interview Questions and Answers

Initially first was HackerRank assessment then first round was of DSA. Asked 3 questions
1) Find max sum of substrings of length k
2) Find whether 2 strings are anagram or not
3) There is a Array and Find the max sum of subsequence. If you take element index at 1 in array then you are not suppose to take element index at 0 & 2 -> I solved it with Recursion then applied DP.

Cracked Round 1.

This was a machine coding round where I have to create 3 API of Cricbuzz feature.
1) Post API which will take Match Details and we have to create points table like we have in IPL
2) Get API to fetch Point table based on total Points
3) Get API to fetch last 3 matchs of a team and there results.

This was Code review round. Interviewer first asked about my project in my current company and multiple questions like hiw many team member and how many juniors u are handling. Then we move to code review and he checked extensibility of code by asking if I have to add year wise point table then How will you add then If there are many Tournament then how you will implement.

Hackerrank test on dsa and some mcq questions

Machine coding round on some Cricbuzz functionality

Q1. Techinical interview on machine coding
Add your answer

Q1. Say about yourself
Add your answer

Q1. Introducing your self
Add your answer
Q2. Aptitude test
Add your answer

Q1. What is remote backend in terraform
Ans. 
Remote backend in Terraform is a method of storing Terraform state files in a remote location instead of locally.
• Remote backend allows for collaboration and sharing of infrastructure state files among team members.

• It provides a centralized location for storing and managing Terraform state files, reducing the risk of file corruption or loss.

• Popular remote backends include Amazon S3, Azure Blob Storage, and HashiCorp Ter...read more
Answered by AI
Add your answer
Q2. How to lock statefile
Ans. 
Statefile can be locked using state locking mechanisms to prevent concurrent access and ensure consistency.
• Use state locking mechanisms provided by the infrastructure as code tool being used (e.g. Terraform state locking)

• Implement locking strategies such as DynamoDB locking, Consul locking, or file-based locking

• Ensure only one user or process can modify the statefile at a time to prevent conflicts
Answered by AI
Add your answer

Q1. Questions related to your domain.
Add your answer
Q2. Behavioral Questions
Ans. 
I faced a challenge in a group project, where communication issues arose, but we overcame them through collaboration and active listening.
• Identified communication breakdowns in the team.

• Organized a meeting to address concerns and encourage open dialogue.

• Implemented regular check-ins to ensure everyone was on the same page.

• Learned the importance of active listening and valuing each member's input.

• Resulted in a successfu...read more
Answered by AI
Add your answer

Q1. Project related questions
Ans. 
Discussing project-related questions helps assess a candidate's analytical and problem-solving skills.
• Define project scope and objectives clearly to avoid scope creep.

• Use data analysis tools like Excel or SQL to gather insights.

• Engage stakeholders regularly for feedback and alignment.

• Example: In a previous project, I used stakeholder interviews to refine requirements.
Answered by AI
Add your answer
Q2. Domain related questions
Add your answer

HACKERANK CODING TEST

Q1. BASIC STUFF ABOUT DBMS, OOPS, SYSTEM DESIGN
Add your answer

MACHINE LEARNING - HAD TO DESIGN ONE OF CRICBUZZ FEATURE