Add office photos
Filter interviews by
HGF Limited Interview Questions and Answers
HGF Limited Interview Experiences
2 interviews found
Anonymous
I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.
Questions were very much and over hyped
Python to bash conversion
Interview Preparation Tips
Network Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Feb 2023. There were 3 interview rounds.
Java coding aptitude multithreading Spring boot Spring beans multi threading
Coding Questions
Java core
java basic
OOps
Class
Exception Handler
Spring Boot
Spring
Interview Preparation Tips
Software Engineer Interview Questions asked at other Companies
Interview questions from similar companies
ABHISHEK JHA
I applied via Company Website and was interviewed in Oct 2024. There were 4 interview rounds.
(2 Questions)
- Q1. Deep dive on current migration project and architecture, Type of dimensional modelling , normalization & de normalization
- Q2. Which AWS services used and AWS architecture for those services
- Ans.
AWS services used include S3, Redshift, Glue, EMR, and Lambda in a scalable and cost-effective architecture.
AWS S3 for storing large amounts of data
AWS Redshift for data warehousing and analytics
AWS Glue for ETL processes
AWS EMR for big data processing
AWS Lambda for serverless computing
(5 Questions)
- Q1. Current project end to end explanation
- Ans.
Developed a real-time data processing pipeline for analyzing customer behavior
Designed and implemented data ingestion process using Apache Kafka
Utilized Apache Spark for data processing and analysis
Built data models and visualizations using tools like Tableau
Implemented machine learning algorithms for predictive analytics
- Q2. Questions on spark optimization, Coalesce/Repartition, Handling data skew
- Q3. Explain spark submit command in detail
- Ans.
Spark submit command is used to submit Spark applications to a cluster
Used to launch Spark applications on a cluster
Requires specifying the application JAR file, main class, and any arguments
Can set various configurations like memory allocation, number of executors, etc.
Example: spark-submit --class com.example.Main --master yarn --deploy-mode cluster myApp.jar arg1 arg2
- Q4. SQL question on self join
- Q5. Easy Python question on printing even numbers in a range
(4 Questions)
- Q1. Current project explanation end to end
- Ans.
Developed a real-time data processing pipeline for analyzing customer behavior
Designed and implemented data ingestion process using Apache Kafka
Utilized Apache Spark for data processing and analysis
Built data models and visualizations using tools like Tableau
Implemented machine learning algorithms for predictive analytics
- Q2. PySpark coding question
- Q3. Question on spark internals JVM & GC
- Q4. Configure Cluster for 100 TB data
- Ans.
To configure a cluster for 100 TB data, consider factors like storage capacity, processing power, network bandwidth, and fault tolerance.
Choose a distributed storage system like HDFS or Amazon S3 for scalability and fault tolerance.
Select high-capacity servers with sufficient RAM and CPU for processing large volumes of data.
Ensure high-speed network connections between nodes to facilitate data transfer.
Implement data r...
(3 Questions)
- Q1. Current project architecture end to end
- Ans.
Our current project architecture involves a microservices-based approach with data pipelines for real-time processing.
Utilizing microservices architecture for scalability and flexibility
Implementing data pipelines for real-time processing of large volumes of data
Leveraging cloud services such as AWS or Azure for infrastructure
Using technologies like Apache Kafka for streaming data
Ensuring data quality and reliability t
- Q2. Case study with order management , Create Facts & dimension for Amazon orders
- Q3. SQL query to find the 2nd most order item in a category
- Ans.
Use a SQL query with a subquery to find the 2nd most ordered item in a category.
Use a subquery to rank items within each category based on the number of orders
Select the item with rank 2 within each category
Order the results by category and rank to get the 2nd most ordered item in each category
Interview Preparation Tips
- AWS
- Pyspark
- SQL
- Python
- Data Modeling
Skills evaluated in this interview
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
I am currently graduating. I am in the 2nd year of B.Sc. this year.
(3 Questions)
- Q1. What is the work in technical
- Q2. How is technology used
- Ans.
Technology is used in the workplace for communication, organization, automation, and efficiency.
Communication: Email, messaging apps, video conferencing
Organization: Project management tools, calendars, cloud storage
Automation: Workflow automation, data entry automation
Efficiency: Time tracking software, collaboration platforms
- Q3. What work will be given to me in technical
Interview Preparation Tips
- Aptitude
- Personality Development
- Communication Skills
- Knowledge Management
Selected
I applied via Referral and was interviewed before Jan 2024. There were 4 interview rounds.
Email writing, speaking
(2 Questions)
- Q1. Tell me about yourself
- Q2. What is integreon
(2 Questions)
- Q1. Tell me About yourself
- Q2. About your previous experience
(2 Questions)
- Q1. Email writing conversation
- Q2. Tell me about yourself
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
Two hours and 32 questions
(2 Questions)
- Q1. Write commands for DML
- Ans.
DML commands are used to manipulate data in a database. Examples include INSERT, UPDATE, DELETE.
INSERT: Adds new data into a table
UPDATE: Modifies existing data in a table
DELETE: Removes data from a table
- Q2. Write commands for Joins
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
INNER JOIN: Returns rows when there is at least one match in both 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 JOIN: Returns rows when there is a match in one of the tables
(2 Questions)
- Q1. Ask questions regarding advance excel
- Q2. Ask questions from Power BI
Interview Preparation Tips
- SQL
failure become success one day
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Take me through your profile?
- Ans.
Experienced Senior Manager with a proven track record in leading teams and driving business growth.
Over 10 years of experience in management roles
Successfully led cross-functional teams to achieve project milestones
Implemented strategies that resulted in a 20% increase in revenue
Strong communication and leadership skills
MBA in Business Administration from XYZ University
- Q2. Why do you want to change ?
- Ans.
Seeking new challenges and opportunities for growth.
Desire for new challenges and learning experiences
Opportunity for career advancement
Seeking a more dynamic work environment
Wish to broaden skill set and knowledge
Desire for increased responsibility and leadership roles
(1 Question)
- Q1. Questions related to Strategic sourcing?
IT Helpdesk Engineer Interview Questions & Answers
Quislex Legal Services
priyanka bollepally
posted on 25 Oct 2024
Selected
(1 Question)
- Q1. Explain about job description
(3 Questions)
- Q1. Checking communication skills
- Q2. Self introduction
- Q3. Basic questions about ticketingtool
HR Executive Interview Questions & Answers
Aparajitha Corporate Services
Aman Vishwakarma
posted on 4 Jan 2025
Selected
(2 Questions)
- Q1. CLRA related questions
- Q2. EPF related questions
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Previous experience
- Q2. Question on automobiles
Interview Preparation Tips
- Automobile
- Mechanical Engineering
HGF Limited Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
Aparajitha Corporate Services
Integreon
UnitedLex
Y-Axis Overseas Careers
Calculate your in-hand salary
- Home >
- Interviews >
- HGF Limited Interview Questions
