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

Clear (1)

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

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

I applied via Recruitment Consulltant and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. The Question was based on applying statistical knowledge by providing a real life scenario of sampling and how to best choose the sample size without making it computationally expensive
  • Q2. The Question was about the domain knowledge and what are the real hurdles we face in live project while trying to pitch aftersales to a new stakeholder
Round 2 - Aptitude Test 

It happened in Mettel platfrom, where there were 3 sections like any normal test but mostly focused on the role we are applying for

Round 3 - One-on-one 

(2 Questions)

  • Q1. The question was based on the case study , where the team wants to explore the opportunity to expand the market share of drug
  • Q2. Advanced SQL functions(Data Extractions), and Data manipulations on live DB

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for the role and focus on the basics, as the most questions are based on how we develop solutions from basic rather than readily available custom solutions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Aptitude Test 

Aptitude test was on hirepro having logical,quat,verbal, technical questions

Round 3 - Technical 

(1 Question)

  • Q1. About project and basics of sql
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 May 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Three sections, DI/LR, Maths and Coding.

Round 2 - Case Study 

Market sizing study of decent difficulty

Round 3 - One-on-one 

(1 Question)

  • Q1. Questions related to cae study previously solved.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Duration 1 hr around 60 questions

I applied via Campus Placement and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Assignment 

Basic gocube test

Round 2 - One-on-one 

(1 Question)

  • Q1. Company work expectation and past experience questions

Interview Preparation Tips

Topics to prepare for Axtria Associate interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Go through ur resume and build strong profile

I applied via Recruitment Consulltant and was interviewed before Aug 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic Logical Reasoning, Maths questions

Round 2 - Technical 

(1 Question)

  • Q1. Basic sql, python, past projects, guesstimates
Round 3 - HR 

(1 Question)

  • Q1. Why Axtria? What you know about Axtria?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just prepare the basics and strong hold on your past work experience.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Round 1 Aptitude Test. They Ask Total 24 questions There are Aptitude and Verbal, One Codding question related To Sql Joins.

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude auestions were there

Round 2 - Coding Test 

In this round 14 mcq and 2 sql queries were given

Interview Preparation Tips

Interview preparation tips for other job seekers - keep going...
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Looker developer
  • Q2. Sql server
Round 2 - Technical 

(2 Questions)

  • Q1. Looker developer
  • Q2. Sql server
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

LIST OF COMPANIES

University Living Accommodation

Overview

SALARIES

QualityKiosk Technologies

INTERVIEWS

BigBasket

No Interviews

JOBS

University Living Accommodation

No Jobs

SALARIES

QualityKiosk Technologies

INTERVIEWS

Prodesk

No Interviews

INTERVIEWS

Crif Solutions

No Interviews

INTERVIEWS

PayPal

No Interviews

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

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
ZoomRx Interview Questions
3.0
 • 33 Interviews
Jasper Colin Interview Questions
4.2
 • 23 Interviews
Decision Point Interview Questions
3.9
 • 13 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
View all
Data Analyst
55 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Analyst
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Analyst
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ScatterPie Analytics with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent