AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Tranzita Systems Interview Questions and Answers
Tranzita Systems Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Write a query to find the second highest salary from the table.
- Ans.
Query to find the second highest salary from a table
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to retrieve the second row
- Q2. You have a list and your task is to remove the duplicates item from the list without using any inbuilt function.
- Ans.
Remove duplicates from a list without using inbuilt functions
Create an empty list to store unique items
Iterate through the original list and add items to the new list if they are not already present
Return the new list with duplicates removed
(2 Questions)
- Q1. Why should we hire you?
- Ans.
I have a strong background in data engineering with proven experience in designing and implementing scalable data solutions.
I have a solid understanding of data modeling, ETL processes, and data warehousing.
I have experience working with various databases such as SQL, NoSQL, and cloud-based solutions like AWS Redshift.
I am proficient in programming languages like Python, Java, and Scala for data processing and analysis...
- Q2. Why you left your previous organization?
- Ans.
Seeking new challenges and growth opportunities.
Desire for career advancement
Looking for new challenges
Seeking better work-life balance
Relocation to a different city
Company restructuring or downsizing
Data Engineer Interview Questions asked at other Companies
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 2 interview rounds.
Development Related task.
(2 Questions)
- Q1. Data Structures questions
- Q2. Questions based on the projects.
Interview Preparation Tips
Data Engineer Interview Questions asked at other Companies
I applied via Company Website and was interviewed before Nov 2021. There were 3 interview rounds.
They mostly ask about data science related questions on Pandas
They ask List Dictionary and String related questions.
Interview Preparation Tips
Data Engineer Interview Questions asked at other Companies
Jobs at Tranzita Systems
Interview questions from similar companies
I applied via Walk-in and was interviewed before Feb 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Interview mainly asked about spark architecture.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Joined as a fresher, basic C program algo
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Feb 2022. There were 4 interview rounds.
Quants, psychological questions, basic programming and syntax along with a program to solve
Twelve members groups discussion on general topics
(2 Questions)
- Q1. Questions regarding relocation
- Q2. Tel me something interesting about yourself
- Ans.
I am an avid traveler and have visited over 20 countries.
I love exploring new cultures and experiencing different cuisines.
Some of my favorite travel destinations include Japan, Italy, and Thailand.
I enjoy documenting my travel experiences through photography and blogging.
Traveling has taught me to be adaptable and open-minded, which are valuable skills in the data engineering field.
Interview Preparation Tips
I applied via Referral and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Spark and give diff
- Q2. What is Smb join
- Ans.
Smb join is a method used to join two tables in SQL Server.
Smb join stands for Sort Merge Bucket join.
It is used when joining large tables.
It involves sorting the tables and then merging them.
It is an efficient join method for large tables with indexes.
Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column OPTION (HASH JOIN, MERGE JOIN, LOOP JOIN);
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Questions are mostly on azure concepts,SQL server, and data warehousing concepts
Selected
I applied via LinkedIn and was interviewed in Jun 2023. There were 3 interview rounds.
(2 Questions)
- Q1. Questions about GCP Services
- Q2. Bigquery questions and sql questions
(3 Questions)
- Q1. Questions about your project and resume
- Q2. Your project workflow, and your role
- Q3. Day to day activities in project
- Ans.
Day to day activities in a data engineering project involve data collection, processing, analysis, and maintenance.
Collecting and storing data from various sources
Cleaning and transforming data for analysis
Building and maintaining data pipelines
Collaborating with data scientists and analysts
Monitoring and optimizing data infrastructure
Implementing data security and privacy measures
(1 Question)
- Q1. Salary discussion and relocation questions
Selected
I applied via Campus Placement and was interviewed before Jul 2022. There were 3 interview rounds.
Java basic coding questions were asked
(5 Questions)
- Q1. General Hr questioning was being asked
- Q2. What challenges did i face in my life
- Q3. What was my previous project based on
- Q4. Willing to relocate or not
- Q5. Why did i chose this company
Interview Preparation Tips
- Java
- Core Java
Tranzita Systems Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Tranzita Systems Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Tranzita Systems Reviews and Ratings
based on 11 reviews
Rating in categories
|
Software Development Engineer
18
salaries
|  ₹2.2 L/yr - ₹5 L/yr |
|
Software Developer
12
salaries
| ₹3.5 L/yr - ₹5 L/yr |
|
Data Engineer
12
salaries
| ₹3.5 L/yr - ₹5.6 L/yr |
|
Software Development Engineer 1
10
salaries
| ₹3.5 L/yr - ₹6.2 L/yr |
|
Software Development Engineer II
9
salaries
| ₹4.8 L/yr - ₹6.2 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Tranzita Systems Interview Questions
