i
CitiusTech
Filter interviews by
I appeared for an interview before Jun 2022.
Datawarehouse design patterns are strategies for organizing data in a datawarehouse to optimize performance and efficiency.
Star schema
Snowflake schema
Galaxy schema
Data Vault
Federated datawarehouse
We used the Extract, Transform, Load (ETL) design pattern in our last project.
We extracted data from multiple sources such as databases, APIs, and files.
We transformed the data by cleaning, filtering, and aggregating it to fit the target data model.
We loaded the transformed data into the destination database or data warehouse.
We used tools like Informatica, Talend, or Apache NiFi for ETL processes.
Top trending discussions
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
posted on 20 Apr 2022
I applied via Recruitment Consulltant and was interviewed before Apr 2021. There was 1 interview round.
NoSQL databases are non-relational databases that store and retrieve data in a non-tabular format.
Document-oriented databases (MongoDB, Couchbase)
Key-value stores (Redis, Riak)
Column-family stores (Cassandra, HBase)
Graph databases (Neo4j, OrientDB)
Scaling refers to the process of increasing or decreasing the capacity of a system to handle more or less load.
Vertical Scaling: Adding more resources to a single node
Horizontal Scaling: Adding more nodes to a system
Load Balancing: Distributing the load across multiple nodes
Database Sharding: Splitting a database into smaller parts to distribute the load
Caching: Storing frequently accessed data in memory for faster acc
I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.
I applied via Approached by Company and was interviewed before Apr 2021. There were 2 interview rounds.
posted on 17 Jan 2021
I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.
posted on 21 Nov 2020
posted on 21 Apr 2021
posted on 4 Jun 2021
Singleton design pattern restricts the instantiation of a class to one object.
Ensures only one instance of a class exists
Provides a global point of access to that instance
Used when only one instance of a class is needed throughout the application
Example: Database connection manager
I applied via Naukri.com and was interviewed in Nov 2020. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Senior Software Engineer
2.6k
salaries
| ₹5 L/yr - ₹20 L/yr |
Technical Lead
2k
salaries
| ₹7.3 L/yr - ₹28 L/yr |
Software Engineer
1.3k
salaries
| ₹3 L/yr - ₹12.2 L/yr |
Technical Lead 1
384
salaries
| ₹7 L/yr - ₹25.4 L/yr |
Technical Lead 2
301
salaries
| ₹8 L/yr - ₹28 L/yr |
Accenture
Capgemini
Xoriant
HTC Global Services