Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Premium Employer

i

This company page is being actively managed by Accion Labs Team. If you also belong to the team, you can get access from here

Accion Labs Verified Tick

Compare button icon Compare button icon Compare
3.5

based on 480 Reviews

Filter interviews by

Accion Labs SQL and BI Developer Interview Questions and Answers

Updated 21 Feb 2024

Accion Labs SQL and BI Developer Interview Experiences

1 interview found

SQL and BI Developer Interview Questions & Answers

user image Anonymous

posted on 21 Feb 2024

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

I applied via Referral and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

First round coding round that is purely based on SQL.

Round 2 - Technical 

(4 Questions)

  • Q1. Technical round based on SQL medium level and tricky questions.
    • Add your answer
  • Q2. Be prepared for window, CTE functions
    • Add your answer
  • Q3. 2nd highest salary
    • Add your answer
  • Q4. All types of joining
  • Ans. 

    Different types of joining in SQL include inner join, outer join, left join, right join, and full join.

    • Inner join: Returns rows when there is a match in both tables

    • Outer join: Returns all rows when there is a match in one of the tables

    • Left join: Returns all rows from the left table and the matched rows from the right table

    • Right join: Returns all rows from the right table and the matched rows from the left table

    • Full joi...

    • Answered by AI
    Add your answer
Round 3 - Case Study 

This is the managerial round and then HR round

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared on SQL and if you have some knowledge on power bi and any other reporting tool will be plus point.

Top trending discussions

View All
Career Growth
2w (edited)
a technical lead
Help to Understand
I have below 2 offers. which one to join. Need some guidance. 1. Luxoft - 32 fixed lpa. WFH. 1 lac joining bonus. 2. TCS - 31 fixed . over all ctc - 36. no WFH. 2 lac joining bonus (temporarily hybrid 3 days in client location which is near to my place till the time assigned to same project)
Got a question about Accion Labs?
Ask anonymously on communities.

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Altimetrik user image Anonymous

posted on 17 Apr 2021

Interview Questionnaire 

1 Question

  • Q1. Basic javascript questions , clouser, promise
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared well on basic of javascript

Software Developer Interview Questions & Answers

Bounteous x Accolite user image

posted on 12 Jun 2021

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
    Add your answer
  • 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
    Add your answer

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

Software Engineer Interview Questions & Answers

Bounteous x Accolite user image Anonymous

posted on 20 Jun 2021

I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Dsa java oops dbms networking
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview experience.
You have to be very strong in DSA.

Software Engineer Interview Questions & Answers

CitiusTech user image Anonymous

posted on 14 Apr 2021

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops concepts with examples, SQL query to find second highest salary, diff between fail fast and fail safe, how did u implement security in your app, etc
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic Java concepts

Software Engineer Interview Questions & Answers

Apexon user image Anonymous

posted on 30 May 2020

I applied via Company Website and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Are you updating day by day yourself in technology ?
    • Add your answer
  • Q2. Yes, means you will definitely placed in technosoft.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I had done certification and learn the skill day by day, waiting for the opening in technosoft. I had attended three round of interview, if you have real skill and self confidence you will definitely placed in technosoft global services

Software Engineer Interview Questions & Answers

Apexon user image Anonymous

posted on 1 Sep 2022

I applied via Naukri.com and was interviewed before Sep 2021. 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 

(3 Questions)

  • Q1. Do you have knowledge of Hadoop data ware house?
  • Ans. 

    Yes, I have knowledge of Hadoop data warehouse.

    • I have experience in designing and implementing Hadoop-based data warehouses.

    • I am proficient in Hadoop ecosystem technologies such as HDFS, MapReduce, Hive, and Pig.

    • I have worked with large-scale data processing and storage using Hadoop.

    • I am familiar with data warehousing concepts such as ETL, data modeling, and data integration.

    • I have used Hadoop to build data warehouses

    • Answered by AI
    Add your answer
  • Q2. SQl questions using joins.
    • Add your answer
  • Q3. Have you used python scripts in your testing?
  • Ans. 

    Yes, I have used Python scripts extensively in my testing.

    • I have used Python scripts for automated testing of web applications.

    • I have also used Python scripts for unit testing of backend code.

    • Python's unittest module is particularly useful for this purpose.

    • I have also used Python scripts for load testing and performance testing.

    • Python's requests library is very helpful for testing APIs.

    • I have also used Python scripts f

    • Answered by AI
    Add your answer
