Upload Button Icon Add office photos

Filter interviews by

Amit Sharma Interview Questions and Answers

Updated 8 Nov 2020

Amit Sharma Interview Experiences

1 interview found

I applied via Referral and was interviewed in May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Question related to debt recovery tribunal, how to SA or OA in drt , writ petition in high court, service matter, recovery suits, questions related to 138 NI Act, divorce petition etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Poor salary , salary not timely paid , work atmosphere not good, always scolding and using hard words by boss to its employees

Senior Legal Associate Interview Questions asked at other Companies

Q1. What is the difference between lease and licence agreement?
View answer (1)

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
2
Poor
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I was interviewed in Dec 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Basic Communication Skills
  • Q2. Background and why to change the job
Round 2 - Technical 

(2 Questions)

  • Q1. Brief about your background
  • Q2. Excel and SQL basic questions. For data visualisation.
Round 3 - Technical 

(2 Questions)

  • Q1. What are the roles you were responsible for in previous company
  • Q2. Pivot tables and Financial basic questions on revenue.
Round 4 - One-on-one 

(3 Questions)

  • Q1. How do you think will fit in the role?
  • Q2. Basic understanding of Revenue and Financial statements.
  • Q3. What do you want to do in life? The goal.
Round 5 - HR 

(3 Questions)

  • Q1. Basic communication skills with the background test.
  • Q2. Why this role suits you.
  • Q3. Current and expectation of salary.

Interview Preparation Tips

Interview preparation tips for other job seekers - My intervoew went excellent, but I think there was a budget issue which they didn't clarify in the beginning. Plus, I kept following up with the HR she doesn't responde. Pathetically annoying TA team. At least these people should have told me if I was not selected after the 5 rounds of interview and time wasting.

I in the beginning got really good bg from finance team that the company is good and employee oriented. My experience was way worse than that. This new "Job hai" has poor management and no ethics.
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 4 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced client servicing executive with a strong background in building and maintaining client relationships.

    • Over 5 years of experience in client servicing roles

    • Skilled in communication, problem-solving, and relationship management

    • Successfully managed a portfolio of key clients, increasing retention rates by 20%

    • Proficient in CRM software and client communication tools

  • Answered by AI
  • Q2. About internship in details
Round 2 - HR 

(2 Questions)

  • Q1. Normal introduction
  • Q2. Tell me about IndiaMART
  • Ans. 

    IndiaMART is India's largest online B2B marketplace connecting buyers with suppliers.

    • Founded in 1996 by Dinesh Agarwal and Brijesh Agarwal

    • Over 60 million registered users and 5 million suppliers

    • Offers a platform for businesses to list their products and services

    • Facilitates transactions between buyers and sellers across various industries

    • Provides a wide range of products from machinery to consumer goods

  • Answered by AI
Round 3 - Behavioral 

(8 Questions)

  • Q1. Tell me about yourself in briefly
  • Ans. 

    Experienced client servicing executive with a strong background in building and maintaining client relationships.

    • Over 5 years of experience in client servicing roles

    • Skilled in communication, problem-solving, and relationship management

    • Successfully managed a portfolio of key clients, increasing retention rates by 20%

    • Proficient in CRM software and data analysis tools

  • Answered by AI
  • Q2. About internship
  • Q3. About marketing and sales
  • Q4. Why do you choose the field work
  • Ans. 

    I choose field work because I enjoy interacting with clients and solving problems face-to-face.

    • I thrive in dynamic environments where I can think on my feet

    • I value building strong relationships with clients through personal interactions

    • I find satisfaction in seeing the direct impact of my work in real-time

    • I enjoy the challenge of problem-solving on the spot

  • Answered by AI
  • Q5. About IndiaMART
  • Q6. Why do you choose the IndiaMART and job description
  • Ans. 

    I chose IndiaMART because of its strong reputation in the industry and the opportunity to work with a diverse range of clients.

    • IndiaMART is a well-established company in the B2B marketplace, known for its reliable services and wide network.

    • I am attracted to the dynamic nature of the client servicing role at IndiaMART, where I can interact with clients from various industries and provide tailored solutions.

    • The job descr...

  • Answered by AI
  • Q7. What is your strength and weakness
  • Ans. 

    Strength: Strong communication skills. Weakness: Overthinking.

    • Strength: Effective verbal and written communication abilities

    • Strength: Ability to build and maintain strong client relationships

    • Weakness: Tendency to overthink situations and decisions

    • Weakness: Struggle with delegating tasks to others

  • Answered by AI
  • Q8. Skills and hobbies and achievements
