AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Ordex Technology Solutions Data Analyst Interview Questions and Answers
Ordex Technology Solutions Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Jul 2022. There were 3 interview rounds.
Have to go through Aptitude test
(3 Questions)
- Q1. Have to go through technical round
- Q2. Write sql queries with join
- Ans.
SQL queries with join
Use INNER JOIN to combine rows from two or more tables based on a related column between them
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
- Q3. Write vlookup formula
- Ans.
VLOOKUP formula searches for a value in the first column of a table and returns a value in the same row from another column.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table.
table_array: The range of cells that contains the data.
col_index_num: The column number in the table from which to retrieve the value.
range_lookup: Optio...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I appeared for an interview in Aug 2017.
Interview Preparation Tips
Experience: every one put their views
Tips: just tell anything. no one listen
Duration: 5 minutes
Round: Test
Experience: online test
Tips: do those question which can be solved without usingpen paper first
Duration: 5 minutes
Total Questions: 50
Skills: Relieving Pressure
I appeared for an interview in Sep 2016.
Interview Questionnaire
2 Questions
- Q1. Behavioral questions, what will you choose knowledge or money?Why?, etc . Other curricular activities that showcase your managerial skills, etc
- Q2. Focused on projects from resume and cross questioning. Can ask you about the tools or languages related questions if you have added that to CV. Followed by guesstimates where you will have to provide detai...
Interview Preparation Tips
Tips: It is advantageous if you have prior experience with data handling tools eg advanced EXCEL , SPSS
I appeared for an interview before Nov 2016.
Interview Preparation Tips
Experience: Only Written
Duration: 1 hour 45 minutes
Total Questions: 100
Skills: Proficiency In English, Basic concepts of computer, Commerce background with 50%
I appeared for an interview before Dec 2020.
(1 Question)
Round duration - 120 Minutes
Round difficulty - Medium
- Q1.
Ninja and His Secret Information Encoding Problem
Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...
- Ans.
The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.
Read the number of test cases 'T'
For each test case, encode the 'SECRET_INFORMATION' and then decode it
Compare the decoded string with the original 'SECRET_INFORMATION'
Print 'Transmission successful' if they match, else print 'Transmission failed'
(1 Question)
Round duration - 60 Minutes
Round difficulty - Medium
- Q1.
Equilibrium Index Problem Statement
Given an array
Arrconsisting of N integers, your task is to find the equilibrium index of the array.An index is considered as an equilibrium index if the sum of elem...
- Ans.
Find the equilibrium index of an array where sum of elements on left equals sum on right.
Iterate through the array and calculate prefix sum and suffix sum at each index.
Compare prefix sum and suffix sum to find equilibrium index.
Return the left-most equilibrium index or -1 if none found.
Round duration - 50 Minutes
Round difficulty - Easy
Interview Preparation Tips
Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company
Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.
Skills evaluated in this interview
I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Da tools
Interview Preparation Tips
I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Python data structures
- Q2. MongoDB database algorithms
- Ans.
MongoDB database algorithms are used for efficient data storage, retrieval, and processing.
MongoDB uses various algorithms for indexing, sharding, and aggregation.
Indexing algorithms include B-tree, hash, and text search indexes.
Sharding algorithms include range-based, hash-based, and zone-based sharding.
Aggregation algorithms include map-reduce and aggregation pipeline.
MongoDB also uses algorithms for query optimizati
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
3 Questions
- Q1. About my self and my experience.
- Q2. What's the reason for leaving previous job?
- Q3. Technical question depends on process.
I applied via Walk-in and was interviewed before Feb 2021. There were 4 interview rounds.
(1 Question)
- Q1. Scenario based question SQL questions advanced Excel questions like v lookup h lookup
(1 Question)
- Q1. About the project complete description of the project what we have done and how
(5 Questions)
- Q1. Why should we hire you?
- Q2. Why are you looking for a change?
- Q3. What are your strengths and weaknesses?
- Q4. Tell me about yourself.
- Q5. What are your salary expectations?
Interview Preparation Tips
I applied via Referral and was interviewed in Jul 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. 1. what is responsibility of data ayalyst. 2. About project. 3. how to deal multi- source problem. 4. what are key skill required for data analyst. 5. some statistical method that are useful for data anyly...
Interview Preparation Tips
Ordex Technology Solutions Interview FAQs
Tell us how to improve this page.
Ordex Technology Solutions Interviews By Designations
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Ordex Technology Solutions Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Ordex Technology Solutions Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Software Developer
7
salaries
|  ₹2.8 L/yr - ₹7 L/yr |
|
Junior Software Developer
7
salaries
| ₹2 L/yr - ₹4.4 L/yr |
|
Software Engineer
4
salaries
| ₹2.2 L/yr - ₹3 L/yr |
|
Junior Java Developer
4
salaries
| ₹3 L/yr - ₹4.2 L/yr |
|
Java Developer
3
salaries
| ₹1.6 L/yr - ₹4 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Ordex Technology Solutions Interview Questions >
- Ordex Technology Solutions Data Analyst Interview Questions
