Premium Employer

i

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

AmBoxDemo-ChennaiHQ Verified Tick

Compare button icon Compare button icon Compare
4.3

based on 9 Reviews

Filter interviews by

AmBoxDemo-ChennaiHQ Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

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

I applied via LinkedIn and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Technical 

(6 Questions)

  • Q1. Current day to day tasks
  • Ans. 

    My current day-to-day tasks involve designing and implementing data pipelines, optimizing data storage and retrieval, and collaborating with cross-functional teams.

    • Designing and implementing data pipelines to extract, transform, and load data from various sources

    • Optimizing data storage and retrieval processes for efficiency and scalability

    • Collaborating with cross-functional teams to understand data requirements and del...

  • Answered by AI
  • Q2. Question on data modelling(star vs snowflake)
  • Q3. Questions on data warehousing Dimensions, Facts, CDC, SCD types
  • Q4. Questions on snowflake product and variety on objects there use case and optimizations, partition pruning.
  • Q5. SQL queries: as per snowflake documentation 1. Read json file and extract data 2. sql query with subqueries to update records 3. sql query on window functions
  • Q6. Easy Pyspark coding question.
Round 2 - Technical 

(7 Questions)

  • Q1. Project end to end detailed explanation and follow up questions.
  • Q2. Questions on data warehousing concepts like facts & dimensions in detail
  • Q3. Question on semi structured file formats
  • Q4. Questions on snowflake product: 1. tasks 2. streams 3. time travel 4. meta data caching 5. views vs materialized views 6. how would you spin up an warehouse cluster
  • Q5. Questions on spark 1. lazy evaluation 2. handling skew 3. data partitioning 4. pandas vs spark
  • Q6. Questions on aws 1. lambda functions, synchronous vs asynchronous calls 2. dynamic frames, transformations 3. glue crawler 4. s3 storage classes
  • Q7. SQL question using cross join, python question on string
Round 3 - Technical 

(6 Questions)

  • Q1. End to end project architecture.
  • Ans. 

    The end-to-end project architecture involves designing and implementing the entire data pipeline from data ingestion to data visualization.

    • Data ingestion: Collecting data from various sources such as databases, APIs, and files.

    • Data processing: Cleaning, transforming, and aggregating the data using tools like Apache Spark or Hadoop.

    • Data storage: Storing the processed data in data warehouses or data lakes like Amazon S3 ...

  • Answered by AI
  • Q2. Questions on data modelling: 1. facts and types of facts 2. dimensions and its types 3. normalization vs denormalization
  • Q3. Questions on automating spark notebooks and optimization on spark job.
  • Q4. How to migrate 1000s of tables using spark(databricks) notebooks
  • Ans. 

    Use Spark (Databricks) notebooks to migrate 1000s of tables efficiently.

    • Utilize Spark's parallel processing capabilities to handle large volumes of data

    • Leverage Databricks notebooks for interactive data exploration and transformation

    • Automate the migration process using scripts or workflows

    • Optimize performance by tuning Spark configurations and cluster settings

  • Answered by AI
  • Q5. Questions on delta format
  • Q6. Sql question on joins and numbers of records for each type of join.
Round 4 - HR 

(3 Questions)

  • Q1. Reason for change
  • Ans. 

    Seeking new challenges and opportunities for growth in a more dynamic environment.

    • Desire for new challenges and learning opportunities

    • Seeking a more dynamic work environment

    • Looking to expand skill set and experience

    • Interested in working on cutting-edge technologies

    • Seeking better career advancement prospects

  • Answered by AI
  • Q2. Expectations from EPAM
  • Ans. 

    I expect EPAM to provide challenging projects, opportunities for growth, a collaborative work environment, and support for continuous learning.

    • Challenging projects that allow me to utilize my skills and knowledge

    • Opportunities for professional growth and advancement within the company

    • A collaborative work environment where teamwork is valued

    • Support for continuous learning through training programs and resources

  • Answered by AI
  • Q3. Willing to relocate? when can you join
  • Ans. 

    Yes, I am willing to relocate for the right opportunity. I can join the company within 4 weeks.

    • Willing to relocate for the right opportunity

    • Can join within 4 weeks

    • Open to discussing relocation assistance if needed

  • Answered by AI

Interview Preparation Tips

Topics to prepare for EPAM Systems Senior Data Engineer interview:
  • work experience
  • SQL
  • Python
  • Spark
  • snowflake
Interview preparation tips for other job seekers - They have a very structured process and technical interviews last 1-1.5 hours, so you will have enough opportunities to showcase your skills. Prepare for the JD thoroughly.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Mcq questions on python aws database and networks ans os

Round 2 - Group Discussion 

8 members in a panel and they gave a topic generally a social issue or a general topic you can a lot about

Round 3 - Technical 

(4 Questions)

  • Q1. Project based questions
  • Q2. Python and pandas core question
  • Q3. Dsa question combination sum
  • Q4. Database queries
Round 4 - Manegerial 

(2 Questions)

  • Q1. Question to test your soft skills
  • Q2. About behavioral attitude and how likely you are to fit in their organization

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview at yash technologies is a scam
I appeared in process through campus at yash technologies indore in December2024. I had 4 rounds, OA, GD, F2F technical and mangerial round. All the rounds went well. Total 32 students appeared in last managerial round. After waiting for 20 days results were disclosed. 5 students selected SURPRISE
2 of them were those who didn't even cleared the first round
1one failed in technical interview and was not selected for managerial
1one didn't appeared in interview
But wovvv wov wov they were selected
They had a relatives working in yash
So to work with you need not to even appear in interview just have a relative working there.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
  • Q2. What are stored procedures in Snowflake, and how did you utilize them?
Round 2 - Technical 

(2 Questions)

  • Q1. How did you verify the data after transferring it from one database to another?
  • Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Round 3 - HR 

(2 Questions)

  • Q1. Are you open to relocating to Hyderabad?
  • Q2. What information do you have about ValueLabs?

Interview Preparation Tips

Topics to prepare for ValueLabs Senior Software Engineer interview:
  • Snowflake
  • SQL
  • Python
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 Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What is the Singleton pattern ? in how many ways can this pattern be broken ?
  • Ans. 

    Singleton pattern ensures a class has only one instance and provides a global point of access to it.

    • Singleton pattern can be implemented by making the constructor private and providing a static method to access the instance.

    • The pattern can be broken by using reflection to access the private constructor and create multiple instances.

    • Another way to break the Singleton pattern is by using multiple class loaders in Java.

    • Th...

  • Answered by AI
  • Q2. What is the internal implementation of hashmap? Let's assume that you want to store duplicate keys in the hashmap, how can we achieve the same in hashmap ?
  • Ans. 

    HashMap internally uses an array of linked lists to store key-value pairs. To store duplicate keys, we can use a custom implementation of HashMap.

    • HashMap internally uses an array of linked lists to handle collisions.

    • To store duplicate keys, we can create a custom HashMap implementation that allows multiple values for the same key.

    • One approach is to use a HashMap with values as lists, where each key can have multiple va

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. What microservices patterns are you aware ? let's assume that there is a microservice based architecture and service A is calling service B which in turn service C. If service b fails, how will you manage ...
  • Ans. 

    Use compensating transactions and distributed tracing for managing transaction and logging in case of service B failure.

    • Implement compensating transactions to rollback changes made by service B in case of failure.

    • Use distributed tracing to track the flow of requests and identify where the failure occurred.

    • Implement retry mechanisms to handle transient failures in service B.

    • Use circuit breakers to prevent cascading fail...

  • Answered by AI
  • Q2. System Design question : Design a booking wesite for.eg: bookin.com ?
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain capital markets
  • Ans. 

    Capital markets are where financial securities are bought and sold, including stocks, bonds, and commodities.

    • Capital markets facilitate the buying and selling of financial securities such as stocks, bonds, and commodities.

    • They provide a platform for companies and governments to raise capital by issuing securities to investors.

    • Investors can trade these securities through exchanges like the New York Stock Exchange (NYSE)...

  • Answered by AI
  • Q2. Explain Reconciliation, explain bond market, futures and options
  • Ans. 

    Reconciliation involves comparing two sets of records to ensure they are in agreement. Bond market, futures, and options are financial instruments used for trading.

    • Reconciliation is the process of comparing two sets of records to ensure they are in agreement, typically used in accounting to verify transactions.

    • The bond market is where investors buy and sell debt securities issued by governments or corporations, with th...

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. How do you handle audit queries
  • Ans. 

    I handle audit queries by thoroughly reviewing the information, communicating effectively with stakeholders, and providing detailed responses.

    • Thoroughly review the audit query to understand the scope and requirements

    • Communicate with relevant stakeholders to gather necessary information and clarify any doubts

    • Provide detailed responses with supporting documentation and explanations

    • Follow up on any outstanding queries to

  • Answered by AI
  • Q2. How to handle team
  • Ans. 

    Handle team by setting clear expectations, providing support, fostering open communication, and recognizing achievements.

    • Set clear expectations and goals for the team members.

    • Provide necessary support and resources to help team members succeed.

    • Foster open communication and encourage feedback from team members.

    • Recognize and reward achievements to motivate the team.

    • Address conflicts and issues promptly to maintain a posi

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't make mistake of joining this firm. I made and now again I have to find a job where atleast weekend you are not working.
Rather I was not even informed that here even some teams work on weekends. You do not get any compensation for working extra