Round 4 - Face to face round 

(6 Questions)

  • Q1. About yourself in briefly
  • Q2. Hobbies
  • Q3. Skills
  • Q4. Achivement
  • Q5. About IndiaMART or job descriptions
  • Q6. Why do you choose IndiaMART
  • Ans. 

    I chose IndiaMART for its extensive network of suppliers and quality customer service.

    • Extensive network of suppliers allows for a wide range of products and services

    • Quality customer service ensures smooth transactions and timely resolution of issues

    • User-friendly platform makes it easy to search for products and connect with suppliers

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I think this is best opportunity for me because IndiaMART is trusted company and IndiaMART pay good amount of money. The best thing IndiaMART pay weekly salary.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Technical 

(5 Questions)

  • Q1. What are the standards for scaffolding codes?
  • Q2. What are the different types of scaffolding erection?
  • Q3. What type of use material for safety purchase
  • Q4. How to safe Erection
  • Q5. Identify risk and hazard

Interview Preparation Tips

Interview preparation tips for other job seekers - We are erecting scaffolding according to the company's standards.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
  • Q2. What is the process flow for implementing an incremental load?
  • Q3. What are the steps involved in query optimization?
  • Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
  • Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Technical 

(5 Questions)

  • Q1. I am krishna murthy p
  • Q2. I am Instrested bmm ispat company one of the best company
  • Q3. One opportunity given sir
  • Q4. Electrical engineering
  • Q5. I am name krishna murthy p i am stady diploma electrical engineering I am experience totally 8 years

Interview Preparation Tips

Interview preparation tips for other job seekers - One chanse bmm ispat company I am working I am email ***** i am phone number XXXXX
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. For job seekers, key advice includes: tailoring your resume to each job application, actively networking, researching companies thoroughly before applying, practicing interview skills, following up with po...
Round 2 - One-on-one 

(1 Question)

  • Q1. For job seekers, key advice includes: tailoring your resume to each job application, actively networking, researching companies thoroughly before applying, practicing interview skills, following up with po...
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 ?

Deputy Regional Planning Manager Interview Questions & Answers

Shapoorji Pallonji Group user image Anonymous

posted on 7 Dec 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com

Round 1 - Technical 

(10 Questions)

  • Q1. Brief about your education, career, previous projects handled, and role & responsibility in past organisations?
  • Q2. Current roles & responsibilities and value addition done by you and your team?
  • Q3. Process flow for planning throughout project life-cycle?
  • Q4. Critical/concerning areas to be monitored?
  • Q5. Productivity and permissible material wastage, process to prepare material reconciliation?
  • Q6. Understanding about claim and type of claim raised/supported to raise in past experience?
  • Q7. Experience of technical aspects and planning assessment required at tendering stage, capabilities to prepare tender submittals and proving insights to management on same?
  • Q8. Necessity of providing PMO support to management?
  • Q9. Understanding about role & responsibility of regional planning manager?
  • Q10. MIS and type of reports prepared in past and their significance for Top managemennt?

Tell us how to improve this page.

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.2k Interviews
Asian Paints Interview Questions
4.0
 • 632 Interviews
Vodafone Idea Interview Questions
4.1
 • 550 Interviews
EPAM Systems Interview Questions
3.8
 • 533 Interviews
ZS Interview Questions
3.4
 • 482 Interviews
Siemens Interview Questions
4.1
 • 427 Interviews
Tata Projects Interview Questions
4.2
 • 413 Interviews
Goldman Sachs Interview Questions
3.5
 • 408 Interviews
Synechron Interview Questions
3.6
 • 358 Interviews
View all

Amit Sharma Reviews and Ratings

based on 15 reviews

3.9/5

Rating in categories

3.9

Skill development

3.7

Work-life balance

3.7

Salary

3.8

Job security

3.8

Company culture

3.8

Promotions

3.7

Work satisfaction

Explore 15 Reviews and Ratings
Technician
4 salaries
unlock blur

₹2.7 L/yr - ₹2.9 L/yr

Area Sales Manager
3 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Junior Accountant
3 salaries
unlock blur

₹1.2 L/yr - ₹3 L/yr

Electrician
3 salaries
unlock blur

₹0.2 L/yr - ₹0.2 L/yr

CAR Driver
3 salaries
unlock blur

₹2 L/yr - ₹3 L/yr

Explore more salaries
Compare Amit Sharma with

BYJU'S

3.1
Compare

Vodafone Idea

4.1
Compare

Asian Paints

4.0
Compare

Tata Projects

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