AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Rajesh Trading Ssis Developer Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
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
(1 Question)
- Q1. Star and snowflake schema
(1 Question)
- Q1. Star and snoflake schema
(1 Question)
- Q1. Formal and actual parameter
I applied via Referral and was interviewed before Oct 2020. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is Non-PO?
- Ans.
Non-PO refers to purchases made without a purchase order.
Non-PO purchases are made without a formal purchase order.
These purchases are typically made for urgent or small items.
Non-PO purchases may require additional approval or documentation.
Examples of Non-PO purchases include office supplies, travel expenses, and minor repairs.
- Q2. What does FB03 stand for in SAP?
- Ans.
FB03 is a transaction code in SAP used to display financial accounting documents.
FB03 is used to view accounting documents such as invoices, credit memos, and payment receipts.
It allows users to search for documents based on various criteria such as document number, posting date, and company code.
FB03 also provides options to display document details, line items, and accounting entries.
It is commonly used by finance an...
- Q3. What are the types of Fixed Assets?
- Ans.
Fixed assets can be categorized into tangible and intangible assets.
Tangible assets include property, plant, and equipment (PPE), such as buildings, machinery, and vehicles.
Intangible assets include patents, copyrights, trademarks, and goodwill.
Fixed assets are long-term assets that are not intended for sale and are used in the production of goods or services.
Fixed assets are recorded on the balance sheet and are subje...
Interview Preparation Tips
Skills evaluated in this interview
Sales Executive Interview Questions & Answers
HDB Financial Services
Anonymous
posted on 13 Feb 2023
Selected
I applied via Referral and was interviewed before Feb 2022. There was 1 interview round.
(3 Questions)
- Q1. How to grow your company progress
- Q2. What about you future plans
- Q3. Why do you want to join the company
Interview Preparation Tips
I applied via Walk-in and was interviewed in Oct 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Only questions related to their profile.
Interview Preparation Tips
I applied via Walk-in and was interviewed in Aug 2021. There were 2 interview rounds.
(2 Questions)
- Q1. What are your salary expectations?
- Q2. Tell me about yourself.
The questions where about matrix
Interview Preparation Tips
Interview Questionnaire
3 Questions
- Q1. Tell me about yourself.
- Q2. Do you believe in Team Work or Individual work.
- Q3. Tell me about previous experience & unforgettable movement in previous company .
Interview Preparation Tips
I applied via Campus Placement and was interviewed before May 2021. There were 3 interview rounds.
Internal case of a biscuit manufacturing company. Details about company background, sales, figures are given and based on those 3 questions were asked.
Part 2 of the same case study was asked where the company should go for IPO or expansion in local market. based on the facts, decision and justification had to be given
(1 Question)
- Q1. Tell me about yourself
- Ans.
I am a highly experienced consultant with a strong background in problem-solving and strategic planning.
Over 10 years of experience in consulting for various industries
Expertise in analyzing complex business challenges and providing effective solutions
Proven track record of delivering successful projects on time and within budget
Strong communication and interpersonal skills, able to build rapport with clients
Ability to...
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Sep 2021. There were 3 interview rounds.
(2 Questions)
- Q1. Basic devops question
- Q2. Agile process discussion
(2 Questions)
- Q1. Kubernetes deployment
- Q2. Ansible basic question
(2 Questions)
- Q1. Salary discussion with HR manager
- Q2. Negotiation salary with HR manager
Interview Preparation Tips
- Devops
I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.
(2 Questions)
- Q1. Most of questions were based on IND AS since this role was in Assurance service line under Financial accounting and advisory services.
- Q2. Questions were from IND AS AS 115,116 103 and why want to work with EY values of EY etc. and yeah i question that remains same in every interview was Tell me about yourself
Interview Preparation Tips
Tell us how to improve this page.
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
|
Accountant
4
salaries
|  ₹1.9 L/yr - ₹3.6 L/yr |
|
Accounts Manager
3
salaries
| ₹2.4 L/yr - ₹6 L/yr |
|
Executive Accountant
3
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Godown Incharge
3
salaries
| ₹3 L/yr - ₹3 L/yr |
Cognizant
Teleperformance
iEnergizer
Reliance Retail
- Home >
- Interviews >
- Rajesh Trading Interview Questions >
- Rajesh Trading Ssis Developer Interview Questions
