i
Bitwise Solutions
Filter interviews by
Clear (1)
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
The greatest challenge faced during migration to cloud from on-premise DB is ensuring data security and compliance.
Ensuring data security during transit and at rest
Maintaining compliance with regulations and industry standards
Minimizing downtime and ensuring data integrity
Optimizing performance and cost efficiency in the cloud environment
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
2 coding questions, 1 hr and Aptitude questions are also clubbed into other section.
Yes, I am open to taking on a testing project as part of my role as an ETL Developer.
I have experience with testing tools and methodologies in my previous roles.
I understand the importance of testing in ensuring data accuracy and quality.
Taking on a testing project will help me improve my skills and knowledge in ETL development.
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
I am using Talend version 7.3.1 for ETL development.
I am currently using Talend version 7.3.1 for ETL development.
The specific version of Talend being used is 7.3.1.
Talend 7.3.1 offers various features and improvements for ETL processes.
Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.
Optimize data flow by using efficient data sources and destinations
Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations
Increase parallelism by using multiple threads and optimizing task execution order
Use performance monitoring tools like SSIS logging and performance counters...
based on 3 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Programmer Analyst
657
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
510
salaries
| ₹0 L/yr - ₹0 L/yr |
Programmer
471
salaries
| ₹0 L/yr - ₹0 L/yr |
System Analyst
283
salaries
| ₹0 L/yr - ₹0 L/yr |
Test Analyst
224
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech