Tredence Analytics interview experience Real time questions & tips from candidates to crack your interview

Senior Software Engineer

Tredence Analytics
upvote
share-icon
4 rounds | 7 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 3 months
Topics: SQL, Python, Azure Services: ADF, Databrucks, Synapse Analytics, Power BI, DAX
Tip
Tip

Tip 1 : Mention your Roles and Responsibilities in a project on your Resume
Tip 2 : If you are applying for Data engineer post, practice SQL(basic-advance) and python(basic) questions
Tip 3 : understand the project(s) you have worked on, this will help you in answering project related questions.

Application process
Where: Other
Eligibility: 2 year experience
Resume Tip
Resume tip

Tip 1 : mention projects with your roles and responsibilities within the project. 
Tip 2 : Do not put false experience on the resume, because you never know what questions could be asked from there
Tip 3 : mention POCs or POVs you have done previously.

Interview rounds

01
Round
Easy
Video Call
Duration45 minutes
Interview date28 May 2021
Coding problem2

Time: 5:00 PM ; You can ask for interview schedule based on your availability.
Your Introduction,
Basic SQL questions ,
DBMS properties,
SQL coding questions,
ADF basic questions ( Integrated Runtimes, pipelines etc)

1. DBMS Question

Acid Properties of DBMS

Problem approach

Tip 1 : Explain the ACID properties of DBMS

2. SQL Question

SQL cross joins having duplicate valuesbin join columns

Problem approach

Tip 1 : explain with an example
Tip 2 : prepare join questions with following scenarios as well:

Unique values
Duplicate values
Null values

02
Round
Medium
Video Call
Duration60 minutes
Interview date4 Jun 2021
Coding problem3

Timing( 5-6 pm extended till 6:30 pm)

All questions were asked on video call and screen sharing.

1. Occurrence Of Each Word

Easy
10m average time
90% success
0/40
Asked in companies
HCL TechnologiesAmazonMakeMyTrip

You are given a string S of words. Your task is to count the occurrence of each word present in the string S. A word is a sequence of one or more non-space characters, and there can be multiple spaces between two words, and also there can be leading or trailing spaces in a string S.

For Example:
For the given string  “what we think we become”

“what”,” think”, and “become” occurs 1 time, and “we” occurs 2 times in the given string.
Problem approach

First I used count function to solve this problem, later interviewer asked to solve it without using function, 
I used loop to solve it

Try solving now

2. Technical Question

Incremental data pull from a on premise datasource.

Problem approach

Tip 1 : mention about self IR 
Tip 2 : steps to configure Self IR
Tip 3 : mention about data pull steps

3. System Design Question

Azure Data Factory: 
 create an pipeline to read data from AdLS to a SQL server database.

Problem approach

Tip 1 : mention each and every step you will need to do to create the pipeline
Tip 2 : mention about IRs, linked service
Tip 3 : mention all the activity and how you would maintain schema and data quality

03
Round
Medium
Video Call
Duration45 minutes
Interview date11 Jun 2021
Coding problem1

Timing : 6PM
This round was taken by a Manager to know your expertise and interest.

Tell about yourself and explain one of the project you liked alot and reason for the same.

1. Reverse of a number

Easy
0/40
Asked in companies
SAP LabsZetaDeloitte

Write a program to generate the reverse of a given number N. Print the corresponding reverse number.

Note : If a number has trailing zeros, then its reverse will not include them. For e.g., reverse of 10400 will be 401 instead of 00401.


Try solving now
04
Round
Medium
HR Round
Duration45 minutes
Interview date16 Jun 2021
Coding problem1

Timing : 2:00 PM
Interviewer had very calm personality.
It was nice talking to him.

1. Basic HR Questions

Introduce yourself,
And there were questions like, how do you resolve team conflicts etc.
Have you ever had conflict in your team and steps you have taken to resolve those conflicts.

Problem approach

Tip 1 : Answer the questions with patience
Tip 2 : have positive mindset

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
Senior Software Engineer
4 rounds | 4 problems
Interviewed by Tredence Analytics
1049 views
0 comments
0 upvotes
Senior Software Engineer
3 rounds | 3 problems
Interviewed by Tredence Analytics
1096 views
0 comments
0 upvotes
Business Analyst
2 rounds | 10 problems
Interviewed by Tredence Analytics
1115 views
0 comments
0 upvotes
Senior Software Engineer
3 rounds | 4 problems
Interviewed by Tredence Analytics
0 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Senior Software Engineer
1 rounds | 6 problems
Interviewed by Arcesium
3734 views
0 comments
0 upvotes
company logo
Senior Software Engineer
3 rounds | 3 problems
Interviewed by Ernst & Young (EY)
4984 views
0 comments
0 upvotes
company logo
Senior Software Engineer
3 rounds | 3 problems
Interviewed by HCL Technologies
3014 views
3 comments
0 upvotes