i
Bitwise Solutions
Filter interviews by
I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.
Yes, I created a complex SSIS package to automate data migration between multiple databases.
Used multiple data flow tasks to extract, transform, and load data
Implemented error handling and logging to track data flow
Utilized variables and expressions for dynamic behavior
Included conditional logic for different data processing scenarios
Yes, I have created a complex SSIS package for loading data from multiple sources into a data warehouse.
The SSIS package involved extracting data from various sources such as SQL Server, Excel files, and flat files.
I used data flow tasks, conditional split transformations, and lookup transformations to cleanse and transform the data before loading it into the data warehouse.
I implemented error handling and logging mech...
To run 300 stored procedures sequentially and in parallel in SQL Server, you can use SQL Server Agent jobs and SSIS packages.
Create SQL Server Agent job to run the stored procedures sequentially
Create multiple SQL Server Agent jobs to run the stored procedures in parallel
Use SSIS packages to orchestrate the execution of the stored procedures in parallel
Consider using batch processing and optimizing the stored procedure
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Subscriptions in SSRS allow users to schedule and automate the delivery of reports via email or file share.
Subscriptions can be set up to deliver reports at specific times or in response to data-driven events.
Users can choose the delivery method (email, file share, etc.) and format (PDF, Excel, etc.) for the reports.
Subscriptions can be managed and monitored through the SSRS web portal.
Example: A user can set up a subs...
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
Top trending discussions
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
I was interviewed in Jan 2025.
Test will be in hacker rank there would be a difficulty level between easy to medium
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
Online zoom coding test will be there - 4 questions - 2 about output of code & 2 about technical questions.
Polymorphism is the ability of a single function or method to operate on different types of data.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
Virtual polymorphism is achieved through virtual functions in C++.
Virtual functions allow a function in a base class to be overridden in a derived class.
Example: Animal class with virtual function 'makeSound' overridden in Dog a
Virtual polymorphism allows objects of different classes to be treated as objects of a common superclass.
Create a base class with virtual functions
Create derived classes that override the virtual functions
Use pointers or references of the base class to call the overridden functions
Hackearth online coding test for 1 hour
Use sorting or heap data structure to find k largest elements in an array of strings.
Sort the array in descending order and return the first k elements.
Use a max heap data structure to efficiently find the k largest elements.
Examples: ['apple', 'banana', 'orange', 'kiwi'], k=2 -> ['orange', 'kiwi']
Remove duplicates from array of strings
Create a Set to store unique strings
Iterate through the array and add each string to the Set
Convert the Set back to an array to get the unique strings
Technology advantage or not
All aptitude topics,logical reasoning
posted on 4 Nov 2024
I applied via Approached by Company and was interviewed in Jun 2024. There were 3 interview rounds.
Design a RESTful API for CRUD operations on user resources.
Use HTTP methods like GET, POST, PUT, DELETE for CRUD operations
Create endpoints like /users for listing all users, /users/{id} for specific user
Use status codes like 200 for success, 404 for not found, 400 for bad request
Implement authentication and authorization mechanisms for security
Include request and response body formats like JSON or XML
OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.
OOPS focuses on creating objects that contain data and methods to manipulate that data.
It allows for encapsulation, inheritance, and polymorphism.
Examples of OOPS languages include Java, C++, and Python.
Dependency Injection is a design pattern where components are given their dependencies rather than creating them internally.
Allows for easier testing by mocking dependencies
Promotes loose coupling between components
Improves code reusability and maintainability
Example: Constructor injection, Setter injection
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy by storing data in a structured manner.
There are different normal forms like 1NF, 2NF, 3NF, and BCNF that define the level of normalization.
Example: If we have a t...
based on 3 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Programmer Analyst
612
salaries
| ₹4.9 L/yr - ₹15.6 L/yr |
Softwaretest Engineer
510
salaries
| ₹2.8 L/yr - ₹10.6 L/yr |
Programmer
471
salaries
| ₹3 L/yr - ₹9.3 L/yr |
System Analyst
283
salaries
| ₹8 L/yr - ₹27 L/yr |
Test Analyst
224
salaries
| ₹4 L/yr - ₹13.5 L/yr |
TCS
Infosys
Wipro
HCLTech