AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Anblicks
Compare
Filter interviews by
Anblicks Data Engineer Interview Questions and Answers
Anblicks Data Engineer Interview Experiences
3 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL Query to get Salary greater than manager salary
- Ans.
SQL query to retrieve salaries greater than manager salary
Use a SELECT statement to retrieve the salaries
Join the employee table with the manager table to compare salaries
Add a WHERE clause to filter salaries greater than manager's salary
- Q2. Count of alphabets in a string
- Ans.
Count the number of alphabets in a given string.
Iterate through each character in the string and check if it is an alphabet using isalpha() function.
Increment a counter for each alphabet found.
Return the final count of alphabets.
Example: Input - 'Hello123', Output - 5 (alphabets: H, e, l, l, o)
Interview Preparation Tips
- Python
- SQL
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Apr 2023. There were 3 interview rounds.
Mcq and coding based on profile
(1 Question)
- Q1. Technical interview based on profile
(1 Question)
- Q1. General hr questions
Interview Preparation Tips
Selected
I was interviewed before Feb 2024.
Gave a usecase and asked for the approach
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Data Engineer Interview Questions & Answers
Saama Technologies
Gautamee Jakinkar
posted on 29 May 2024
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries
(1 Question)
- Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...
Interview Preparation Tips
- SQL
- Python
- Pyspark
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(1 Question)
- Q1. 3rd largest salary from each department(window function)
Interview Preparation Tips
Srinivasa moorthy
(1 Question)
- Q1. Explain process in adf
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.
You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.
ADF supports a wide range of d...
Skills evaluated in this interview
(1 Question)
- Q1. Related to data warehouse
(1 Question)
- Q1. Python, data warehouse, data modelling
I applied via Naukri.com and was interviewed in Nov 2022. There were 4 interview rounds.
(1 Question)
- Q1. Join two tables in pyspark code and dataframe
- Ans.
Join two tables in PySpark code and DataFrame
Create two DataFrames from the tables
Specify the join condition using join() function
Select the columns to be displayed using select() function
Use show() function to display the result
(1 Question)
- Q1. What is the best place you visisted in pune
(1 Question)
- Q1. How much salary you are expectin herein the saama technoligies
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Questions about the tech skills you have
(1 Question)
- Q1. Salary discussion .
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Feb 2022. There were 3 interview rounds.
2 hr duration test it was. It had the topics like reasoning, number system. Technical section was also there which has sql questions
(11 Questions)
- Q1. Based on my final year project. Some questions based the programming language I added in my resume and other questions asked on sql queries on joins, union, union all difference.
- Q2. Then HR round was there in which asked some behavioral questions and tested some decision making skills
- Q3. Tell me about your final year project is a common question that every interviewer ask for fresher
- Q4. What is inheritance and type of inheritance? if you mentioned c or Java as your skill
- Q5. Tell me about yourself?
- Q6. What are your hobbies?
- Q7. What is your salary expectation.
- Q8. Are you willing to relocate?
- Q9. Are you ready to sign agreement if there is any?
- Q10. Tell me about your family background
- Q11. Is there any for future studies
Interview Preparation Tips
Do not read or practice before 10 mins of your interview.
Practice and research all the possible questions and scenarios before going to an interview
Anblicks Interview FAQs
Tell us how to improve this page.
Anblicks Interviews By Designations
- Anblicks Data Engineer Interview Questions
- Anblicks Data Analyst Interview Questions
- Anblicks Power BI Developer Interview Questions
- Anblicks QA Lead Interview Questions
- Anblicks Quality Analyst Interview Questions
- Anblicks Senior Data Engineer Interview Questions
- Anblicks Software Developer Interview Questions
- Anblicks Software Engineer Interview Questions
- Show more
Anblicks Data Engineer Interview Process
based on 4 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Anblicks Data Engineer Reviews and Ratings
based on 15 reviews
Rating in categories
|
Data Engineer
55
salaries
|  ₹4.5 L/yr - ₹14.1 L/yr |
|
Software Engineer
25
salaries
| ₹2.4 L/yr - ₹10.9 L/yr |
|
Junior Data Engineer
22
salaries
| ₹3.7 L/yr - ₹6 L/yr |
|
Senior Software Engineer
21
salaries
| ₹17.2 L/yr - ₹28 L/yr |
|
Associate Software Engineer
21
salaries
| ₹3.2 L/yr - ₹10 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Anblicks Interview Questions >
- Anblicks Data Engineer Interview Questions
