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
Top trending discussions
Interview questions from similar companies
I applied via Job Portal and was interviewed before Jul 2021. There were 2 interview rounds.
Coding test in hacker rank, easy
(1 Question)
- Q1. Questions related to dbms, Computer network, basic programming language
Interview Preparation Tips
I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.
(3 Questions)
- Q1. SQL based scenario mostly windows functions
- Q2. Basic data warehouse concepts
- Q3. Basic ETL and data modelling issues
Interview Preparation Tips
- ETL
- SQL
- Data Warehousing
- Data Modeling
- Python
I have work experience on talend ETL they asked basic concepts of ETL, Data warehouse and data modelling.
Basic questions about
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. 1. Programming Logic for loops and majorly In python
- Ans.
Python has for and while loops. For loop iterates over a sequence and while loop executes a block of code while a condition is true.
For loop syntax: for variable in sequence: block of code
While loop syntax: while condition: block of code
Example: for i in range(5): print(i) will print 0 to 4
Example: while x < 5: print(x); x += 1 will print 0 to 4
- Q2. Data warehouse concept
- Q3. Cloud Concepts Aws
- Q4. SQL writing SQL query important
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed before Jun 2021. There were 5 interview rounds.
About your tech stack along with 2 Programming question basic DS Problems, and 2-3 SQL Queries moderate level.
3-4 SQL queries medium to high level and 2 programming question moderate level
Data modeling and Data warehousing questions along with SQL queries Hard level
(2 Questions)
- Q1. Create a Data model for the use case like CCD, Pizza hut and questions from that Data model
- Q2. Data Warehousing and Big data related problems Data pipelines and ETL related Question Cloud computing related questions
(1 Question)
- Q1. Techno manager round on case studies to come complex problems.
Interview Preparation Tips
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
Interview Preparation Tips
Experience: Relevant experience matters, a lot!
Round: HR Interview
Experience: Nothing specific. Just resume based.
Round: Technical Interview
Experience: 7 rounds. Across SQL, Python, Shell Script (bash), platform architectures and Amazon web services (AWS).
Tips: Prepare well - SQL and data architectures for various use cases.
Round: Behavioural Interview
Experience: On Amazons leadersh
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Design booking.com.
Interview Preparation Tips
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
20
salaries
|  ₹3 L/yr - ₹6 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
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Tranzita Systems Interview Questions
