Filter interviews by
I appeared for an interview in Dec 2024.
I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.
I am a Cloud Engineer with a strong background in designing, implementing, and managing cloud infrastructure.
Experienced in working with AWS, Azure, and Google Cloud Platform
Skilled in automating tasks using tools like Terraform and Ansible
Proficient in monitoring and optimizing cloud resources for cost efficiency
Strong understanding of networking and security principles in cloud environments
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
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.
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
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
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
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
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 N
I appeared for an interview in Oct 2022.
Replication performance issues can arise due to network latency, hardware limitations, and inefficient queries.
Network latency can cause delays in replication, leading to slower performance.
Hardware limitations such as insufficient memory or slow disk speeds can also impact replication performance.
Inefficient queries can cause replication to lag behind, leading to slower performance.
Monitoring replication lag and optim...
66degrees interview questions for popular designations
I applied via Company Website and was interviewed before Oct 2019. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.
Dictionary is a collection of key-value pairs in Python.
Keys must be unique and immutable.
Values can be of any data type.
Access values using keys.
Add or modify values using keys.
Use dict() constructor or {} to create a dictionary.
Example: {'name': 'John', 'age': 30}
Example: dict(name='John', age=30)
I applied via Campus Placement and was interviewed before Sep 2019. There were 5 interview rounds.
OOPs concepts in Java are the fundamental principles of object-oriented programming.
Encapsulation: wrapping data and code into a single unit
Inheritance: creating new classes from existing ones
Polymorphism: using a single interface to represent multiple types
Abstraction: hiding implementation details from the user
Examples: class, object, inheritance, polymorphism, encapsulation
Stack is a LIFO data structure while Queue is a FIFO data structure.
Stack follows Last In First Out (LIFO) principle while Queue follows First In First Out (FIFO) principle.
Stack has two main operations: push and pop while Queue has two main operations: enqueue and dequeue.
Stack is used in recursive function calls, undo/redo operations, and backtracking while Queue is used in breadth-first search, printing tasks in ord...
SQL query to find second highest salary in database
Use ORDER BY and LIMIT to get the second highest salary
Assume ties are allowed and use DISTINCT
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a method in a subclass with the same name and parameters as a method in its superclass.
Method overloading is done within the same class while method overriding is done in different classes (subclass and superclass).
Method overloading is achieved by changing the number of parameters or the data type of ...
The parent class of all classes in Java is the Object class.
All classes in Java implicitly extend the Object class.
The Object class provides basic methods such as toString(), equals(), and hashCode().
Any class can override these methods to provide custom implementations.
Example: public class MyClass extends Object { ... }
Example: Object obj = new MyClass();
SQL databases are relational and use structured query language, while NoSQL databases are non-relational and use various data models.
SQL databases are based on a fixed schema, while NoSQL databases are schema-less.
SQL databases use tables to store data, while NoSQL databases use various data models like key-value, document, columnar, or graph.
SQL databases are better suited for complex queries and structured data, whil...
I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.
TCS stands for Tata Consultancy Services, a multinational IT services company based in India.
TCS is one of the largest IT services companies in the world.
It provides a wide range of services including consulting, software development, and business process outsourcing.
TCS has clients in various industries such as banking, healthcare, and retail.
The company has a strong focus on innovation and has several research and de...
Some of the top questions asked at the 66degrees interview -
based on 5 interviews
Interview experience
based on 21 reviews
Rating in categories
Data Engineer
7
salaries
| ₹15.2 L/yr - ₹30 L/yr |
QA Engineer
5
salaries
| ₹9 L/yr - ₹16.5 L/yr |
Cloud Engineer
5
salaries
| ₹7 L/yr - ₹20 L/yr |
Senior Cloud Engineer
5
salaries
| ₹15.1 L/yr - ₹38 L/yr |
Engineering Manager
4
salaries
| ₹42 L/yr - ₹42 L/yr |
MakeMyTrip
Yatra
Cleartrip
Goibibo