i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.
Files can be read in AWS Glue using Data Catalog, crawlers, and Glue ETL jobs.
Use AWS Glue Data Catalog to store metadata information about the files.
Crawlers can automatically infer the schema of the files and populate the Data Catalog.
Glue ETL jobs can then be used to read the files from various sources like S3, RDS, etc.
Supports various file formats like CSV, JSON, Parquet, etc.
Duplicate records can be identified using SQL queries by comparing columns and using aggregate functions.
Use GROUP BY clause with COUNT() function to identify duplicate records
Use HAVING clause to filter out records with count greater than 1
Join the table with itself on specific columns to find duplicates
I applied via Recruitment Consulltant and was interviewed in Aug 2023. There was 1 interview round.
Questions was aked in first round for Sql and pypsark for second round
Sql related questions are not in depth but when it comes ro Pyspark i.e apache spark questions related are moderate
What people are saying about Capgemini
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
based on 4 interviews
Interview experience
based on 15 reviews
Rating in categories
Consultant
55.4k
salaries
| ₹5.1 L/yr - ₹17.5 L/yr |
Associate Consultant
50.7k
salaries
| ₹3 L/yr - ₹11.9 L/yr |
Senior Consultant
46.6k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
Senior Analyst
21k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹12.6 L/yr |
Wipro
Accenture
Cognizant
TCS