AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Broadridge Financial Solutions Lead Data Engineer Interview Questions, Process, and Tips
Broadridge Financial Solutions Lead Data Engineer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.
(5 Questions)
- Q1. What is datawarehouse
- Ans.
A datawarehouse is a centralized repository that stores integrated and structured data from multiple sources for analysis and reporting.
Datawarehouse stores historical data for analysis
It is used for decision-making and business intelligence
Data is extracted, transformed, and loaded (ETL) into the datawarehouse
Examples: Amazon Redshift, Snowflake, Google BigQuery
- Q2. How to open multiple sessions in postgresql
- Ans.
To open multiple sessions in PostgreSQL, you can use multiple connections from different clients.
Use different client applications to connect to the PostgreSQL database with different credentials
Each client connection will create a separate session in PostgreSQL
You can also use connection pooling to manage multiple sessions efficiently
- Q3. How to flatten json
- Ans.
Flattening JSON involves converting nested JSON structures into a flat key-value format.
Use a programming language with built-in functions for flattening JSON, such as Python's json_normalize() function.
Recursively iterate through the JSON structure to extract all nested key-value pairs.
Map each nested key to a flat key by joining the parent keys with a separator, such as a dot.
Handle arrays by creating separate keys f
- Q4. How to flatten xml in python
- Ans.
Use the xmltodict library in Python to flatten XML data structures.
Install the xmltodict library using pip install xmltodict
Use xmltodict.parse() to convert XML data to a Python dictionary
Use json.dumps() to convert the dictionary to a JSON string for a flattened structure
- Q5. How to do self join
- Ans.
Self join is used to join a table with itself to compare rows within the same table.
Use the same table name for both instances in the query
Specify aliases for each instance of the table to differentiate them
Use a join condition to specify how the rows should be matched
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
(1 Question)
- Q1. .net questions - routing in asp.net MVC ?
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
(1 Question)
- Q1. Basic question from C++.Some questions from Data structure and computer architecture.
Interview Preparation Tips
- C++
I was interviewed in Sep 2016.
Interview Questionnaire
2 Questions
- Q1. Tell me about Your project
- Ans.
Developed a web-based project management tool for a software development company.
Used Agile methodology for development
Implemented features like task assignment, progress tracking, and team collaboration
Integrated with third-party tools like GitHub and Slack
Designed a user-friendly interface with responsive design
Deployed on AWS using EC2 and RDS
- Q2. Tell me about your CV!
- Ans.
My CV showcases my experience in software development, including projects in Java, Python, and web development.
Experience in Java, Python, and web development
Worked on projects involving database management systems
Familiar with Agile development practices
Interview Preparation Tips
Experience: Tough! But manuplative ,yes manuplative ,I feel that your test scores are manuplated by the company! You score full marks in the test , but you are mechanical engineer you might not qualify for the next round! I say this as per ny experience . POINTER ,BRANCH and then score in this test describe the overall perfomance!
Tips: The company is totally for IT engineers if you are from other branch fonnot hope much, have a backup.
Duration: 1 hour 20 minutes
Total Questions: 80
Round: Technical + HR Interview
Experience: They Play with your minds,yes they do! Believe me donot show tough expressions!
Tips: Stay Calm ,they are not to scare you!
Skills: Technical, knowledge, gritt, Behavioural Skills
College Name: Atharva College Of Engineering
I was interviewed in May 2017.
Interview Questionnaire
1 Question
- Q1. Tell me about your Project done in 4th year Btech
- Ans.
Developed a web-based project management system for tracking tasks and deadlines.
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Utilized Agile methodology for project management
Interview Preparation Tips
Duration: 3 hours
Round: Technical + HR Interview
Experience: They asked several questions regarding all the bio data and some computer questions and some hr level questions
Round: Resume Shortlist
Experience: Resume got shortlisted and I got the Job that time I even can't believe that
College Name: ITER BHUBANESWSR
Vardaan Kumar
I was interviewed before Jun 2016.
Interview Questionnaire
2 Questions
- Q1. How to start an induction motor?
- Ans.
An induction motor can be started by providing a rotating magnetic field.
Use a three-phase power supply to create a rotating magnetic field
The magnetic field induces a current in the rotor, causing it to rotate
The motor may require a starting capacitor or a starting winding to provide the initial torque
Once the motor reaches its rated speed, the starting mechanism can be switched off
- Q2. Tell me something about yourself?
- Ans.
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
Experienced in full stack web development
Proficient in languages like JavaScript, Python, and Java
Familiar with frameworks like React, Node.js, and Spring Boot
Strong problem-solving and analytical skills
Excellent team player with good communication skills
Interview Preparation Tips
Experience: It was a wonderful experience overall. Giving an online test with my batch mates was amazing. I did the test very well and with ease.
Tips: Just enter the exam hall with confidence...
Duration: 1 hour 30 minutes
Total Questions: 90
Round: Technical + HR Interview
Experience: As I was strong in basics so I was able to answer this quest. He asked few related questions and I was able to give right answers.
Tips: Be strong in core subject basics and forget the rest of the subjects completely. They just want to see how much faithful you are with whatever you do. Moreover, just tell your name, state of birth, schooling, hobbies, etc(with free mind). They are just recruiters and not butchers, so stay calm as much as you can.
College Name: Maharaja Agrasen Institute Of Technology, Delhi
I was interviewed in Mar 2017.
Interview Preparation Tips
I was interviewed in Dec 2016.
Interview Questionnaire
1 Question
- Q1. About yourself and technical questions
Interview Preparation Tips
Experience: We had an aptitude test with puzzles and verbal
Tips: Concentrate on aptitude
Duration: 1 hour
Total Questions: 60
Round: Technical + HR Interview
Experience: Formal question are asked and mostly communication is important
College Name: Sri Krishna College Of Engineering And Technology
I was interviewed before May 2016.
Interview Questionnaire
3 Questions
- Q1. Why do u want to enter software industry??
- Ans.
Passion for problem-solving and creating innovative solutions drives my interest in software industry.
Passion for problem-solving and creating innovative solutions
Interest in technology and its impact on society
Opportunity for continuous learning and growth
Desire to work on cutting-edge projects and contribute to advancements in the field
- Q2. Why infosys??
- Ans.
Infosys is a global leader in technology services and consulting, known for its innovative solutions and strong company culture.
Infosys has a strong reputation for delivering high-quality technology solutions to clients worldwide.
The company offers a wide range of opportunities for career growth and development.
Infosys has a collaborative and inclusive work culture that values diversity and innovation.
- Q3. Tell something about ur final year project
- Ans.
Developed a web-based project management system for tracking tasks and deadlines
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Tested the system for performance and security vulnerabilities
Interview Preparation Tips
Experience: In this round company chooses the resume of candidates they believe are suitable for the job
Round: Test
Experience: This round basically tests your logical reasoning skills and your mathematical ability
Duration: 30 minutes
Total Questions: 60
Round: Technical Interview
Experience: Being a metallurgical engineer and trying to enter in a software industry I was mostly asked as to why I want to enter into this sector and other hr questions. To some extent I was drilled on my final year project in engineering
College Name: NIT Raipur
Broadridge Financial Solutions Interview FAQs
Recently Viewed
INTERVIEWS
Broadridge Financial Solutions
No Interviews
SALARIES
Wipro
No Salaries
JOBS
ION Group
No Jobs
JOBS
IntouchCX
No Jobs
JOBS
Supai Infotech India
No Jobs
REVIEWS
Broadridge Financial Solutions
No Reviews
JOBS
NxtWave
No Jobs
INTERVIEWS
Wipro
10 top interview questions
REVIEWS
Broadridge Financial Solutions
No Reviews
JOBS
Amazon
No Jobs
Tell us how to improve this page.
Broadridge Financial Solutions Interviews By Designations
- Broadridge Financial Solutions Process Analyst Interview Questions
- Broadridge Financial Solutions Member Technical Interview Questions
- Broadridge Financial Solutions Analyst Interview Questions
- Broadridge Financial Solutions Software Engineer Interview Questions
- Broadridge Financial Solutions Senior Member Technical Interview Questions
- Broadridge Financial Solutions Software Developer Interview Questions
- Broadridge Financial Solutions Intern Interview Questions
- Broadridge Financial Solutions Senior Process Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Data Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Datastage Developer Interview Questions
- Database Architect Interview Questions
- Show more
Broadridge Financial Solutions Lead Data Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Process Analyst
1.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Member Technical
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Member Technical
609
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
585
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Process Analyst
581
salaries
| ₹0 L/yr - ₹0 L/yr |
Fiserv
SS&C TECHNOLOGIES
State Street Corporation
BNY
- Home >
- Interviews >
- Broadridge Financial Solutions Interview Questions >
- Broadridge Financial Solutions Lead Data Engineer Interview Questions
