AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
TransOrg Analytics Data Engineer Interview Questions and Answers
13 Interview questions
Use SQL query with window function to rank members by transaction amount in each city.
Use SQL query with PARTITION BY clause to group members by city
Use ORDER BY clause to rank members by transaction amount
Select the second highest member for each city
Broadcast Variables are read-only shared variables that are cached on each machine in a cluster for efficient data distribution.
Broadcast Variables are used to efficiently distribute large read-only datasets to all nodes in a Spark cluster.
They are useful for tasks like joining a small lookup table with a large dataset.
Broadcast variables are cached in memory on each machine to avoid unnecessary data shuffling dur...
Using self join to analyze customer behavior in an e-commerce platform.
Identifying patterns in customer purchase history
Analyzing customer preferences based on past purchases
Segmenting customers based on their buying behavior
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
1NF (First Normal Form) - Each column in a table must contain atomic values, and there should be no repeating groups.
2NF (Second Normal Form) - Table should be in 1NF and all non-key attributes are fully functional dependent on the primary key.
3NF (Third Normal Form) - Table should be in 2NF and the...
Alter is used to modify the structure of a table, while update is used to modify the data in a table.
Alter is used to add, remove, or modify columns in a table.
Update is used to change the values of existing records in a table.
Alter can change the structure of a table, such as adding a new column or changing the data type of a column.
Update is used to modify the data in a table, such as changing the value of a spe...
Map applies a function to each element in a collection and returns a new collection. Flatmap applies a function that returns a collection to each element and flattens the result.
Map transforms each element in a collection using a function and returns a new collection.
Flatmap applies a function that returns a collection to each element and flattens the result into a single collection.
Map does not flatten nested col...
A generator function is a function that can pause and resume its execution, allowing it to yield multiple values over time.
Generator functions are defined using the 'function*' syntax in JavaScript.
They use the 'yield' keyword to return values one at a time.
Generators can be iterated over using a 'for...of' loop.
They are useful for generating sequences of values lazily, improving memory efficiency.
Use left join for computationally efficient way to find customer names from customer profile and transaction tables.
Use left join to combine customer profile and transaction tables based on customer id
Left join will include all customers from profile table even if they don't have transactions
Subquery may be less efficient as it has to be executed for each row in the result set
Lambda function is a serverless computing service that runs code in response to events and automatically manages the computing resources required.
Lambda functions are event-driven and can be triggered by various AWS services such as S3, DynamoDB, API Gateway, etc.
They are written in languages like Python, Node.js, Java, etc.
Lambda functions are scalable and cost-effective as you only pay for the compute time you c...
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
Syntax: [expression for item in iterable]
Can include conditionals: [expression for item in iterable if condition]
Example: squares = [x**2 for x in range(10)]
TransOrg Analytics Data Engineer Interview Experiences
1 interview found
Anonymous
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
(15 Questions)
- Q1. Introduce your self and Explain your project?
- Q2. What is Normalization is sql and explain 1NF 2NF 3NF?
- Ans.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
1NF (First Normal Form) - Each column in a table must contain atomic values, and there should be no repeating groups.
2NF (Second Normal Form) - Table should be in 1NF and all non-key attributes are fully functional dependent on the primary key.
3NF (Third Normal Form) - Table should be in 2NF and there sh...
- Q3. What is difference between alter and update ?
- Ans.
Alter is used to modify the structure of a table, while update is used to modify the data in a table.
Alter is used to add, remove, or modify columns in a table.
Update is used to change the values of existing records in a table.
Alter can change the structure of a table, such as adding a new column or changing the data type of a column.
Update is used to modify the data in a table, such as changing the value of a specific...
- Q4. Assume We had a PAN india Retail store because of which i have customer table in backend one is customer profile table and other is customer transaction table both will linked with customer id so what will...
- Ans.
Use left join for computationally efficient way to find customer names from customer profile and transaction tables.
Use left join to combine customer profile and transaction tables based on customer id
Left join will include all customers from profile table even if they don't have transactions
Subquery may be less efficient as it has to be executed for each row in the result set
- Q5. How subquery is work on backend on the above question?
- Ans.
Subqueries are nested queries that provide intermediate results for the main query, optimizing data retrieval.
Subqueries can be used in SELECT, INSERT, UPDATE, or DELETE statements.
They are executed once for the outer query, and their results are used as input.
Example: SELECT * FROM employees WHERE department_id IN (SELECT id FROM departments WHERE location = 'New York');
Subqueries can be correlated, meaning they refer...
- Q6. Design a business case to use self join? Condition : not use hirachical usecase like teacher student employee manager father and grandfather
- Ans.
Using self join to analyze customer behavior in an e-commerce platform.
Identifying patterns in customer purchase history
Analyzing customer preferences based on past purchases
Segmenting customers based on their buying behavior
- Q7. What if you have to find out second highest transacting member in each city?
- Ans.
Use SQL query with window function to rank members by transaction amount in each city.
Use SQL query with PARTITION BY clause to group members by city
Use ORDER BY clause to rank members by transaction amount
Select the second highest member for each city
- Q8. What is Common Expression Query (CTE)?How CTE is different from Stored Procedure?
- Ans.
CTE is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. It is different from a Stored Procedure as it is only available for the duration of the query.
CTE stands for Common Table Expression and is defined using the WITH keyword.
CTEs are mainly used for recursive queries, complex joins, and simplifying complex queries.
CTEs are not stored in the database like Stored Proce...
- Q9. What is List Comprehension?
- Ans.
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
Syntax: [expression for item in iterable]
Can include conditionals: [expression for item in iterable if condition]
Example: squares = [x**2 for x in range(10)]
- Q10. Have you work on Lambda Function Explain it?
- Ans.
Lambda function is a serverless computing service that runs code in response to events and automatically manages the computing resources required.
Lambda functions are event-driven and can be triggered by various AWS services such as S3, DynamoDB, API Gateway, etc.
They are written in languages like Python, Node.js, Java, etc.
Lambda functions are scalable and cost-effective as you only pay for the compute time you consum...
- Q11. What is generator function?
- Ans.
A generator function is a function that can pause and resume its execution, allowing it to yield multiple values over time.
Generator functions are defined using the 'function*' syntax in JavaScript.
They use the 'yield' keyword to return values one at a time.
Generators can be iterated over using a 'for...of' loop.
They are useful for generating sequences of values lazily, improving memory efficiency.
- Q12. What is the Difference between Transformation and Actions in pyspark? And Give Example
- Ans.
Transformation in pyspark is lazy evaluation while Actions trigger execution of transformations.
Transformations are operations that are not executed immediately but create a plan for execution.
Actions are operations that trigger the execution of transformations and return results.
Examples of transformations include map, filter, and reduceByKey.
Examples of actions include collect, count, and saveAsTextFile.
- Q13. Difference between map and Flatmap?
- Ans.
Map applies a function to each element in a collection and returns a new collection. Flatmap applies a function that returns a collection to each element and flattens the result.
Map transforms each element in a collection using a function and returns a new collection.
Flatmap applies a function that returns a collection to each element and flattens the result into a single collection.
Map does not flatten nested collecti...
- Q14. What is Broadcast Variables?
- Ans.
Broadcast Variables are read-only shared variables that are cached on each machine in a cluster for efficient data distribution.
Broadcast Variables are used to efficiently distribute large read-only datasets to all nodes in a Spark cluster.
They are useful for tasks like joining a small lookup table with a large dataset.
Broadcast variables are cached in memory on each machine to avoid unnecessary data shuffling during c...
- Q15. Give the Case Study How you develop Dream 11 like cricket App as a team of Data Engineer ,Data Analyst ,Data Scientest ,Data Architecture and ETL Developer ?what kind of tables you have to you use for s...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Raunak Chitlangia
I applied via Campus Placement
Interview Preparation Tips
Experience: My resume had a couple of projects and a paper publication added to it, which was a part of my second year intern at TCS Innovation Labs.
Tips: I believe that the resume shortlist to appear for the test is just a formality and not a big deal to get through. Most of the students are allowed to appear for the test which is where, the main shortlisting occurs.
Although, the company does cut off people from certain departments. For example, none of the Agriculture and food engineering students were shortlisted for appearing for the test.
Also, from what I have heard, the company runs resumes through a program to take out the shortlist. Hence, certain key words such as "Scholar" or "Conference" may get you a good chance to get through the shortlisting.
Round: Test
Experience: The test is mainly quant based and how fast you can think and rationalize. They expect excellent speed; they ask you 20 questions to be answered in 30 minutes.
Tips: Normally, if a student is asked to appear for this right after his JEE examination, he would be able to get through it easily. But since our analytical thinking goes way down once we actually get in, it has to be worked upon again. I'd suggest you to solve all the quant questions of any CAT preparatory book for the American Express test. The test questions are quite similar to those that the CAT students prepare for.
Round: Technical Interview
Experience: In general, the American Express interviews are considered to be pretty peaceful compared to the interviews of other companies. I was just asked about my work at TCS Innovation Labs and the paper I would be publishing based on that work and the courses I have done in Data Analytics and what all do I know in it. They do not test the knowledge you say you possess.
Tips: While I was preparing for my interview, I was told to read about Amex and its products. Secondly, and most importantly, I was aksed to read a lot about credit card frauds and suggest ways of preventing that. Even during my time, a lot of people were asked about this and judged severely on that. This is a must must if you would be appearing for its interview.
Also, you would do well if you are able to connect with the interviewer. For instance, if both of you have been a part of the same inter IIT or have the same tastes, etc.
Also, the interviews are that peaceful that you are able to direct the interview in your favour. There are certain parts of your CV that you can easily talk about and certain parts that you would want to avoid. If you are able to think on your feet, it is easy to re direct the interview in your favour and the things that you would like to talk about; in my case, it was my work at TCS.
Round: Puzzle Interview
Experience: The main decision whether you have to be taken in or not is decided in your first round of interview after which, the puzzle interview is just a formality and to find out whether you are able to think on your feet or not. Not a big deal, pretty easy.
Tips: Nothing to be worried about, the puzzles asked are pretty easy and most probably, you would have already heard them if you have a nag of solving puzzles.
General Tips: Do not worry or stress yourself much. The interview is pretty easy if you have an edge in the skills that the company wants. I had started studying Data Analytics in my second year summer vacations, just 1 hour a day for hardly about a month. Which gave me enough of an edge. The main hurdle lies in getting through the test round where about 300 people are simply cut off.
Skill Tips: You should be able to code efficiently. Knowledge in Python and SQL is a big plus.
Also, I had done a course on Coursera called "Machine Learning" of Stanford University. Today, the company does not expect a lot of knowledge in Data Analytics from students which is why this course gave me the edge I needed to get through the interview. It's a pretty easy course and not very demanding. I would recommend this if you want to find out even whether you'd be interested in Data Analytics or not.
I was asked about the things I know and whether I have ever implemented them.
Skills: Analytics And Coding
Duration: 2
College Name: IIT Kharagpur
Motivation: American Express is known to have a good working culture and is currently the third best company to work for in India. The internship stipend is largest compared to any other company in India along with accommodation and travel. The company has a well structured internship program and also has good challenging work to offer.
Funny Moments: After the test, I was not shortlisted for the interview round.. Which broke my heart.
Just after the presentation, I walked up to the person presenting and handed him a hard copy of my resume asking him to at least give me a shot at the interview if they think my profile is good enough.
I believe that this was a turning point of this entire experience. I believe, at that moment itself, I gained their favour to take me in. Which is probably why my interview was peaceful, which is probably why I could get through even though my interview was the last among a bunch of 25 students..
I appeared for an interview in Oct 2016.
Interview Questionnaire
4 Questions
- Q1. Select any five companies you would invest in and why given the required metrics.
- Ans.
I cannot provide investment advice, but here are five companies that have shown strong financial performance in recent years.
Apple - consistently high revenue and profit margins
Amazon - dominant player in e-commerce and cloud computing
Microsoft - strong growth in cloud computing and enterprise software
Alphabet (Google) - diversified revenue streams and strong advertising business
Visa - dominant player in the payments i...
- Q2. Questions based on case study.
- Q3. Detailed discussions on the indian economy?
- Q4. Brexit vote and how it would effect the indian economy?
- Ans.
The Brexit vote could have both positive and negative effects on the Indian economy.
Positive effects: Increased trade opportunities with the UK, potential for attracting foreign investments from companies relocating from the UK.
Negative effects: Uncertainty in global markets leading to volatility in exchange rates, potential decline in exports to the UK.
Example: Indian IT companies may face challenges due to stricter i...
Interview Preparation Tips
Experience: We were first taught the basics of operations involved in working with an investment bank. Based on the workshop we were given a case study with a list of companies to select the one's which are potencial candidates for investments. We were all divided into groups of 5 students.
Round: Test
Experience: The test was basic. Economical aptitude requires prior knowledge of economics concepts. The review topicwas GST bill.
Duration: 1 hour
Total Questions: 41
Round: Stress Interview
Tips: It is important to be aware about the current events and economies.
Skills: Economic Affairs, Financial Economics, Knowledge On Current Affairs
College Name: Thapar University, Patiala
Interview Preparation Tips
Experience: There were 15 questions from quant’s, 10 questions from data interpretation with 1 mark each and -.5 for wrong answer also there were 2 case studies with 10 marks each with no –ve marks. Total 45 marks question, I did only 9 from quant and 7 from DI total 16 out of 25 questions and didn’t touch case studies. Quanta and DI were very basics level.
In those 16, 1 question was wrong so basically I did 14.5 out of 45, but with a accuracy of 90%. Didn’t expect to get shortlisted but was very tensed and angry upon myself coz it was my level paper. But around 12 mid night shortlist came and I was at 11th position out of 31 students in the list.
There were total around 90 students who appeared for written test. They allowed Mtech and Mca guys not Btech.
Total Questions: 25
Round: TECHNICAL INTERVIEW
Experience: I went there and greeted him. Firstly he told me to introduce myself, later he asked what I like the most. I told analytical thinking and logical reasoning and yeah I relate it with data base.(since I knew they came for Data analyst profile).
He asked me about join, gave me a table and told me to perform all joins. I did that and he asked me about Order by clause and, having clause then asked me normal forms up to bcnf.
Later asked about pl/sql difference b/w sql and pl/sql, what is trigger explain in detail. Some basics questions of DBMS theory asked me about my 2 projects and at the end he gave me a situation where I have a grocery shop outside nit Surathkal, and from last few days/months I realized a downfall in sales, what possible reasons could I find? I gave him 8 reasons within 2/3 mins. He was impressed…
After 1st round out of 31 only 13 were selected and I was there in d list.
Round: TECHNICAL INTERVIEW
Experience: As soon as I entered the room, mam told me “Ooo tum aao aao ”. I smiled because I was the 1st guy during presentation who asked the first question (she made every1 clap for me there) and she remembered my face. And eventually she did study from IIT Kanpur so yes she was able to speak fluent Hindi (plus point for guys like me :p). with her there was a guy he asked me to write code for taking a no and converting it into binary and 1 question from array- very simple later she gave me a table with employee id, order date and order amount. A customer can place max 1 order in 1 day. I had to find the latest transaction of every customer with amount as well. i did it using max function over date and group by with sub query, she asked me about my resume at the end she gave me 7,9,21,63,100 and told me to find the no of numbers between 1 to 50000 which are exactly divisible by all, i did it in 1 min.
but she was smiling, I thought I made some mistake in hurry, then I asked mam m I doing right or wrong (in curiosity as I find very comfortable there) she smiled and said “Chalo bhago ynha se ye interview h ”.I said sorry but yeah she was impressed with my interview so told ki “you will learn all these things very quickly”.
Round: TECHNICAL INTERVIEW
Experience: After 2nd round 9 were selected and I was one of them. It was basically a Managerial round and it scheduled over Skype. I had to introduce myself as well as my family background. Here comes the harder part when he asked me why you have such a poor academic back ground? I was speechless for a moment but I started telling the truth.
I told despite getting 68% marks in my 10th I was the third topper of my class. I got 60.66 % in 12th but yeah there also out of 700 students only 14 got first division. So basically I concluded that in my state board marking is not that much good. He said ok but what happened in graduation(64%) when you studied in Delhi?(what to say now :p) I said sir I did it from IGNOU and you can Google the fact that even less than 5% of student are able to clear the degree in 3 years. Later I explicitly mentioned that I m not blaming my boards but this is the fact which can’t be change.
Now He asked what happened in PG here also you scored only 7.50 CGPA which is less than even standard score of 8(Meri to jaan hi nikal gayi :p). Then I told him that sir u can see my pointer in first semester is very less close to 6.5 but after that I constantly improved myself. He was smiling …..
He asked me about my family background and then I told him how I struggled, I was giving tuition in my grads to continue my education and after grads took a gap of 1 year and cleared all MCA entrance examination and now sitting in front of him.
Later asked about my best qualities….i told him that I can lead group of people very well. I gave example of me being captain of my department cricket team and I was class monitor through 3rd to 12th std and also some stuff regarding my college events. He noted down something .I don’t know what.
I was not sure that I could clear that interview. When the result came they called all 9 students and said that they find is difficult to eliminate 4 names .i was sure that I m out of picture now but fortunately my name was at 2nd position. Wowwwww
Round: HR Interview
Experience: It was telephonic round and just my hobbies and all, he asked me about my poetry writing hobby as well as Hindi Shayaris. I was told to recite 1 …when he listened, he was very impressed…
College Name: IIT KANPUR
tushar
I applied via Walk-in and was interviewed before May 2021. There were 2 interview rounds.
Interview Preparation Tips
(2 Questions)
- Q1. What databases have you worked on?
- Ans.
I have worked on various databases including MySQL, Oracle, and MongoDB.
MySQL
Oracle
MongoDB
- Q2. Diferent types of join
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Write sql query
- Q2. Tell your exp it
- Ans.
I have 3 years of experience working as a Data Analyst in the finance industry.
Utilized SQL to extract and analyze data from databases
Created visualizations using Tableau to present findings to stakeholders
Performed predictive modeling using Python to forecast financial trends
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Jan 2023. There were 3 interview rounds.
Three Data model questions will be given to solve within 24 hours.
(2 Questions)
- Q1. Q1. Case study for Number of Green T-shirts sold in US?
- Ans.
A case study on the number of green T-shirts sold in the US.
Identify the target audience for green T-shirts
Analyze the market demand for green T-shirts
Study the sales data of green T-shirts in the US
Identify the popular brands and styles of green T-shirts
Analyze the impact of seasonality on sales
Consider the pricing strategy of green T-shirts
Identify potential marketing opportunities to increase sales
- Q2. Q2. SQL joins and Python simple questions
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Explain why and when Analysis of Variance (ANOVA) is used. {Question from CV, since I had mentioned the use of it before}
- Ans.
ANOVA is used to compare means across multiple groups to determine if at least one group differs significantly.
ANOVA is used when comparing three or more groups to see if their means are statistically different.
Example: Testing the effectiveness of three different diets on weight loss.
It helps in understanding the impact of categorical independent variables on a continuous dependent variable.
Example: Analyzing test sco...
- Q2. ,You want to create an index that comprises of a bunch of components. How would you choose to aggregate all the individual components? Is it context specific?
- Ans.
Choosing an aggregation method for an index depends on the components and their context, ensuring relevance and accuracy.
Identify the components: Understand what individual metrics or data points will be included in the index.
Determine the aggregation method: Common methods include sum, average, weighted average, or geometric mean.
Consider the context: The importance of each component may vary based on the specific app...
Question:
Suppose you are trying to detect if a particular credit card transaction is fraudulent or not. The credit score of the individual to which the card belongs to had a very healthy credit score. All bills were paid in time and average transaction amount was not that high ($800). The individual had not been out of the country in the last couple of decades. Here is a list of transactions:
1) Gold jwelleries worth $5000
2) Groceries worth $35
3) Second hand car worth $8,000
4) Burgers worth $10
Which transaction looks fraudulent to you?
There is no specific answer. They just want to see how you think through the problem. One can potentially make use of data in order to deal with this problem. From that, one can estimate the probability of each of these transactions being fraudulent. Econometrically, one can develop a potential binary logit model. That would involve identifying certain features that belong to individuals like the one considered above and use these features to come up with an estimate of the probability of the transaction being a fraud.
Not just that, this also needs to include not individual specific features but external features as well. For example, the first transaction might not be as fraudulent as it looks like, because in heavily regulated markets, the risk associated with reselling the gold or exchanging it for money might be high enough to disincentivise the fraudster from buying gold. Thus regulation might also be a valid feature, and different from features describing an individuals characteristics.
Ofcourse problems of overfitting would arise ifan excessive number of features are used. Various means of finding the optimal Degrees of Freedom can be employed.
Obviously one can do better with more complicated decisioning algorihms that involve machine learning models as well.
Eventually one needs to estimate at what threshold of probability will the trasaction be declared fraudulent.
Interview Preparation Tips
- Econometrics
- Statistics
- Economics
(2 Questions)
- Q1. Name one difficult situation you faced?
- Q2. Who is a business analyst?
- Ans.
A business analyst is a professional who analyzes an organization's business domain and documents its business processes or systems.
Analyzes business processes to identify areas for improvement
Works with stakeholders to gather requirements for new systems or processes
Creates documentation such as business requirements documents and process maps
Helps to bridge the gap between business stakeholders and technical teams
Use...
Interview Preparation Tips
TransOrg Analytics Interview FAQs
Some of the top questions asked at the TransOrg Analytics Data Engineer interview -
Tell us how to improve this page.
TransOrg Analytics Interviews By Designations
- TransOrg Analytics Analyst Interview Questions
- TransOrg Analytics Data Scientist Interview Questions
- TransOrg Analytics Data Analyst Interview Questions
- TransOrg Analytics Senior Analytics Lead Interview Questions
- TransOrg Analytics Software Developer Interview Questions
- TransOrg Analytics Business Analyst Interview Questions
- TransOrg Analytics Data Engineer Interview Questions
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Developer Interview Questions
- Azure Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Data Engineer Interview Questions from Similar Companies
TransOrg Analytics Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Data Analyst
47
salaries
|  ₹6 L/yr - ₹20 L/yr |
|
Analyst
40
salaries
| ₹7 L/yr - ₹14 L/yr |
|
Data Scientist
25
salaries
| ₹7 L/yr - ₹16 L/yr |
|
Analytics Specialist
24
salaries
| ₹8 L/yr - ₹21 L/yr |
|
Data Science Analyst
12
salaries
| ₹8 L/yr - ₹12 L/yr |
Bajaj Finserv
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
- Home >
- Interviews >
- TransOrg Analytics Interview Questions
