New Era Informatique Interview Questions and Answers for Freshers

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte

30 Aptitude Question
3 Mail Writing Question

Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
Ans. 
Solved a sorting problem by implementing quicksort algorithm.
• Implemented quicksort algorithm to efficiently sort the array.

• Used recursion to divide the array into smaller subarrays and sort them individually.

• Optimized the algorithm by choosing a pivot element strategically to minimize comparisons.
Answered by AI
Add your answer
Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
Add your answer
Q3. Explain 3rd Question based on SQL Query.
Ans. 
The 3rd question based on SQL query likely refers to a specific query or scenario related to SQL.
• Understand the context of the query being asked about

• Analyze the structure and purpose of the SQL query

• Explain the expected output or result of the query
Answered by AI
Add your answer
Q4. Write a code to Reverse Digits.
Ans. 
Code to reverse digits of a number
• Use modulo operator to extract the last digit of the number

• Multiply the result by 10 and add the next digit until all digits are reversed

• Handle negative numbers separately by converting to positive before reversing
Answered by AI
View 1 more amswer
Q5. A problem question for solving a SQL Query.
Add your answer

Q1. Salary negotiations
Add your answer
Q2. What are your expectations
Add your answer
Q3. As per company standards
Add your answer

Q1. What are your skills
Add your answer
Q2. What is your experience
Add your answer
Q3. Communication, interpersonal
Add your answer

Q1. Regarding skills
Add your answer
Q2. What is your aim
Add your answer
Q3. How can you succeed in your life
Add your answer
Q4. Where do you see yourself in 5 years
Add your answer
Q5. What all did you learn in your career
Add your answer
Q6. Who all are in your family
Add your answer
Q7. What all decisions your made as an hr
Add your answer

Q1. Securitisation and how it works.
Ans. 
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based...read more
Answered by AI
View 1 more amswer
Q2. Financial Ratios and how they work and what is a good number to have.
Ans. 
Financial ratios are tools used to evaluate a company's financial performance and health.
• Financial ratios are calculated using data from a company's financial statements.

• They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.

• A good number for a financial ratio can vary depending on the industry and company size.

• For example, a current ratio of 2 or higher is generally cons...read more
Answered by AI
Add your answer
Q3. Random number crunching based on some scenario that needs you to make assumptions and get an answer
Add your answer
Q4. How an Excel function works. (Vlookup, Hlookup, Xlookup, IF/AND/OR)
Ans. 
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
• Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup: Similar to Vlookup but searches for a value in the first row of a table.

• Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.

• IF: Retu...read more
Answered by AI
Add your answer

Q1. Personal Questions.
Add your answer
Q2. My expertise and proficiency of excel
Add your answer

Q1. No questions. Was confirmed my job
Add your answer

Q1. Operating system
Add your answer
Q2. Computer networks mcqs
Add your answer
Q3. Data structures and algo mcqs
Add your answer

Q1. Resume shortlist
Add your answer

5 coding questions (4 medium and 1 easy) on coderbyte.

Q1. Questions about previous jobs/internships and other HR-related questions.
Add your answer

Q1. Based on the skills mentioned in my resume, and questions based on the project mentioned (the Interviewer asked to open my GitHub profile and asked questions on code written).
Add your answer

It was based on c language

Q1. What is c programming
Ans. 
C programming is a high-level programming language used for system programming, embedded systems, and software development.
• C programming is widely used for developing operating systems, compilers, and device drivers.

• It allows direct access to memory and hardware, making it efficient for low-level programming.

• C programs are portable and can be easily optimized for performance.

• Example: Writing a simple 'Hello World' prog
Answered by AI
Add your answer
Q2. What is array in c
Ans. 
An array in C is a collection of elements of the same data type stored in contiguous memory locations.
• Arrays are declared by specifying the data type of the elements and the number of elements in square brackets, e.g. int arr[5];

• Elements in an array can be accessed using their index, starting from 0, e.g. arr[0] refers to the first element.

• Arrays in C are zero-indexed, meaning the first element is at index 0.

• Arrays can...read more
Answered by AI
Add your answer

Q1. Skillsets hired for?
Add your answer
Q2. Monthly onboarding?
Add your answer