NiT DATA Interview Questions and Answers

Query to find employees with middle name 'Mohan' and salary over 2 lac.

• Use SELECT statement to retrieve data from employee table

• Use WHERE clause to filter employees with middle name 'Mohan' and salary over 2 lac

• Example: SELECT * FROM employee WHERE middle_name = 'Mohan' AND salary > 200000

Count common elements in two lists

• Iterate through both lists and count occurrences of each element

• Use a dictionary to store counts of elements in both lists

• Return the common elements and their counts

Real-time data services can be used to migrate datawarehouse with GCP services.

• Use Cloud Dataflow to ingest and transform data in real-time

• Use Cloud Pub/Sub to stream data to BigQuery or Cloud Storage

• Use Cloud Dataproc to process data in real-time

• Use Cloud Composer to orchestrate data pipelines

• Use Cloud Spanner for real-time transactional data

• Use Cloud SQL for real-time relational data

• Use Cloud Bigtable for real-time NoSQL data

A program to convert a string into uppercase and lowercase.

• Use built-in functions like toUpperCase() and toLowerCase() to convert the string.

• Iterate through each character of the string and convert it to uppercase or lowercase accordingly.

• Ensure to handle special characters and spaces appropriately.

Developed a cloud-based data analytics platform using Python and AWS services

• Used AWS Lambda functions for serverless computing

• Implemented data processing pipelines with AWS Glue and S3

• Utilized Python libraries like Pandas and NumPy for data analysis

Data pipelines in GCP can be created using various tools like Dataflow, Dataproc, and Cloud Composer.

• Choose the appropriate tool based on the use case and data volume

• Define the data source and destination

• Create a pipeline using the chosen tool and define the data transformations

• Test and deploy the pipeline

• Monitor and troubleshoot the pipeline for any issues

I have used various services in GCP including BigQuery, Dataflow, Cloud Storage, and Pub/Sub.

• BigQuery for data warehousing and analytics

• Dataflow for data processing and ETL

• Cloud Storage for storing and accessing data

• Pub/Sub for messaging and event-driven architectures