Add office photos
Filter interviews by
Gymhop Technologies Data Manager Interview Questions and Answers
Gymhop Technologies Data Manager Interview Experiences
2 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Nov 2019. There were 6 interview rounds.
Interview Questionnaire
4 Questions
- Q1. There were 3 rounds of interview. Which are Hr, Communication and technical rounds
- Q2. Hr will ask you general questions like. tell me about yourself, why did you want to join here, why should we hire you etc.
- Q3. In communication round you will be asked how will you react in any particular situation in both written and verbal form.
- Q4. In technical round your technical skills on which you have worked upon in your previous organisation will be asked and some tasks related to data manager responsibility will be given.
Interview Preparation Tips
prashant kumar
I applied via Approached by Company
(1 Question)
- Q1. Introduce yourself
Top trending discussions
Interview questions from similar companies
Selected
I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. What is data migration
- Ans.
Data migration is the process of transferring data from one system to another.
Data migration involves transferring data from one storage system to another.
It can also involve moving data from one format to another.
Data migration is often necessary when upgrading systems or consolidating data.
Examples include migrating data from an old CRM system to a new one, or moving data from on-premises servers to the cloud.
- Q2. What are the agile methodologies within data migration
- Ans.
Agile methodologies within data migration involve iterative and incremental processes to efficiently move data from one system to another.
Scrum: Breaks down the data migration process into smaller tasks called sprints, with regular meetings to track progress.
Kanban: Visualizes the data migration workflow on a board, allowing for continuous delivery of data.
Lean: Focuses on minimizing waste and maximizing value during t...
Skills evaluated in this interview
I applied via Walk-in and was interviewed in May 2024. There were 2 interview rounds.
It was good,Who will pass the test they will get into interview otherwise they are not selected for next round.
I cleared my Aptitude test.
(1 Question)
- Q1. Just the introduction of ours and background
Interview Preparation Tips
I was interviewed in Aug 2021.
Interview Questionnaire
2 Questions
- Q1. What is Big Data
- Ans.
Big Data refers to large volumes of data that cannot be processed using traditional methods.
Big Data involves processing and analyzing large volumes of data
It includes structured, unstructured, and semi-structured data
Examples include social media data, sensor data, and financial transactions
- Q2. What is your qualifications? What are your hobbies ? What is your Ambition ? Which sports do you play ? Where are you from ?
Skills evaluated in this interview
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 5 interview rounds.
(1 Question)
- Q1. Resume screening Self introduction Roles and responsibilities
Given task Statics standard deviations Attrition Average of given table values and Given graph economi graph and poverty graph base on that need to gave answers 30 qustion and 60 min time duration
(2 Questions)
- Q1. Versant test should be need to attend Hirepro will have interview prosess in YouTube will check and prepare mid level hard
- Q2. We can goo for online prosess how it is
(1 Question)
- Q1. Manger Level round they will ask KPI NPS AHT standard deviations Service Level handling Root cause Analysis Weighted average Same product how will calculate Totall Swer % how will get Many of like bpi <20 ...
(1 Question)
- Q1. Salary discussion and update structure of our role and responsibilities
Muskan Ahirwar
Selected
I was interviewed in Dec 2024.
(2 Questions)
- Q1. What is your with career ?
- Q2. What is your graduation background.
(2 Questions)
- Q1. Motivation and career goals
- Q2. Why are you intrestedin this position ?
(2 Questions)
- Q1. What motivation ypu tp perfrom well at work ?
- Q2. What are your biggest weaknesses.
(2 Questions)
- Q1. Work ethic and adaptabllity.
- Q2. How do you handle pressure and deadlines ?
(2 Questions)
- Q1. Why did you choose this career
- Q2. What are your greatest strenth
(2 Questions)
- Q1. What is your graduation background
- Q2. What is your collage name
(2 Questions)
- Q1. How do you plan to overcome your weakness
- Q2. Why are you intrested in this position
Work done from all assigments
Interview Preparation Tips
I was interviewed in Dec 2024.
(6 Questions)
- Q1. Tell me About Yourself
- Q2. Project working and day to day activities I do
- Q3. Rate Yourself In SQL out of 5
- Q4. Sql 3 question based on windows function
- Q5. Very basic python 2 Question
- Q6. What You do on power bi in your work Explain with full details workflow
(1 Question)
- Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate
Interview Preparation Tips
I was interviewed in Dec 2024.
(2 Questions)
- Q1. They asked me regarding project
- Q2. Sql queries and data bricks related questions
(1 Question)
- Q1. Details explaination on project that I have worked and optimization techniques
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(7 Questions)
- Q1. How do you optimize SQL queries?
- Ans.
Optimizing SQL queries involves using indexes, avoiding unnecessary joins, and optimizing the query structure.
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Use EXPLAIN to analyze query performance and make necessary adjustments
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project.
- Ans.
Performance optimization in Spark involves tuning configurations, optimizing code, and utilizing caching.
Tune Spark configurations such as executor memory, number of executors, and shuffle partitions.
Optimize code by reducing unnecessary shuffles, using efficient transformations, and avoiding unnecessary data movements.
Utilize caching to store intermediate results in memory and avoid recomputation.
Example: In my projec...
- Q3. What is SparkContext and SparkSession?
- Ans.
SparkContext is the main entry point for Spark functionality, while SparkSession is the entry point for Spark SQL.
SparkContext is the entry point for low-level API functionality in Spark.
SparkSession is the entry point for Spark SQL functionality.
SparkContext is used to create RDDs (Resilient Distributed Datasets) in Spark.
SparkSession provides a unified entry point for reading data from various sources and performing
- Q4. When a spark job is submitted, what happens at backend. Explain the flow.
- Ans.
When a spark job is submitted, various steps are executed at the backend to process the job.
The job is submitted to the Spark driver program.
The driver program communicates with the cluster manager to request resources.
The cluster manager allocates resources (CPU, memory) to the job.
The driver program creates DAG (Directed Acyclic Graph) of the job stages and tasks.
Tasks are then scheduled and executed on worker nodes ...
- Q5. Calculate second highest salary using SQL as well as pyspark.
- Ans.
Calculate second highest salary using SQL and pyspark
Use SQL query with ORDER BY and LIMIT to get the second highest salary
In pyspark, use orderBy() and take() functions to achieve the same result
- Q6. 2 types of modes for Spark architecture ?
- Ans.
The two types of modes for Spark architecture are standalone mode and cluster mode.
Standalone mode: Spark runs on a single machine with a single JVM and is suitable for development and testing.
Cluster mode: Spark runs on a cluster of machines managed by a cluster manager like YARN or Mesos for production workloads.
- Q7. If you want very less latency - which is better standalone or client mode?
- Ans.
Client mode is better for very less latency due to direct communication with the cluster.
Client mode allows direct communication with the cluster, reducing latency.
Standalone mode requires an additional layer of communication, increasing latency.
Client mode is preferred for real-time applications where low latency is crucial.
(2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset.
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and nested query will be expensive. Optimized query...
Interview Preparation Tips
- SQL
- pyspark
- ETL
Skills evaluated in this interview
Gymhop Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
Interview Questions from Similar Companies
|
Software Developer
4
salaries
|  ₹6.5 L/yr - ₹8.8 L/yr |
|
Senior IOS Developer
3
salaries
| ₹5.5 L/yr - ₹5.5 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Gymhop Technologies Interview Questions >
- Gymhop Technologies Data Manager Interview Questions