Power Automate Architect Interview Questions & Answers

Zensar Technologies user image Anonymous

posted on 13 Jan 2025

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. API related questions. focused on RPA
  • Q2. POwer Automate best practice
  • Q3. Deployment related questions
  • Q4. Diff types of API
  • Q5. Multiple datasource use in PA

Interview Preparation Tips

Interview preparation tips for other job seekers - Moderate difficult. Asked about API, custom connector, high level qus related to power automate.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Jetpack compose, kotlin, hilt, permission, Testing,
Round 2 - Technical 

(1 Question)

  • Q1. Questions on mvvm, clean architecture.
Round 3 - Technical 

(1 Question)

  • Q1. Client round with questions on android permission, Android security
Round 4 - HR 

(1 Question)

  • Q1. Salary discussed

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong knowledge of Jetpack compose, Clea architecture, mvvm, kotlin
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Aptitude Test 

I applied through naukri and i got call from hr , the first was Aptitute Round, Basic Aptitude Questions are there and some Programing MCQ is there.

Round 2 - Technical 

(2 Questions)

  • Q1. Write a program for Palindrome String and Number, and Explain the whole logic of that program.
  • Ans. 

    Program to check if a given string or number is a palindrome.

    • Create a function to check if a given string is a palindrome by comparing characters from start and end.

    • For numbers, convert to string and then apply the same logic as for strings.

    • Examples: 'radar' is a palindrome string, 121 is a palindrome number.

  • Answered by AI
  • Q2. And Reasoning questions are there the interviewr the Questions are, if there is 8 ball with similar weight and one ball is lighter than rest , if you want to find defected ball how you found , if you can ...
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself , and about the role , and who take your technical interview , and about family background ,why you want to join that role beacause i am from IT background I am not selected after hr...
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(4 Questions)

  • Q1. Engineering Technical Questions on manufacturing process
  • Q2. Sheet Metal Work Basic
  • Q3. Casting and Machining
  • Q4. Zero based costing
Round 2 - HR 

(1 Question)

  • Q1. Salary Negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. What was your previous experience with Citrix and what responsibilities did you hold?
  • Q2. What types of P1 incidents have you handled?
  • Q3. What is the scope of work in VMware?
  • Q4. Have you had experience managing a large infrastructure setup?
  • Q5. What is the workflow process in Citrix?
Round 2 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Joining date

Tell us how to improve this page.

Join AmBoxDemo-ChennaiHQ Transforming Ideas into IT Realities.

Interview Questions from Similar Companies

EPAM Systems Interview Questions
3.8
 • 531 Interviews
Synechron Interview Questions
3.6
 • 357 Interviews
Movate Interview Questions
3.3
 • 247 Interviews
Cybage Interview Questions
3.8
 • 196 Interviews
VVDN Technologies Interview Questions
3.6
 • 190 Interviews
ValueLabs Interview Questions
3.8
 • 189 Interviews
NielsenIQ Interview Questions
3.8
 • 172 Interviews
SS&C TECHNOLOGIES Interview Questions
3.4
 • 164 Interviews
View all

AmBoxDemo-ChennaiHQ Reviews and Ratings

based on 9 reviews

4.3/5

Rating in categories

4.4

Skill development

4.3

Work-life balance

4.2

Salary

4.0

Job security

4.7

Company culture

4.3

Promotions

4.5

Work satisfaction

Explore 9 Reviews and Ratings
Compare AmBoxDemo-ChennaiHQ with

Synechron

3.6
Compare

Zensar Technologies

3.7
Compare

Capita

3.6
Compare

VVDN Technologies

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