Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Precisely

Compare button icon Compare button icon Compare
3.8

based on 61 Reviews

Filter interviews by

Precisely Data Engineer 2 Interview Questions and Answers

Updated 18 May 2024

Precisely Data Engineer 2 Interview Experiences

Interview questions from similar companies

Big Data Engineer Interview Questions & Answers

PubMatic user image Anonymous

posted on 1 Aug 2024

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

I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Pyspark optimizations and theoretical questions
    • Add your answer
  • Q2. Find the number of pairs which sum to target.
  • Ans. 

    Count pairs in an array that sum up to a target value.

    • Iterate through the array and store the frequency of each element in a hashmap.

    • For each element, check if the difference between the target and the element exists in the hashmap.

    • Increment the count of pairs if the difference is found in the hashmap.

    • Answered by AI
    Add your answer
  • Q3. Binary search moderate problems of array ones increasing then decreasing
  • Ans. 

    Binary search can be used to solve moderate problems of arrays that are first increasing and then decreasing.

    • Use binary search to find the peak element in the array, which marks the transition from increasing to decreasing.

    • Divide the array into two parts based on the peak element and apply binary search on each part separately.

    • Handle edge cases such as when the array is strictly increasing or strictly decreasing.

    • Exampl

    • Answered by AI
    Add your answer
  • Q4. System design for a web surfing utility
  • Ans. 

    Design a system for a web surfing utility

    • Use a web crawler to gather data from websites

    • Implement a search engine to retrieve relevant information

    • Utilize a recommendation system to suggest related content

    • Include user authentication and personalized settings

    • Ensure scalability and performance for handling large amounts of data

    • Answered by AI
    Add your answer
  • Q5. Smallest subarray having given target sum
  • Ans. 

    Find the smallest subarray in an array that has a given target sum.

    • Use a sliding window approach to find the subarray with the target sum.

    • Keep track of the current sum of elements in the window and adjust the window size accordingly.

    • Start with a window of size 1 and expand it until the sum is greater than or equal to the target sum.

    • Shrink the window from the left side while updating the smallest subarray length until t

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Data Entry Operator Interview Questions & Answers

FinThrive user image Anonymous

posted on 15 Jan 2025

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

(1 Question)

  • Q1. Asked about my academics and experience.
    • Add your answer

Data Analyst Interview Questions & Answers

PubMatic user image Anonymous

posted on 8 May 2024

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

(1 Question)

  • Q1. Join, window function excel vlookup, sumif,count etc.
    • Add your answer

Data Engineer Interview Questions & Answers

Cornerstone OnDemand user image Anonymous

posted on 6 May 2023

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:
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 - 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer

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

Data Entry Operator Interview Questions & Answers

Netenrich Technologies user image Anonymous

posted on 22 Feb 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Reasonging, isssues, maths, science, socila

Round 2 - HR 

(2 Questions)

  • Q1. Challanges, issues
    • Add your answer
  • Q2. Challanges2, issues
    • Add your answer
More about working at Precisely

Precisely Interview FAQs

How many rounds are there in Precisely Data Engineer 2 interview?
Precisely interview process usually has 2 rounds. The most common rounds in the Precisely interview process are Technical and One-on-one Round.

Tell us how to improve this page.

Precisely Interviews By Designations

Interview Questions for Popular Designations

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.7
 • 221 Interviews
Tiger Analytics Interview Questions
3.6
 • 211 Interviews
Fractal Analytics Interview Questions
4.0
 • 195 Interviews
Axtria Interview Questions
3.0
 • 112 Interviews
LatentView Analytics Interview Questions
3.7
 • 62 Interviews
Agilysys Technologies India Interview Questions
3.5
 • 52 Interviews
C5i Interview Questions
4.1
 • 43 Interviews
Darwinbox Interview Questions
3.8
 • 40 Interviews
Grey Orange Interview Questions
3.2
 • 37 Interviews
Mobileum Interview Questions
3.3
 • 34 Interviews
View all
Precisely Data Engineer 2 Salary
based on 4 salaries
₹15 L/yr - ₹20 L/yr
22% less than the average Data Engineer 2 Salary in India
View more details
Precisely Salaries in India
Software Engineer
48 salaries
unlock blur

₹8 L/yr - ₹23.5 L/yr

Senior Software Engineer 2
41 salaries
unlock blur

₹17 L/yr - ₹36 L/yr

Principal Software Engineer
35 salaries
unlock blur

₹24 L/yr - ₹45.4 L/yr

Software Engineer Level 1
31 salaries
unlock blur

₹7 L/yr - ₹15 L/yr

Software Engineer2
20 salaries
unlock blur

₹11.8 L/yr - ₹32 L/yr

Explore more salaries
Compare Precisely with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview