Find jobs for ssis developer

Ssis developer Interview Questions

29

Ssis Developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Intellect Design Arena
SSIS and SQL Server Developer was asked...6 February 2017

Technical interviews were from RDBMS basics to all the details quoted in resume

1 Answers

Please have your basics covered before you go for the interview

Trianz

1.brief about your total experience 2.explain about your SSIS dev activities what you have done and packages you have developed 3.transformations used 4.different sources 5.SSIS package, all of the sudden not running, what could be the reasons, how do you troubleshoot to resolve this. 6. when working with excel as a source, what are the things we need to consider or things to remember?. 7.how will you implement error handling? 8.use of checkpoint and scenario you have used? 9.different kinds of SSIS deployments? 10.SSIS package running slowly, many transformations, how to identify the bottlenecks in the package. 11.materialized view

1 Answers

I answered to my best of knowledge.

Healthesystems

What is a configuration file and what do you use it for? Have you ever used an SSIS template? How do you troubleshoot a failed package?

1 Answers

To make a package dynamic which makes to run on any server, we create a configuration file. Suppose we created a package in dev server and we are now deploying it to QA or prod. Then the properties like server names, databases names etc vary from one server to other. So inorder not going in everpackage change, we just change those properties in config file and we run package by adding that config file. Now same package runs on every server, just changing the properties in config file. We can create config file as XML, sqlsetver, registry,parent child or Windows event. We can troubleshoot an error in a package by searching the error codes in the execution page. Less

Healthesystems

Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?

1 Answers

The 5 tasks mostly used are execute SQL task, data flow task, send mail task, file system task, execute process task And the ways to execute a SSIS package are: Using dtexec.exe , dtexecui and from the Ssdt application, sqlagent etc To access for errors we can see the log files and if it is SSIS 2012 and plus versions, in the integration services catalog the log information is saved. Less

Ness Digital Engineering

Tell me about your project?

1 Answers

Better

CapTech

What types of BI tools are you familiar with/have you used?

Healthesystems

How do you feel about change? Why do you want to work here?

Healthesystems

Describe a day at work.

HARMAN

1) Types pf containers?? 2) Merge Join in brief 3) Precedence constraints workflow. 4) Explain What Is A Checkpoint In Ssis?

LTI

C# - SOLID DESIGN PRINCIPLES

Viewing 1 - 10 of 29 interview questions

See Interview Questions for Similar Jobs