Add office photos
Filter interviews by
Bharat Sanchar Nigam Data Management Executive Interview Questions and Answers
Bharat Sanchar Nigam Data Management Executive Interview Experiences
1 interview found
(2 Questions)
- Q1. How will data commissioning?
- Ans.
Data commissioning involves the process of ensuring data quality, accuracy, and relevance before it is used for decision-making.
Data commissioning involves assessing the quality of data to ensure it is accurate and reliable.
It includes validating data sources and ensuring they meet the required standards.
Data commissioning also involves cleaning and transforming data to make it usable for analysis.
It is essential for o...
- Q2. How to know whether your site can work or not
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions
(4 Questions)
- Q1. Clustering and partition difference in data warehousing solutions
- Ans.
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.
Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.
Clustering is often used for data a...
- Q2. What are the different approaches to Optimising SQL
- Ans.
Different approaches to optimizing SQL include indexing, query optimization, and database design.
Use indexing to improve query performance
Optimize queries by avoiding unnecessary joins and using appropriate functions
Design the database schema efficiently to reduce redundancy and improve data retrieval speed
- Q3. Spark and it’s architecture
- Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
- Ans.
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
Aggregate the data by customer and item purchased
Filter out transactions from February
Count the number of items bought by each customer
Interview Preparation Tips
Bhavya R
(2 Questions)
- Q1. What are the different optimization techniques used in your project
- Q2. SQl logic question regarding joins
Basic aptitude ques were asked
(2 Questions)
- Q1. Projects discussion
- Q2. Probability questions
(2 Questions)
- Q1. Why Ericsson and 5 year plan
- Q2. Your strength and weakness
(2 Questions)
- Q1. Difference between joins
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns rows when there is a match in one of the tables.
Cross Join:
- Q2. Window function
(1 Question)
- Q1. Write sql query in pythons
- Ans.
Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.
Use libraries like pandas or sqlalchemy to execute SQL queries in Python
Remember to establish a connection to the database before executing queries
Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. Sql question related to windows function
- Q2. Unix basics - find a word in a set of files
- Ans.
Using Unix command 'grep' to find a word in a set of files
Use 'grep' command followed by the word you want to search for and the file(s) you want to search in
Add the '-r' flag to search recursively in all files in a directory
Use '-i' flag for case-insensitive search
Example: grep 'hello' file.txt
Example: grep -r 'error' /path/to/directory
Example: grep -i 'apple' file1.txt file2.txt
- Q3. Python question related to file system, regex
Interview Preparation Tips
Skills evaluated in this interview
Shashank S
(2 Questions)
- Q1. Questions were based on DSA and C
- Q2. It was basically a coding round with simple logic
Senior Data Analyst Interview Questions & Answers
Tata Communications
Anonymous
posted on 25 Jun 2024
(2 Questions)
- Q1. Power BI get data
- Q2. Excel summation
Data Entry Operator Interview Questions & Answers
Aerial Telecom Solutions
Mohit Kumar
posted on 11 Jul 2024
Selected
I applied via WorkIndia and was interviewed before Jul 2023. There was 1 interview round.
(4 Questions)
- Q1. Tell me about your self
- Q2. What is your weakness
- Q3. What is your strength
- Q4. What is your sallery expectation
- Ans.
My salary expectation is based on my experience, skills, and the industry standard.
Consider my experience and skills when determining salary
Research industry standard salaries for Data Entry Operators
Open to negotiation based on benefits and opportunities
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Apr 2022. There were 6 interview rounds.
(1 Question)
- Q1. All technical questions related to profile
(1 Question)
- Q1. Data science questions
(1 Question)
- Q1. Current role and experience related
(2 Questions)
- Q1. Technical questions
- Q2. Data science questions by onshore team
(2 Questions)
- Q1. Salary joining date
- Q2. Expected salary joining date
Bharat Sanchar Nigam Interview FAQs
Tell us how to improve this page.
Bharat Sanchar Nigam Interviews By Designations
- Bharat Sanchar Nigam Intern Interview Questions
- Bharat Sanchar Nigam Trainee Interview Questions
- Bharat Sanchar Nigam Customer Care Executive Interview Questions
- Bharat Sanchar Nigam Accounts Officer Interview Questions
- Bharat Sanchar Nigam Apprentice Interview Questions
- Bharat Sanchar Nigam Area Manager Interview Questions
- Bharat Sanchar Nigam Assistant General Managertelecom Operations Bsnl Interview Questions
- Bharat Sanchar Nigam Billing Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Data Management Associate Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Show more
Interview Questions from Similar Companies
|
Junior Accounts Officer
126
salaries
|  ₹5 L/yr - ₹11 L/yr |
|
Junior Engineer
120
salaries
| ₹2.2 L/yr - ₹8 L/yr |
|
Sub Divisional Engineer
107
salaries
| ₹8.3 L/yr - ₹25 L/yr |
|
Junior Telecom Officer
102
salaries
| ₹4 L/yr - ₹12.5 L/yr |
|
Accounts Officer
40
salaries
| ₹6.5 L/yr - ₹16 L/yr |
Bharti Airtel
Vodafone Idea
Jio
Tata Communications
Calculate your in-hand salary
- Home >
- Interviews >
- Bharat Sanchar Nigam Interview Questions >
- Bharat Sanchar Nigam Data Management Executive Interview Questions
