Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Colgate Global Business Services Data Engineer Interview Questions and Answers

Updated 26 Jul 2021

Colgate Global Business Services Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 26 Jul 2021

I applied via LinkedIn and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Interview questions mostly on GCP data pipeline.
  • Q2. What is CICI, bigquery in detail, BI tool, data warehousing
  • Ans. 

    CICI is a data integration platform. BigQuery is a cloud-based data warehousing tool. BI tools are used for data analysis and visualization.

    • CICI is a platform that helps integrate data from various sources and transform it into a usable format

    • BigQuery is a cloud-based data warehousing tool that allows users to store and analyze large datasets

    • BI tools are used for data analysis and visualization, allowing users to make ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn end to end pipeline building in project. Have clear understanding on how your data flows according to business requirements.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL query & some java code walk through

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing hard but basics

I applied via Recruitment Consultant and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Related to sales automation.
  • Q2. What is SFA?
  • Ans. 

    SFA stands for Sales Force Automation.

    • SFA is a software system that automates sales processes.

    • It helps sales teams manage customer interactions, track leads, and close deals.

    • SFA can also provide analytics and reporting on sales performance.

    • Examples of SFA software include Salesforce, HubSpot, and Zoho CRM.

  • Answered by AI
  • Q3. What is DMS?
  • Ans. 

    DMS stands for Document Management System.

    • DMS is a software system used to manage, store, and track electronic documents and images.

    • It allows for easy retrieval and sharing of documents within an organization.

    • DMS can also provide version control and security features to ensure document integrity.

    • Examples of DMS include Microsoft SharePoint, Google Drive, and Dropbox Business.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a long session and was an interesting one.

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. It was mostly puzzles.
  • Q2. One algo question invoving recursive function .

Interview Preparation Tips

Interview preparation tips for other job seekers - For freshers - prepare puzzles and basic computer science fundamentals

Interview Questionnaire 

2 Questions

  • Q1. Jk
  • Q2. C language

I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

NA

Round 3 - Group Discussion 

NA

Round 4 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, be positive, good with knowledge of your project
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Testgorilla test with sql and other mcq

Round 2 - Technical 

(1 Question)

  • Q1. Deep technical with all points in resume
Round 3 - Case Study 

We have to build a data strategy based on the problem statement

Round 4 - HR 

(1 Question)

  • Q1. Offer discussion and role
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What time intelligence functions can be used for ytd and qtd analysis
  • Ans. 

    Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

    • YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

    • QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

    • Thes...

  • Answered by AI
  • Q2. Difference between import and direct query
  • Ans. 

    Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

    • Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

    • Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

    • Import is suitable for smaller datasets, while direct query is better for large da

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Technical 

(2 Questions)

  • Q1. Technical questions on node js
  • Q2. Coding round which had 2 questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Two coding questions and 8 MCQ's related to databases and springboot technologies.

Round 2 - Technical 

(1 Question)

  • Q1. Given arrays related problem to solve and some technical questions based on java springboot and mySql
Round 3 - Technical 

(2 Questions)

  • Q1. Discussed about the topics of threads and some other technical questions
  • Q2. Asked to solve the question related to Linked List.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the concepts in depth to understand perfectly. Setting the good standards on basics leads to solve most of the problems.
Contribute & help others!
anonymous
You can choose to be anonymous

Colgate Global Business Services Interview FAQs

How to prepare for Colgate Global Business Services Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Colgate Global Business Services. The most common topics and skills that interviewers at Colgate Global Business Services expect are Hadoop, Python, SQL, Data Analysis and Data Analytics.
What are the top questions asked in Colgate Global Business Services Data Engineer interview?

Some of the top questions asked at the Colgate Global Business Services Data Engineer interview -

  1. What is CICI, bigquery in detail, BI tool, data warehous...read more
  2. Interview questions mostly on GCP data pipelin...read more

Recently Viewed

INTERVIEWS

Anand Rathi Wealth Management

No Interviews

INTERVIEWS

Colgate Global Business Services

No Interviews

INTERVIEWS

Anand Rathi Wealth Management

No Interviews

INTERVIEWS

Colgate Global Business Services

5.6k top interview questions

INTERVIEWS

Anand Rathi Wealth Management

No Interviews

INTERVIEWS

OneAssist Consumer Solutions

No Interviews

INTERVIEWS

Virtual Galaxy Infotech

No Interviews

INTERVIEWS

Anand Rathi Wealth Management

No Interviews

INTERVIEWS

Anand Rathi Wealth Management

No Interviews

INTERVIEWS

Colgate Global Business Services

No Interviews

Tell us how to improve this page.

Associate Analyst
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Financial Analyst
51 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Colgate Global Business Services with

Procter & Gamble

4.1
Compare

Hindustan Unilever

4.2
Compare

Johnson & Johnson

4.0
Compare

Nestle

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent