Upload Button Icon Add office photos

Filter interviews by

Ahana Systems & Solutions Senior ETL Developer Interview Questions and Answers

Updated 10 Oct 2023

Ahana Systems & Solutions Senior ETL Developer Interview Experiences

1 interview found

Senior ETL Developer Interview Questions & Answers

user image sidharth sreekumar

posted on 10 Oct 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Oct 2022. There were 5 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 - HR 

(1 Question)

  • Q1. Salary expectation,why changing, why this company type :)
Round 3 - One-on-one 

(1 Question)

  • Q1. Olap, etl basics, RDBMS
Round 4 - Technical 

(1 Question)

  • Q1. Again specifics about the tech
Round 5 - HR 

(1 Question)

  • Q1. Not very different from initial discussion,finalising

Interview questions from similar companies

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

I applied via Walk-in

Round 1 - Technical 

(2 Questions)

  • Q1. How make a queue using a stack
  • Ans. 

    To implement a queue using a stack, use two stacks and simulate the queue operations.

    • Use two stacks, one for enqueue operation and one for dequeue operation.

    • For enqueue operation, simply push elements onto the stack used for enqueueing.

    • For dequeue operation, if the dequeue stack is empty, pop all elements from enqueue stack and push onto dequeue stack.

    • Then pop from the dequeue stack to simulate dequeue operation.

  • Answered by AI
  • Q2. Create a linked list
  • Ans. 

    A linked list is a data structure consisting of nodes where each node points to the next node in the sequence.

    • Create a Node class with data and next pointer

    • Initialize a head pointer to null

    • Add nodes by updating next pointers

    • Traverse the list by following next pointers

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

It was ok. I was not able to solve all the questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Remove the last element from a linkedlist
  • Ans. 

    To remove the last element from a linked list, iterate to the second last node and update its next pointer to null.

    • Iterate through the linked list to find the second last node

    • Update the next pointer of the second last node to null

  • Answered by AI
  • Q2. Some basic questions on oops dbms and os

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Coding Test 

The interviewer asked about javascript basics and DSA questions and some typescript questions

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

(5 Questions)

  • Q1. Tell me about
  • Q2. Your self they are asking
  • Q3. What is your weakness
  • Q4. Any questions ask for me
  • Q5. All the best future
Round 2 - Coding Test 

Coding for international

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

I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Simple question on maths

Round 2 - Technical 

(2 Questions)

  • Q1. Explain OOPS concept
  • Ans. 

    OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.

    • OOPS focuses on creating objects that interact with each other to solve complex problems

    • Key principles include encapsulation, inheritance, polymorphism, and abstraction

    • Encapsulation ensures that the internal state of an object is hidden from the outside world

    • Inheritance allows a class to inherit...

  • Answered by AI
  • Q2. Coding array questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

60mintues DSA level coding exam

I applied via Naukri.com and was interviewed in Apr 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 - Aptitude Test 

Aptitude test of 25 questions with no negative marks

Round 3 - Technical 

(2 Questions)

  • Q1. Basic questions interviewer was good
  • Q2. Sql query and plsql development skills also required

Interview Preparation Tips

Interview preparation tips for other job seekers - their is a 2years bond for even experienced people

I applied via Walk-in and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

5 coding questions in 45 mins ...very easy questions, you can easily do..pen paper based exam. Programs were on strings, arrays and patterns

Round 2 - Coding Test 

Round 2 is also coding test here questions were moderate. 3 questions given for 1.5 hours..
Again string and pattern programs were given.
Candidate should be clear with loops , strings arrays..thats it.. no need of studying linked lists ,stacks, queues or other data structures..your knowledge of algorithms doesnt matter here..its all about patterns, strings, arrays and loops

Round 3 - Coding Test 

It is last coding round..here there is too much politics those who are working there call there friends and make them sit directly in final round..3 questions given no limit on time you have to do any 2 . They will roam around in roam and will discuss your code..they will help there friends as i was there without any referral there was noone for me..but it doesn't matter if u have strong basics u can crack it ..because problems are again on strings, arrays,patterns . I got bored doing same problems.

Interview Preparation Tips

Topics to prepare for Cyntexa Software Developer interview:
  • Strings
  • Arrays
  • Pattern Making
  • Loops
Interview preparation tips for other job seekers - Watch some YouTube video on patterns, strings and array programs..make your logic correct in these 3 areas ..you can easily crack.
Company is small but Salesforce is on demand in 2022 and I have heard cyntexa pays less but learning experience is far better than meta or other companies in similar domain.
If u have a friend there ask them for there referral. After gaining one year experience you can easily switch, my friends got packages upto 10 lpa in just one year.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Normal aptitude questions

Round 2 - Coding Test 

Python basic and some basic coding questions

Round 3 - Coding Test 

Advance level coding question

Ahana Systems & Solutions Interview FAQs

How many rounds are there in Ahana Systems & Solutions Senior ETL Developer interview?
Ahana Systems & Solutions interview process usually has 5 rounds. The most common rounds in the Ahana Systems & Solutions interview process are HR, One-on-one Round and Technical.
What are the top questions asked in Ahana Systems & Solutions Senior ETL Developer interview?

Some of the top questions asked at the Ahana Systems & Solutions Senior ETL Developer interview -

  1. Not very different from initial discussion,finalis...read more
  2. Olap, etl basics, RD...read more
  3. Again specifics about the t...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Ahana Systems & Solutions interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.2k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
LTIMindtree Interview Questions
3.9
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 785 Interviews
View all
Ahana Systems & Solutions Senior ETL Developer Salary
based on 4 salaries
₹6 L/yr - ₹12 L/yr
31% less than the average Senior ETL Developer Salary in India
View more details
Technical Support Engineer
93 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Software Engineer
44 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

ETL Developer
44 salaries
unlock blur

₹2.3 L/yr - ₹9 L/yr

System Administrator
32 salaries
unlock blur

₹2 L/yr - ₹4.9 L/yr

Database Admin
32 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Ahana Systems & Solutions with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview