i
HCLTech
Compare
Filter interviews by
HCLTech Ssis Developer Interview Questions and Answers
HCLTech Ssis Developer Interview Experiences
1 interview found
Training2SQL MSBI
What people are saying about HCLTech
Interview questions from similar companies
Adity Radia
Selected
I applied via LinkedIn and was interviewed in Apr 2023. There were 3 interview rounds.
A basic coding test was done and screened based on this.
Application based questions were been given
Interview Preparation Tips
sudeep mandal
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There was 1 interview round.
(1 Question)
- Q1. SSIS part what transformation you have worked with? lookup and its catch mode merge vs union containers forloop foreach loop sequence data source type you can connect to SSIS how to schedule a job how to...
- Ans.
Interview questions for SSIS and SQL developer
Worked with Lookup transformation and its catch mode
Understand the difference between Merge and Union transformations
Familiar with containers like For Loop, Foreach Loop, and Sequence
Able to connect to various data source types in SSIS
Know how to schedule a job in SSIS
Able to call a stored procedure in SSIS
Able to find the top 3rd salary in SQL
Understand the difference betw...
Interview Preparation Tips
don't panic only write those thing that you know in your resume
Skills evaluated in this interview
Anonymous
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
7 Questions
- Q1. The first and staring question is what is your roles and responsibilities in this project and what is the aim of your project?
- Q2. Then tell us how many Tasks & transformations used in your project and give me brief details about it?
- Q3. And they will give some scenarios like we have FFs source so we need to load into SQL server how you will do?
- Q4. Tell us from Scratch how you will find File count in Source folder and how you check files exist or not.?
- Ans.
To find file count in source folder and check if files exist, use SSIS Script Task with C# code.
Create a SSIS package with Script Task
Write C# code to get file count and check if files exist
Use System.IO namespace to access files and folders
Use Directory.GetFiles() method to get all files in folder
Use File.Exists() method to check if file exists
Use a variable to store file count and use it in subsequent tasks
- Q5. Hove you ever done Performance tuning in SSIS if yes tell me the process?
- Ans.
Yes, I have done performance tuning in SSIS.
Identify bottlenecks using performance counters and logging
Optimize data flow by using appropriate transformations and buffer sizes
Use parallelism and concurrency to improve performance
Minimize network traffic by compressing data and using bulk load operations
Use caching and lookup transformations to reduce database queries
Profile and test the package to validate performance
- Q6. Have you ever implemented Loging in your project if yes tell us how you do?
- Ans.
Yes, I have implemented logging in my projects.
I use log4net library for logging.
I log all the important events and errors in the application.
I store the logs in a separate file or database table.
I also use different log levels to differentiate between different types of logs.
I regularly review the logs to identify any issues or areas of improvement.
- Q7. Have you ever implemented error handle?
- Ans.
Yes, I have implemented error handling in my SSIS projects.
I always include a try-catch block in my SSIS packages to handle errors.
I use event handlers to log errors and send notifications.
I also use data flow transformations like Conditional Split and Derived Column to handle errors.
I have experience with custom error handling using Script Task and .NET code.
I make sure to test my error handling thoroughly to ensure i
Interview Preparation Tips
Skills evaluated in this interview
Senior Developer Interview Questions & Answers
Persistent Systems
Yogi Sumanth Rao
posted on 16 Oct 2024
(1 Question)
- Q1. Write the code in eggplant
- Ans.
Writing code in eggplant for Senior Developer interview
Use 'click' to simulate a mouse click on an element
Use 'typeText' to enter text into a field
Use 'verify' to check if an element is present on the screen
(2 Questions)
- Q1. Tell about your self
- Q2. Interested Technology
(2 Questions)
- Q1. What is SQL where it use
- Ans.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
- Q2. What is Join and Procedure
- Ans.
Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Procedure is a set of SQL statements stored in the database and executed when called
Procedures can accept input parameters
Skills evaluated in this interview
(2 Questions)
- Q1. Array qs reverse
- Q2. Question about angular and react
SHOW TIME
Performance tunning and sql profiler
I applied via Naukri.com and was interviewed in Aug 2023. There were 4 interview rounds.
(1 Question)
- Q1. Experience,ctc,expected ctc
(1 Question)
- Q1. Plsql concepts , procedure , functions
(1 Question)
- Q1. Plsql advance concepts, procedure , function
Selected
I applied via Company Website and was interviewed in May 2023. There were 2 interview rounds.
(5 Questions)
- Q1. Database questions answers
- Q2. C#.net questions answers
- Q3. MVC question answer
- Q4. Asp. Net questions answers
- Q5. Ado. Net questions answers
Interview Preparation Tips
- MVC
- Models view control
HCLTech Interview FAQs
Tell us how to improve this page.
HCLTech Interviews By Designations
- HCLTech Software Engineer Interview Questions
- HCLTech Technical Lead Interview Questions
- HCLTech Lead Engineer Interview Questions
- HCLTech Senior Software Engineer Interview Questions
- HCLTech Senior Analyst Interview Questions
- HCLTech Analyst Interview Questions
- HCLTech Technical Specialist Interview Questions
- HCLTech Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- SQL Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
22.5k
salaries
|  ₹1.2 L/yr - ₹8 L/yr |
|
Technical Lead
20.7k
salaries
| ₹7 L/yr - ₹25 L/yr |
|
Senior Software Engineer
15.4k
salaries
| ₹4 L/yr - ₹16.5 L/yr |
|
Lead Engineer
14.8k
salaries
| ₹4.2 L/yr - ₹14 L/yr |
|
Senior Analyst
13.9k
salaries
| ₹1 L/yr - ₹8.8 L/yr |
TCS
Wipro
Accenture
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- HCLTech Interview Questions >
- HCLTech Ssis Developer Interview Questions
