Upload Button Icon Add office photos
Engaged Employer

i

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

ScatterPie Analytics Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

ScatterPie Analytics AWS Developer Interview Questions, Process, and Tips

Updated 26 Nov 2024

ScatterPie Analytics AWS Developer Interview Experiences

1 interview found

AWS Developer Interview Questions & Answers

user image ABHISHEK JHA

posted on 9 Nov 2024

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

I applied via LinkedIn and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Project Experience and end to end architecture
  • Ans. 

    I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.

    • Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

    • Developed applications using AWS SDKs and integrated with other AWS services.

    • Performed testing and debugging of applications on AWS infrastructure.

    • Deployed applications on AWS using CI/CD pipel...

  • Answered by AI
  • Q2. PySpark Coding question to Extract Transform & Load
  • Q3. Cost Optimization on Snowflake
  • Ans. 

    Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.

    • Utilize virtual warehouses efficiently based on workload requirements

    • Enable auto-suspend to automatically pause warehouses when not in use

    • Monitor resource usage and adjust configurations accordingly

  • Answered by AI
Round 2 - Technical 

(5 Questions)

  • Q1. Project end to end
  • Q2. How to connect to a share point database
  • Ans. 

    To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.

    • Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

    • Authenticate using OAuth tokens to access SharePoint resources securely.

    • Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

    • Ensure proper permissions are set up for the application accessing the Sha

  • Answered by AI
  • Q3. Normalization & de normalization
  • Q4. Questions on SQL Joins
  • Q5. Question to find the 2nd highest salary using window function
  • Ans. 

    Use window function to find 2nd highest salary in SQL

    • Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

    • Filter the results where the row number is 2 to get the 2nd highest salary

  • Answered by AI
Round 3 - HR 

(3 Questions)

  • Q1. Why are you looking for a job change
  • Q2. How was the experience at previous company
  • Q3. Expected CTC at Scatterpie
  • Ans. 

    Expected CTC at Scatterpie

    • Research industry standards for AWS Developer roles at Scatterpie

    • Consider your experience, skills, and qualifications

    • Factor in location, company size, and benefits package

    • Negotiate based on market trends and personal value

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It had 2 technical rounds, 30 min each and 1 HR round. Given it is a startup they have budget constraints and do not communicate well.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Oct 2021. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. This is the HR round where they will generally check the process knowledge and comma skills.
  • Q2. Process related questions. Additional skills Typing speed

Interview Preparation Tips

Interview preparation tips for other job seekers - Of you are looking for a good office to work in kolkata. You can try VRCM. The work environment is good.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Asked about projects. Quite aloberately.
  • Q2. What is authorization and authentication?
  • Ans. 

    Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.

    • Authentication confirms the identity of a user through credentials like passwords or biometrics.

    • Authorization determines the level of access a user has to resources or actions.

    • Example: Logging into a system with a username and password is authentication, while being able to view or edit specific files

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - More implementation oriented questions.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - HR 

(1 Question)

  • Q1. What is anatomy and physiology?
Round 2 - Technical 

(1 Question)

  • Q1. CPT&ICD Guidelines
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jun 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 - Aptitude Test 

It was a 45 mins online aptitude test

Round 3 - Group Discussion 

We had 2 rounds in Group discussion

Round 4 - One-on-one 

(1 Question)

  • Q1. The interviewer asked to solve the question live in a video call
Round 5 - Technical 

(1 Question)

  • Q1. The interviewer asked to explain by final year project
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. A very genric aptitude test.
Round 2 - One-on-one 

(1 Question)

  • Q1. Interview with a senior person and was based on data analysis / data interpretation. Case study -ish discussion.
Round 3 - One-on-one 

(1 Question)

  • Q1. Generic HR round
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

Simple aptitude questions

Round 2 - Group Discussion 

Online griup discussion

Round 3 - One-on-one 

(1 Question)

  • Q1. Technical regarding final year project amd stuff
Round 4 - HR 

(1 Question)

  • Q1. General HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Join this organization only of you are in desperate need of job
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

General aptitude questions

Round 2 - Group Discussion 

Any topic given on spot, and discussion was reviewed by two panelists

Round 3 - One-on-one 

(1 Question)

  • Q1. Technical one on one round, asked aptitude questions
Round 4 - One-on-one 

(1 Question)

  • Q1. HR one on one round, asked scenario based questions
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - Case Study 

1. Three case studies related to drugs and diseases.
2. Identify key insights and recommendations from a market research.

I applied via Company Website and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Wonscore test 

(1 Question)

  • Q1. 50 aps in 12 mins. All u need is active speed to answer questions
Round 2 - Aptitude Test 

All those questions were taken from gmatclub website. Try to practice those stuffs

Interview Preparation Tips

Interview preparation tips for other job seekers - They would say that they care about only the approach to solve a question but it isn't true. Literally you have to get the answers for all questions to avoid getting rejected

ScatterPie Analytics Interview FAQs

How many rounds are there in ScatterPie Analytics AWS Developer interview?
ScatterPie Analytics interview process usually has 3 rounds. The most common rounds in the ScatterPie Analytics interview process are Technical and HR.
How to prepare for ScatterPie Analytics AWS Developer 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 ScatterPie Analytics. The most common topics and skills that interviewers at ScatterPie Analytics expect are AWS, Agile, Architecting, Architecture and Cd.
What are the top questions asked in ScatterPie Analytics AWS Developer interview?

Some of the top questions asked at the ScatterPie Analytics AWS Developer interview -

  1. Question to find the 2nd highest salary using window funct...read more
  2. how to connect to a share point datab...read more
  3. Project Experience and end to end architect...read more

Tell us how to improve this page.

ScatterPie Analytics AWS Developer Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more

Interview Questions from Similar Companies

ZoomRx Interview Questions
3.1
 • 36 Interviews
Jasper Colin Interview Questions
4.1
 • 25 Interviews
Decision Point Interview Questions
3.9
 • 13 Interviews
YouGov Interview Questions
3.6
 • 9 Interviews
RELX Group Interview Questions
3.6
 • 9 Interviews
View all
Data Analyst
53 salaries
unlock blur

₹3.5 L/yr - ₹10 L/yr

Senior Data Analyst
31 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Associate Data Analyst
29 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Data Engineer
10 salaries
unlock blur

₹3.5 L/yr - ₹7.5 L/yr

Data Scientist
6 salaries
unlock blur

₹5.1 L/yr - ₹6.5 L/yr

Explore more salaries
Compare ScatterPie Analytics with

Markelytics Solutions

4.7
Compare

Jasper Colin

4.1
Compare

Cotecna Inspection India

3.6
Compare

Market Research Future Reports

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