Upload Button Icon Add office photos

Velocis Systems

Compare button icon Compare button icon Compare

Filter interviews by

Velocis Systems ETL Developer Lead Interview Questions and Answers

Updated 16 Jun 2023

Velocis Systems ETL Developer Lead Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Ask you questions about basic SQL,dbms , datawarehouse,data modeling
Round 3 - Technical 

(3 Questions)

  • Q1. What is Normalisation and basic nf forms
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a table into smaller tables and defining relationships between them.

    • The goal of normalization is to eliminate redundant data and ensure data dependencies make sense.

    • There are different normal forms (NF) such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules to follow...

  • Answered by AI
  • Q2. What is star schema and snowflake and their uses cases
  • Ans. 

    Star schema and snowflake are data modeling techniques used in data warehousing.

    • Star schema is a denormalized schema where a central fact table is connected to multiple dimension tables in a star-like structure.

    • Snowflake schema is a normalized form of star schema where dimension tables are further normalized into sub-dimension tables.

    • Star schema is more suitable for simpler queries and faster performance, while snowfla...

  • Answered by AI
  • Q3. What you to for optimising queries
  • Ans. 

    I optimize queries by using indexes, avoiding unnecessary joins, and optimizing where clauses.

    • Use indexes on columns frequently used in where clauses

    • Avoid unnecessary joins by using subqueries or common table expressions

    • Optimize where clauses by using appropriate operators and functions

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong your basics like SQL dbms DW basics..tool basics like informatica,pdi or SSIS whatever tool you work .

Learn your day to day scenarios and problem solving

All the best

Top trending discussions

View All
Interview Tips & Stories
5d (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Velocis Systems?
Ask anonymously on communities.

Interview questions from similar companies

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain

    • Handle edge cases like no fresh oranges or all oranges already rotten

    • Consider using a queue to efficiently process adjacent oranges

  • Answered by AI
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Ans. 

    Find the majority element in an array, return -1 if no majority element exists.

    • Iterate through the array and keep track of the count of each element using a hashmap.

    • Check if any element's count is greater than floor(N/2) to determine the majority element.

    • Return the majority element or -1 if no majority element exists.

  • Answered by AI
  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Ans. 

    Find the Lowest Common Ancestor (LCA) of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the LCA.

    • Handle cases where one node is an ancestor of the other or when one node is the LCA itself.

  • Answered by AI
  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

  • Ans. 

    Reverse words in a string while handling leading/trailing spaces and multiple spaces between words.

    • Split the input string by spaces to get individual words

    • Reverse the list of words

    • Join the reversed words with a single space in between

    • Handle leading/trailing spaces by stripping them before and after reversing

  • Answered by AI
Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Ans. 

    Assign subjects to friends to minimize maximum workload, find minimum time for most loaded friend.

    • Sort subjects in descending order

    • Assign subjects to friends one by one until all subjects are assigned

    • The maximum workload will be the sum of problems assigned to the friend with the most problems

    • Return the maximum workload as the minimum time required

  • Answered by AI
  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Ans. 

    Find the total sum of all root to leaf paths in a binary tree formed by concatenating node values.

    • Traverse the binary tree from root to leaf nodes, keeping track of the current path sum

    • Add the current path sum to the total sum when reaching a leaf node

    • Use modulo (10^9 + 7) to handle large outputs

  • Answered by AI
  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

ETL Developer Lead Interview Questions Asked at Other Companies

Q1. What are star and snowflake schemas, and what are their use cases ... read more
Q2. What do you do for optimizing queries?
Q3. What is Normalization and what are the basic normal forms?
asked in Capgemini
Q4. What is ETL?

I applied via Campus Placement and was interviewed before Jul 2021. There were 5 interview rounds.

Round 1 - Aptitude Test 

Round 1 was about 60 mins long. Basic Aptitude questions along with Programming MCQ

Round 2 - Coding Test 

Round 2 had 2 coding questions with a time limit of 60mins. Intermediate level problem solving
knowledge is neccessary.

Round 3 - Technical 

(1 Question)

  • Q1. Technical Round 1 was 1hr long. Detailed Insights about my project and a few programming questions in DSA
Round 4 - Technical 

(1 Question)

  • Q1. This Technical Round 2 was 1hr long and was mainly focused on problem solving skills and a few basic programming concepts.
Round 5 - HR 

(1 Question)

  • Q1. Three Situational questions were asked .

Interview Preparation Tips

Topics to prepare for Bounteous x Accolite Software Developer interview:
  • Data Structures
  • Algorithms
  • CPP
  • Problem Solving
Interview preparation tips for other job seekers - Prepare Well . Perform well with full confidence

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. 1. If you given a no return its corresponding excel no.
  • Ans. 

    Convert given no to corresponding excel no.

    • Excel no starts from 1 and goes up to 16384

    • Excel no is calculated using column and row numbers

    • For example, 1 corresponds to A, 27 corresponds to AA, 28 corresponds to AB, and so on

  • Answered by AI
  • Q2. 2. find unique character in a window of k size in a string
  • Ans. 

    Find unique characters in a window of k size in a string.

    • Use a sliding window approach.

    • Maintain a hash table to keep track of character frequency.

    • Remove characters from hash table as the window slides.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Communication is very important. Give your solution from brute force to optimal. Interviewer has tell me to write code of both questions in any programming language.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. WRITE A java program to find the shortest distance between 2 nodes in an array
  • Ans. 

    Java program to find shortest distance between 2 nodes in an array of strings

    • Create a method that takes in the array of strings and the two nodes as parameters

    • Use a map to store the index of each node in the array

    • Calculate the distance between the two nodes using their indices in the array

  • Answered by AI
  • Q2. Explain oops concept
  • Ans. 

    OOPs concept is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.

    • OOPs stands for Object-Oriented Programming

    • Key concepts include classes, objects, inheritance, polymorphism, and encapsulation

    • Classes are blueprints for creating objects, which are instances of classes

    • Inheritance allows a class to inherit properties and behavior from an...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. Location process

Skills evaluated in this interview

I appeared for an interview in Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 20 Minutes
Round difficulty - Easy

  • Q1. 

    Left View of a Binary Tree Problem Statement

    Given a binary tree, your task is to print the left view of the tree.

    Example:

    Input:
    The input will be in level order form, with node values separated by a...
  • Ans. 

    Print the left view of a binary tree given in level order form.

    • Traverse the tree level by level and print the first node of each level (leftmost node).

    • Use a queue to perform level order traversal.

    • Keep track of the current level and print the first node encountered at each level.

  • Answered by AI
Round 2 - Video Call 

(3 Questions)

Round duration - 45 Minutes
Round difficulty - Easy

It was a technical round held on skype.

  • Q1. 

    Intersection of Linked List Problem

    You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list.

    Your task is to determine t...

  • Ans. 

    Find the node where two linked lists merge, return -1 if no merging occurs.

    • Traverse both lists to find their lengths and the difference in lengths

    • Move the pointer of the longer list by the difference in lengths

    • Traverse both lists simultaneously until they meet at the merging point

  • Answered by AI
  • Q2. 

    Reverse Linked List Problem Statement

    Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.

    Input:

    The first line of input is an intege...
  • Ans. 

    Reverse a singly linked list by altering the links between nodes.

    • Iterate through the linked list and reverse the links between nodes

    • Use three pointers to keep track of the current, previous, and next nodes

    • Update the links between nodes to reverse the list

    • Return the head of the reversed linked list

  • Answered by AI
  • Q3. 

    Merge K Sorted Arrays Problem Statement

    You are provided with 'K' different arrays/lists, each sorted in ascending order. Your task is to merge all these arrays/lists into one sorted array/list in ascendi...

  • Ans. 

    Merge K sorted arrays into one sorted array in ascending order.

    • Iterate through all arrays/lists and merge them into one sorted array using a priority queue or merge sort algorithm.

    • Ensure to handle edge cases like empty arrays/lists or arrays/lists with different sizes.

    • Time complexity can be optimized by using a min-heap or priority queue to efficiently merge the arrays/lists.

  • Answered by AI
Round 3 - Video Call 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Easy

It was also a technical round held on Google meet.
 

  • Q1. 

    Maximum Subarray Problem Statement

    Ninja has been given an array, and he wants to find a subarray such that the sum of all elements in the subarray is maximum.

    A subarray 'A' is considered greater than a...

  • Ans. 

    The task is to find the subarray with the maximum sum in a given array.

    • Iterate through the array and keep track of the current sum and maximum sum seen so far.

    • If the current sum becomes negative, reset it to 0 as it won't contribute to the maximum sum.

    • Compare the maximum sum with the sum of the current subarray to update the result.

    • Handle cases where all elements are negative by returning the maximum element in the arr...

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from B V Raju Institute of Technology. I applied for the job as SDE - 1 in HyderabadEligibility criteria7 CGPAAccolite interview preparation:Topics to prepare for the interview - DS, Algo, DBMS, HTML, CSS, Machine Learning, SQL, Java, OOPs, PythonTime required to prepare for the interview - 3 MonthsInterview preparation tips for other job seekers

Tip 1 : Maintain detail notes
Tip 2 : Revise the notes 
 

Application resume tips for other job seekers

Tip 1 : Mention the skills only which you are aware of
Tip 2 : Improve your resume

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Aptitude and analytical

Round 2 - Coding Test 

Coding Data structure and algorithms

Round 3 - Technical 

(1 Question)

  • Q1. Data structures and algorithms
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

(1 Question)

  • Q1. Climbing ladders, either 1 step or 2 step at a time
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

There were 2 easy - difficult leetcode questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. They ask us to intoroduce
  • Ans. 

    I am a passionate software developer with experience in building scalable applications and a strong foundation in programming languages.

    • Background: I have a degree in Computer Science and have worked on various projects during my studies.

    • Experience: I have 3 years of experience in full-stack development, primarily using JavaScript, React, and Node.js.

    • Projects: I developed an e-commerce platform that increased sales by ...

  • Answered by AI
  • Q2. Rest were around resume
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How to find the Second highest salary from employees table. Write the logic for pre-order, inorder and post-order traversal of a binary tree
  • Ans. 

    To find the second highest salary from employees table and traverse a binary tree in pre-order, in-order, and post-order.

    • To find the second highest salary, you can use a subquery or window function like ROW_NUMBER() or DENSE_RANK().

    • For pre-order traversal, visit the root node first, then recursively do a pre-order traversal of the left subtree, followed by the right subtree.

    • For in-order traversal, recursively do an in-...

  • Answered by AI

Skills evaluated in this interview

Velocis Systems Interview FAQs

How many rounds are there in Velocis Systems ETL Developer Lead interview?
Velocis Systems interview process usually has 3 rounds. The most common rounds in the Velocis Systems interview process are Technical and Resume Shortlist.
What are the top questions asked in Velocis Systems ETL Developer Lead interview?

Some of the top questions asked at the Velocis Systems ETL Developer Lead interview -

  1. What is star schema and snowflake and their uses ca...read more
  2. What you to for optimising quer...read more
  3. What is Normalisation and basic nf fo...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4/5

based on 1 interview experience

Difficulty level

Moderate 100%

Duration

2-4 weeks 100%
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.7
 • 376 Interviews
CitiusTech Interview Questions
3.3
 • 290 Interviews
NeoSOFT Interview Questions
3.6
 • 280 Interviews
Altimetrik Interview Questions
3.7
 • 240 Interviews
Episource Interview Questions
3.9
 • 224 Interviews
Xoriant Interview Questions
4.1
 • 213 Interviews
INDIUM Interview Questions
4.0
 • 198 Interviews
Incedo Interview Questions
3.1
 • 193 Interviews
View all
Network Engineer
339 salaries
unlock blur

₹3.2 L/yr - ₹7.8 L/yr

Software Developer
303 salaries
unlock blur

₹4 L/yr - ₹9.2 L/yr

Senior Software Developer
225 salaries
unlock blur

₹6 L/yr - ₹13.1 L/yr

Senior Software Engineer
161 salaries
unlock blur

₹5.6 L/yr - ₹22 L/yr

Software Engineer
151 salaries
unlock blur

₹3.3 L/yr - ₹8 L/yr

Explore more salaries
Compare Velocis Systems with

ITC Infotech

3.7
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

4.1
Compare
write
Share an Interview