Filter interviews by
Databricks Medallion Architecture is a cloud-based architecture for data processing and analytics.
Databricks Medallion Architecture is designed to handle large-scale data processing and analytics tasks in a distributed manner.
It leverages Apache Spark for processing data in-memory and provides a unified analytics platform for data scientists, engineers, and business users.
The architecture includes components like Datab...
Optimization methods in query help improve performance and efficiency.
Use indexes to speed up query execution
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using appropriate join types and conditions
Limit the number of rows returned using LIMIT or TOP clause
Use query execution plans to identify bottlenecks and optimize accordingly
I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 5 interview rounds.
Designing test data content for different flavors of DB
Identify the data types and structures for each DB flavor
Create test data that covers all possible scenarios and edge cases
Ensure data consistency and accuracy across all DB flavors
Consider performance and scalability factors for distributed DBs
Include mainframe-specific data such as EBCDIC encoding and packed decimal formats
New technologies of DBMS are constantly emerging to improve data management and analysis.
New SQL databases like CockroachDB and TiDB are gaining popularity for their scalability and distributed architecture.
NoSQL databases like MongoDB and Cassandra are widely used for their flexibility and ability to handle unstructured data.
Graph databases like Neo4j and OrientDB are becoming popular for their ability to handle compl...
I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.
Cloud refers to the use of remote servers to store, manage, and process data instead of a local server or personal computer.
Cloud computing allows for on-demand access to shared computing resources
Data can be accessed from anywhere with an internet connection
Examples include Amazon Web Services, Microsoft Azure, and Google Cloud Platform
I applied via Naukri.com and was interviewed in Mar 2022. There were 3 interview rounds.
Terraform is an open-source infrastructure as code software tool that allows users to define and provision a data center infrastructure.
Terraform is used to automate the creation, modification, and deletion of infrastructure resources.
It supports multiple cloud providers such as AWS, Azure, and Google Cloud Platform.
Terraform uses a declarative language called HashiCorp Configuration Language (HCL) to define infrastruc...
I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.
I applied via LinkedIn and was interviewed before Jan 2022. There were 2 interview rounds.
Design an ecommerce web app
Include a user-friendly interface for easy navigation
Integrate a secure payment gateway for transactions
Provide detailed product descriptions and high-quality images
Include a search bar and filters for easy product discovery
Allow customers to create accounts and save their preferences
Provide customer support through chat or email
Include a review and rating system for products
Offer promotions
To scale a system to 1 million users, optimize database, use load balancing, and implement caching.
Optimize database by indexing frequently queried data and partitioning tables
Use load balancing to distribute traffic across multiple servers
Implement caching to reduce database queries and improve response time
Consider using a content delivery network (CDN) to serve static assets
Use horizontal scaling by adding more serv...
Normalization in database is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured manner.
Normalization ensures data integrity by minimizing data anomalies.
There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF.
For...
A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.
Triggers are used to maintain referential integrity, enforce business rules, and automate actions in response to data changes.
They can be defined to execute before or after an INSERT, UPDATE, or DELETE operation on a table.
For example, a trigger can be set up to automatically update a timestamp column
A view is a sight or prospect, typically of attractive natural scenery.
A view refers to what can be seen from a particular location or vantage point
Views can include landscapes, cityscapes, seascapes, or any other visually appealing scenes
Architects often design buildings to take advantage of specific views, such as positioning windows to frame a picturesque landscape
Views can greatly enhance the overall experience and
I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.
Yes, I am familiar with * (client name) STA flow.
Yes, I have experience working with * (client name) STA flow.
I have successfully implemented * (client name) STA flow in previous projects.
I am knowledgeable about the specific requirements and processes involved in * (client name) STA flow.
Yes, I have experience with both block-level and subsystem-level STA.
I have experience with block-level STA, where I focused on timing analysis within a specific block of the design.
I have also worked on subsystem-level STA, which involves analyzing timing across multiple blocks or components of the design.
Examples of tools I have used for STA include PrimeTime and Tempus.
Yes, I am familiar with Constraint development & coding.
I have experience in developing constraints for architectural designs to ensure structural integrity and safety.
I am proficient in coding languages commonly used in architectural software, such as AutoCAD and Revit.
I have successfully implemented constraints in various projects to meet client requirements and building codes.
I applied via Referral and was interviewed in Oct 2023. There were 2 interview rounds.
It was online test.. need to do coding
based on 1 interview
Interview experience
Associate Consultant
80
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Business Analyst
71
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
34
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Product Engineer
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
16
salaries
| ₹0 L/yr - ₹0 L/yr |
IQVIA
ICON Plc
Parexel International
Syneos Health