Round 3 - HR 

(1 Question)

  • Q1. What is your current ctc and what is your expected ctc?
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare the SQL for ETL job role and apexon interviews would be a easy one to crack.

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

Globant user image Anonymous

posted on 26 Nov 2021

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basic questions on javascript, angular, html,css
    • Add your answer
  • Q2. Questions on localstorage , tokens, security, interceptors
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and u will rock

Software Engineer Interview Questions & Answers

Globant user image Anonymous

posted on 13 Jun 2021

I applied via LinkedIn and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics Of JS
    • Add your answer

Software Engineer Interview Questions & Answers

Incedo user image Anonymous

posted on 26 Mar 2021

I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Difference between Hashtable and hashmap?
  • Ans. 

    Hashtable is synchronized while hashmap is not.

    • Hashtable is thread-safe while hashmap is not.

    • Hashtable does not allow null keys or values while hashmap allows one null key and multiple null values.

    • Hashtable is slower than hashmap due to synchronization.

    • Hashtable is a legacy class while hashmap is a newer implementation.

    • Answered by AI
    Add your answer
  • Q2. Difference between hashmap and concurrent hashmap?
  • Ans. 

    Hashmap is not thread-safe while Concurrent Hashmap is thread-safe.

    • Hashmap is not suitable for multi-threaded environments as it can lead to race conditions and data inconsistencies.

    • Concurrent Hashmap allows multiple threads to access and modify the map concurrently without any data inconsistencies.

    • Concurrent Hashmap uses a technique called lock striping to achieve thread-safety.

    • Concurrent Hashmap is slower than Hashma...

    • Answered by AI
    Add your answer
  • Q3. Jdbc step
    • Add your answer
  • Q4. Spring ioc
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was average they asked questions from core java spring hibernate... And so on..

Skills evaluated in this interview

More about working at Accion Labs

Accion Labs Interview FAQs

How many rounds are there in Accion Labs SQL and BI Developer interview?
Accion Labs interview process usually has 3 rounds. The most common rounds in the Accion Labs interview process are Coding Test, Technical and Case Study.
What are the top questions asked in Accion Labs SQL and BI Developer interview?

Some of the top questions asked at the Accion Labs SQL and BI Developer interview -

  1. All types of join...read more
  2. Technical round based on SQL medium level and tricky questio...read more
  3. be prepared for window, CTE functi...read more

Tell us how to improve this page.

Accion Labs Interviews By Designations

Interview Questions for Popular Designations

Accion Labs SQL and BI Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Accion Labs Helping transform businesses through emerging technologies

Interview Questions from Similar Companies

CitiusTech Interview Questions
3.4
 • 274 Interviews
Tiger Analytics Interview Questions
3.7
 • 227 Interviews
Bounteous x Accolite Interview Questions
3.4
 • 220 Interviews
Altimetrik Interview Questions
3.8
 • 219 Interviews
Xoriant Interview Questions
4.1
 • 183 Interviews
Incedo Interview Questions
3.1
 • 182 Interviews
Globant Interview Questions
3.8
 • 175 Interviews
Iris Software Interview Questions
4.0
 • 150 Interviews
ThoughtWorks Interview Questions
3.9
 • 148 Interviews
Apexon Interview Questions
3.3
 • 141 Interviews
View all
Accion Labs Salaries in India
Senior Software Engineer
717 salaries
unlock blur

₹7.6 L/yr - ₹33 L/yr

Principal Software Engineer
426 salaries
unlock blur

₹9.5 L/yr - ₹40 L/yr

Software Engineer
307 salaries
unlock blur

₹4.8 L/yr - ₹18.9 L/yr

Technical Lead
163 salaries
unlock blur

₹12.1 L/yr - ₹40 L/yr

Senior Principal Software Engineer
149 salaries
unlock blur

₹13.5 L/yr - ₹36.1 L/yr

Explore more salaries
Compare Accion Labs with

Xoriant

4.1
Compare

Photon Interactive

4.1
Compare

CitiusTech

3.3
Compare

Iris Software

4.0
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview