i
Diggibyte
Technologies
Filter interviews by
I appeared for an interview in May 2025, where I was asked the following questions.
SQL is a language for managing and querying databases, essential for data manipulation and retrieval.
SQL stands for Structured Query Language, used for interacting with relational databases.
Databases store structured data in tables, which consist of rows and columns.
Common SQL operations include SELECT (to retrieve data), INSERT (to add data), UPDATE (to modify data), and DELETE (to remove data).
Examples of SQL databas...
I would rate my proficiency in Python and SQL as advanced, with extensive experience in data manipulation and analysis.
Proficient in Python libraries like Pandas and NumPy for data analysis and manipulation.
Experience in writing complex SQL queries for data extraction and transformation.
Developed ETL pipelines using Python and SQL to automate data workflows.
Implemented data visualization using Python libraries such as ...
I appeared for an interview in Dec 2024, where I was asked the following questions.
I appeared for an interview in Dec 2024, where I was asked the following questions.
Yes, I am proficient in Python, which I use extensively for data manipulation and ETL processes.
I have experience with Python libraries like Pandas and NumPy for data analysis.
I have built ETL pipelines using Python and Apache Airflow.
I am familiar with SQL for querying databases and integrating with Python.
I have developed data visualization tools using Matplotlib and Seaborn.
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.
Nested JSON in PySpark allows for handling complex data structures within a DataFrame.
Use the `struct` function to create nested structures in PySpark DataFrames.
Access nested elements using dot notation or `getItem` function.
Use `explode` function to flatten nested arrays.
Consider using `selectExpr` for complex transformations involving nested JSON.
Joining of two table using spark structure API. SQL queries like join, aggregation(avg, sum, max). word count Program.
Top trending discussions
I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.
In this round we have aptitude plus coding mcq questions
Here we have to write full fledge code 2 questions were there and are easy
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Python has for and while loops. For loop iterates over a sequence and while loop executes a block of code while a condition is true.
For loop syntax: for variable in sequence: block of code
While loop syntax: while condition: block of code
Example: for i in range(5): print(i) will print 0 to 4
Example: while x < 5: print(x); x += 1 will print 0 to 4
SQL writing is crucial for data engineers to manage, manipulate, and retrieve data efficiently from databases.
Data Retrieval: SQL allows for efficient querying of large datasets. Example: SELECT * FROM users WHERE age > 30;
Data Manipulation: SQL enables data insertion, updates, and deletions. Example: UPDATE users SET status = 'active' WHERE last_login > '2023-01-01';
Data Aggregation: SQL can summarize data using...
I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.
I have worked on various technologies including Hadoop, Spark, SQL, Python, and AWS.
Experience with Hadoop and Spark for big data processing
Proficient in SQL for data querying and manipulation
Skilled in Python for data analysis and scripting
Familiarity with AWS services such as S3, EC2, and EMR
Knowledge of data warehousing and ETL processes
I applied via Walk-in and was interviewed before Feb 2020. There was 1 interview round.
based on 6 interview experiences
Difficulty level
Duration
based on 13 reviews
Rating in categories
Data Engineer
36
salaries
| ₹3.3 L/yr - ₹10.1 L/yr |
Data Scientist
4
salaries
| ₹3.7 L/yr - ₹35 L/yr |
Scrum Master
4
salaries
| ₹11 L/yr - ₹19 L/yr |
Talent Acquisition Specialist
4
salaries
| ₹3.6 L/yr - ₹10 L/yr |
Front end Developer
4
salaries
| ₹3 L/yr - ₹12.5 L/yr |
TCS
Accenture
Cognizant
Infosys