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

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - Coding Test 

Test will be in hacker rank there would be a difficulty level between easy to medium

Round 2 - Technical 

(1 Question)

  • Q1. Question will be from data structure and easy to medium level of the programming laanguage question
Round 3 - HR 

(1 Question)

  • Q1. This is just to check your english ability
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Online zoom coding test will be there - 4 questions - 2 about output of code & 2 about technical questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Polymorphism and explain about virtual polymorphism
  • Ans. 

    Polymorphism is the ability of a single function or method to operate on different types of data.

    • Polymorphism allows objects of different classes to be treated as objects of a common superclass.

    • Virtual polymorphism is achieved through virtual functions in C++.

    • Virtual functions allow a function in a base class to be overridden in a derived class.

    • Example: Animal class with virtual function 'makeSound' overridden in Dog a

  • Answered by AI
  • Q2. Write code for virtual polymorphism and explain
  • Ans. 

    Virtual polymorphism allows objects of different classes to be treated as objects of a common superclass.

    • Create a base class with virtual functions

    • Create derived classes that override the virtual functions

    • Use pointers or references of the base class to call the overridden functions

  • Answered by AI
Round 3 - HR 

(3 Questions)

  • Q1. About yourself should explain
  • Q2. Reason for job change
  • Q3. Salary negotiations and location

Interview Preparation Tips

Interview preparation tips for other job seekers - I have interviewed for c++ developer role in incedo company - please make sure you are completely aware of every functions and keywords relate to c++ concepts.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackearth online coding test for 1 hour

Round 2 - Technical 

(2 Questions)

  • Q1. Dsa question and output questions
  • Q2. Find k largest element in an array
  • Ans. 

    Use sorting or heap data structure to find k largest elements in an array of strings.

    • Sort the array in descending order and return the first k elements.

    • Use a max heap data structure to efficiently find the k largest elements.

    • Examples: ['apple', 'banana', 'orange', 'kiwi'], k=2 -> ['orange', 'kiwi']

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Remove duplicates from array
  • Ans. 

    Remove duplicates from array of strings

    • Create a Set to store unique strings

    • Iterate through the array and add each string to the Set

    • Convert the Set back to an array to get the unique strings

  • Answered by AI
  • Q2. Output related questions on student class object

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare dsa well

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Coding round is related to DSA

Round 2 - Technical 

(2 Questions)

  • Q1. Java related questions
  • Q2. Explain about your project
Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. Why you want to join us?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

Technology advantage or not

Round 2 - Aptitude Test 

All aptitude topics,logical reasoning

Round 3 - Technical 

(2 Questions)

  • Q1. Oops,2 coding questions
  • Q2. Palindrome,even number
Round 4 - HR 

(2 Questions)

  • Q1. What do you know
  • Q2. Do you have any questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Similar to tcs,infosys pattern
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. REST API for User CRUD
  • Ans. 

    Design a RESTful API for CRUD operations on user resources.

    • Use HTTP methods like GET, POST, PUT, DELETE for CRUD operations

    • Create endpoints like /users for listing all users, /users/{id} for specific user

    • Use status codes like 200 for success, 404 for not found, 400 for bad request

    • Implement authentication and authorization mechanisms for security

    • Include request and response body formats like JSON or XML

  • Answered by AI
  • Q2. Two Sum Leetcode problem
  • Q3. Basic questions based on the candidate technical skills
Round 2 - Technical 

(2 Questions)

  • Q1. Basics to Intermediate level of questions based on the skills mentioned in the resume
  • Q2. Projects related discussions
Round 3 - Document Verification 

(1 Question)

  • Q1. I was informed to upload the supporting documents. ( They rejected me after this eventhough all my documents are genuine )

Interview Preparation Tips

Interview preparation tips for other job seekers - The interviewer's are friendly. Be prepared as per your resume.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is OOPS ?
  • Ans. 

    OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.

    • OOPS focuses on creating objects that contain data and methods to manipulate that data.

    • It allows for encapsulation, inheritance, and polymorphism.

    • Examples of OOPS languages include Java, C++, and Python.

  • Answered by AI
  • Q2. What is Dependency Injection
  • Ans. 

    Dependency Injection is a design pattern where components are given their dependencies rather than creating them internally.

    • Allows for easier testing by mocking dependencies

    • Promotes loose coupling between components

    • Improves code reusability and maintainability

    • Example: Constructor injection, Setter injection

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Which Architechture does you project build by?
  • Q2. What is Normalization in sql?
  • Ans. 

    Normalization in SQL 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.

    • It helps in reducing data redundancy by storing data in a structured manner.

    • There are different normal forms like 1NF, 2NF, 3NF, and BCNF that define the level of normalization.

    • Example: If we have a t...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Tell about your self ?
  • Q2. Whom do you provide your first month salary ?

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Shine and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Normal coding round with simple oa complexity

Round 2 - One-on-one 

(2 Questions)

  • Q1. Discussion on projects
  • Q2. Culture fit check

Interview Preparation Tips

Interview preparation tips for other job seekers - go thru projects and problem solving
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What are the traversal conditions for a Doubly Linked List? And write a program to traverse.This was the first question and I had no answer and ended up the interview immediately by asking any questions fo...
  • Ans. 

    Traversal conditions for a Doubly Linked List involve moving forward and backward through each node.

    • Start at the head node and move to the next node by following the 'next' pointer.

    • To traverse backward, start at the tail node and move to the previous node by following the 'prev' pointer.

    • Continue this process until reaching the end of the list.

  • Answered by AI

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 is Normalisation and basic nf fo...read more
  3. What you to for optimising quer...read more

Tell us how to improve this page.

Velocis Systems ETL Developer Lead Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 809 Interviews
CitiusTech Interview Questions
3.4
 • 268 Interviews
View all
Network Engineer
324 salaries
unlock blur

₹1.8 L/yr - ₹8.2 L/yr

Software Developer
254 salaries
unlock blur

₹2.5 L/yr - ₹10 L/yr

Senior Software Developer
226 salaries
unlock blur

₹3.6 L/yr - ₹15 L/yr

Senior Software Engineer
152 salaries
unlock blur

₹4.3 L/yr - ₹17 L/yr

Software Engineer
143 salaries
unlock blur

₹2.5 L/yr - ₹12 L/yr

Explore more salaries
Compare Velocis Systems with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview