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 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
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
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 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
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 Questionnaire
1 Question
- Q1. What is the architecture of Spark
- Ans.
Spark has a master-slave architecture with a cluster manager and worker nodes.
Spark has a driver program that communicates with a cluster manager to allocate resources and schedule tasks.
The cluster manager can be standalone, Mesos, or YARN.
Worker nodes execute tasks and store data in memory or on disk.
Spark can also utilize external data sources like Hadoop Distributed File System (HDFS) or Amazon S3.
Spark supports va...
Skills evaluated in this interview
Basic Questions on python related to strings
(2 Questions)
- Q1. What method to reduce time complexity
- Q2. Which technology will suit a particylar situation
- Ans.
Choosing the right technology depends on the specific requirements of the situation.
Consider the data size and complexity
Evaluate the processing speed and scalability
Assess the cost and availability of the technology
Take into account the skillset of the team
Examples: Hadoop for big data, Spark for real-time processing, AWS for cloud-based solutions
Interview Preparation Tips
(5 Questions)
- Q1. Tell me about your current project? Have you used any AWS services?
- Q2. Can you explain about EMR andEC2 instance?
- Ans.
EMR is a managed Hadoop framework for processing large amounts of data, while EC2 is a scalable virtual server in AWS.
EMR stands for Elastic MapReduce and is a managed Hadoop framework for processing large amounts of data.
EC2 stands for Elastic Compute Cloud and is a scalable virtual server in Amazon Web Services (AWS).
EMR allows for easy provisioning and scaling of Hadoop clusters, while EC2 provides resizable compute...
- Q3. What type of schemas did you use for your project. (Star schema, Snowflake Schema)
- Ans.
I have experience working with both Star and Snowflake schemas in my projects.
Star schema is a denormalized schema where one central fact table is connected to multiple dimension tables.
Snowflake schema is a normalized schema where dimension tables are further normalized into sub-dimension tables.
Used Star schema for simpler, smaller datasets where performance is a priority.
Used Snowflake schema for complex, larger dat...
- Q4. Have you used python, pyspark in your projects?
- Ans.
Yes, I have used Python and PySpark in my projects for data engineering tasks.
I have used Python for data manipulation, analysis, and visualization.
I have used PySpark for big data processing and distributed computing.
I have experience in writing PySpark jobs to process large datasets efficiently.
- Q5. Do you have any experience with serverless schema?
- Ans.
Yes, I have experience with serverless schema.
I have worked with AWS Lambda to build serverless applications.
I have experience using serverless frameworks like Serverless Framework or AWS SAM.
I have designed and implemented serverless architectures using services like AWS API Gateway and AWS DynamoDB.
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. What is Databricks, Internals of it, Optimization technique
- Ans.
Databricks is a unified analytics platform that provides a collaborative environment for data scientists, engineers, and analysts.
Databricks is built on top of Apache Spark, providing a unified platform for data engineering, data science, and business analytics.
Internals of Databricks include a cluster manager, job scheduler, and workspace for collaboration.
Optimization techniques in Databricks include query optimizati...
- Q2. SQL questions of joins,group by
(2 Questions)
- Q1. Scenario based azure data factory questions
- Q2. Project structres, pyspark dataframes related
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. 1. Write SQL code.for ranking based on salary 2. Pyspark code to remove duplicates 3. Power bi question to add filter
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 10 reviews
Rating in categories
|
Software Development Engineer
18
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Software Developer
12
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Engineer
12
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Development Engineer 1
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Development Engineer II
9
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Tranzita Systems Interview Questions
