Upload Button Icon Add office photos
Engaged Employer

i

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

Duck Creek Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Duck Creek Technologies Data Analyst Interview Questions and Answers

Updated 12 Nov 2024

Duck Creek Technologies Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 12 Nov 2024

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

C++ on an idle in front of the Interviewer

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2023. There were 4 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 - Assignment 

Tableau intensive assignment with few questions on SQL and basic Python

Round 3 - One-on-one 

(2 Questions)

  • Q1. Discussion on submitted assignment and current job role
  • Q2. What kind of analysis have you done in your current role?
Round 4 - HR 

(1 Question)

  • Q1. Basic discussion on why I am switching from my current company and salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Hackerearth problem on reversing the string & one more array question

Round 2 - Technical 

(2 Questions)

  • Q1. Reverse the string
  • Ans. 

    Reverse a given string

    • Use built-in functions like reverse() in Python

    • Iterate through the string in reverse order and append characters to a new string

    • Use stack data structure to reverse the string

  • Answered by AI
  • Q2. SQL based windowing function

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Asked about my academics and experience.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2023. There were 2 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 - Technical 

(4 Questions)

  • Q1. Find second max salary of employee by department in sql
  • Ans. 

    Find second max salary of employee by department in SQL

    • Use GROUP BY clause to group employees by department

    • Use MAX() function to find the maximum salary

    • Use subquery to find the second maximum salary

  • Answered by AI
  • Q2. Find second max salary 9f employee by department using python pandas dataframe
  • Ans. 

    Find second max salary of employee by department using pandas dataframe

    • Group the dataframe by department

    • Sort the salaries in descending order

    • Select the second highest salary for each department

  • Answered by AI
  • Q3. Python code to download file from aws s3 to local using boto3
  • Ans. 

    Python code to download file from aws s3 to local using boto3

    • Install boto3 library using pip

    • Create an S3 client using boto3

    • Use the download_file method to download the file from S3 to local

  • Answered by AI
  • Q4. Write word count program in pyspark
  • Ans. 

    A program to count the number of words in a text file using PySpark.

    • Read the text file using SparkContext

    • Split the lines into words using flatMap

    • Map each word to a tuple of (word, 1)

    • Reduce by key to count the occurrences of each word

    • Save the output to a file

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn the basics of python dataframe and SQL and pyspark

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
-
Result
Not Selected

I applied via Approached by Company and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Build ETL pipeline, Airflow, Projects
  • Ans. 

    Building ETL pipelines using Airflow for data engineering projects.

    • Define data sources and destinations

    • Design data transformation processes

    • Implement ETL workflows in Airflow

    • Schedule and monitor pipeline executions

    • Handle error handling and data quality checks

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Assignment 

Tableau intensive assignment with few questions on SQL and basic Python

Round 3 - One-on-one 

(2 Questions)

  • Q1. Discussion on submitted assignment and current job role
  • Q2. What kind of analysis have you done in your current role?
Round 4 - HR 

(1 Question)

  • Q1. Basic discussion on why I am switching from my current company and salary discussion
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Jan 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Qualification verification

Round 2 - Group Discussion 

Technology and innovation

Round 3 - HR 

(5 Questions)

  • Q1. Self introduction
  • Ans. My name subikshajayaraman Coming from Ramnujapuram village
  • Answered by Subi Subiksha
  • Q2. Family background
  • Q3. Certificate verification
  • Q4. I will complete the cooperative management
  • Q5. Thank you sir / madam

Duck Creek Technologies Interview FAQs

How many rounds are there in Duck Creek Technologies Data Analyst interview?
Duck Creek Technologies interview process usually has 1 rounds. The most common rounds in the Duck Creek Technologies interview process are Coding Test.

Tell us how to improve this page.

Duck Creek Technologies Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Globant Interview Questions
3.8
 • 172 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
AVASOFT Interview Questions
3.6
 • 147 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
Thomson Reuters Interview Questions
4.1
 • 112 Interviews
Amadeus Interview Questions
3.9
 • 107 Interviews
EbixCash Limited Interview Questions
4.0
 • 101 Interviews
SPRINKLR Interview Questions
3.0
 • 100 Interviews
View all
Associate Manager
132 salaries
unlock blur

₹9.8 L/yr - ₹26 L/yr

Senior Analyst
58 salaries
unlock blur

₹7 L/yr - ₹14.4 L/yr

Senior Software Engineer
43 salaries
unlock blur

₹7.5 L/yr - ₹21 L/yr

Manager
39 salaries
unlock blur

₹16.2 L/yr - ₹37.9 L/yr

Analyst
24 salaries
unlock blur

₹5 L/yr - ₹11 L/yr

Explore more salaries
Compare Duck Creek Technologies with

Guidewire Software

4.7
Compare

Applied Systems

3.9
Compare

Vertafore

4.1
Compare

Majesco

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