AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Blenheim
Chalcot
Compare
Filter interviews by
Blenheim Chalcot Senior Data Engineer Interview Questions and Answers
Blenheim Chalcot Senior Data Engineer Interview Experiences
1 interview found
Ajay Kushwaha
Selected
I appeared for an interview before May 2024, where I was asked the following questions.
- Q1. How you have build ETL pipeline in your last company?
- Ans.
I built an ETL pipeline to extract, transform, and load data efficiently, ensuring data quality and accessibility for analytics.
Data Extraction: Used Apache NiFi to extract data from various sources like SQL databases and REST APIs, ensuring real-time data availability.
Data Transformation: Implemented transformation logic using Apache Spark to clean and aggregate data, such as removing duplicates and normalizing format...
- Q2. Scenario based question - how to load incremental data into postgresql tables ?
- Ans.
Incremental data loading in PostgreSQL involves identifying and inserting only new or updated records.
Use a timestamp column to track changes. For example, 'last_updated' can help identify new records.
Implement a staging table to temporarily hold incoming data before merging it into the main table.
Utilize the 'INSERT ... ON CONFLICT' statement to handle duplicates efficiently.
Schedule regular ETL jobs using tools like ...
- Q3. How to do monitoring via cloudwatch logs and visualization dashboard?
- Ans.
CloudWatch logs enable monitoring and visualization of AWS resources, providing insights into application performance and operational health.
Log Group Creation: Organize logs into groups for easier management. For example, create a log group for each microservice in your architecture.
Metric Filters: Set up metric filters to extract specific data from logs, such as error rates or latency, and create CloudWatch metrics f...
Top trending discussions
Interview questions from similar companies
Software Engineer Interview Questions & Answers
In Time Tec Visionsoft
Anonymous
posted on 12 Jan 2023
Selected
I applied via Referral and was interviewed before Jan 2022. There were 3 interview rounds.
Basic coding question will be there
(2 Questions)
- Q1. Opps , dbms , data structure
- Q2. Explain about inheritence
- Ans.
Inheritance is a mechanism in object-oriented programming where a class can inherit properties and methods from another class.
Inheritance allows for code reuse and promotes code organization.
The class that is being inherited from is called the parent or base class.
The class that inherits from the parent class is called the child or derived class.
The child class can access all the public and protected members of the par...
Interview Preparation Tips
Hina Sharma
I applied via Naukri.com and was interviewed in Aug 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Java skills, why do you want to work here
- Q2. How are you suitable for this role
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jul 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Most of the questions are on tell me about yourself, ur previous projects, rest Api, sql, java
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Jan 2021. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. I have been questioned on AEM Concepts, Sling Models, schedulers, servlets, OSGI services
- Q2. Be prepared for most of the concepts in AEM
Interview Preparation Tips
What are the roles & responsibilities of a Senior Data Engineer at Blenheim Chalcot?
Read full roles & responsibilities 
I applied via Monster and was interviewed before Dec 2021. There were 5 interview rounds.
Java, SQL, SDLC agile, db queries, Http response and request codes status
(3 Questions)
- Q1. Questions related to resume, ds we worked on, http status cod eand response, related to rest api
- Q2. Hash set internal working, how do you fine second largest element in an array without sorting,
- Ans.
Finding second largest element in an array without sorting using hash set.
Create a hash set and iterate through the array, adding each element to the set.
Initialize two variables to keep track of the largest and second largest elements.
Iterate through the set and compare each element to the largest and second largest variables.
Return the second largest variable.
- Q3. Idempotent methods, safe methods in http, rest api working, to find en element from binary array related program
(1 Question)
- Q1. Same as technical 2, more ds related questions and http rest related
(1 Question)
- Q1. Salary discussion ask as much as you can, don't hesitate
Interview Preparation Tips
Skills evaluated in this interview
Blenheim Chalcot HR Interview Questions
I applied via LinkedIn
Interview Questionnaire
1 Question
- Q1. I have been questioned on different concepts in AEM, sling models, services, servlets, schedulers, workflow
Interview Preparation Tips
(2 Questions)
- Q1. What is angular
- Q2. What is an angular
Skills evaluated in this interview
Senior Software Engineer Interview Questions & Answers
TestingXperts
Anonymous
posted on 13 Feb 2023
(1 Question)
- Q1. .net core middleware
(1 Question)
- Q1. Manament discusion about your last project and responsibility
(1 Question)
- Q1. Salary discusion and designation and preferred loaction
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jun 2022. There were 4 interview rounds.
Total 35 questions, with 5 sections and time duration 35 minutes.
(1 Question)
- Q1. What all the methods we have in API?
- Ans.
The question is too broad to provide a specific answer.
APIs can have various methods such as GET, POST, PUT, DELETE, etc.
The methods in an API depend on the specific API being referred to.
Examples of API methods include 'getUser', 'createOrder', 'updateProfile', etc.
(1 Question)
- Q1. What problems you have faced during testing?
- Ans.
I have faced issues with compatibility, performance, and user acceptance testing.
Compatibility issues with different browsers and operating systems
Performance issues with large datasets and high traffic
User acceptance testing revealed unexpected user behavior
(1 Question)
- Q1. About work experience
Interview Preparation Tips
Blenheim Chalcot Interview FAQs
Some of the top questions asked at the Blenheim Chalcot Senior Data Engineer interview -
Tell us how to improve this page.
Blenheim Chalcot Interviews By Designations
- Blenheim Chalcot Data Scientist Interview Questions
- Blenheim Chalcot Project Manager Interview Questions
- Blenheim Chalcot Jr. Data Scientist Interview Questions
- Blenheim Chalcot Financial Associate Interview Questions
- Blenheim Chalcot Cdd KYC Analyst Interview Questions
- Blenheim Chalcot Senior QA Engineer Interview Questions
- Blenheim Chalcot Intern Interview Questions
- Blenheim Chalcot Technical Lead Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Senior Associate Interview Questions
- Data Engineer Interview Questions
- Azure Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Blenheim Chalcot Senior Data Engineer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Software Engineer
81
salaries
|  ₹20 L/yr - ₹36 L/yr |
|
Financial Associate
44
salaries
| ₹2.3 L/yr - ₹6 L/yr |
|
Operations Analyst
27
salaries
| ₹4.6 L/yr - ₹6 L/yr |
|
Associate Data Scientist
26
salaries
| ₹5.4 L/yr - ₹12 L/yr |
|
Data Scientist
24
salaries
| ₹5.7 L/yr - ₹12.8 L/yr |
Damco Solutions
smartData Enterprises
In Time Tec Visionsoft
AgreeYa Solutions
- Home >
- Interviews >
- Blenheim Chalcot Interview Questions
