Analyst Integration

  Home  Analysis  Analyst Integration


“Analyst Integration Frequently Asked Questions in various Integration Programmer job Interviews by interviewer. The set of questions here ensures that you offer a perfect answer posed to you. So get preparation for your new job hunting”



87 Analyst Integration Questions And Answers

41⟩ Basic Systems Integration Analyst interview questions

► Situation where others disagreed with your ideas.

► What is the most difficult thing about working with you?

► What do you see yourself doing within the first days as Systems Integration Analyst ?

► What have you learned from your mistakes?

► How do you handle problems with customers?

► What do you like and dislike about Systems Integration Analyst job we are discussing?

► What motivates you to do a good job?

Focus on yourself and your talents, not other people's flaws.

Say something about your interest and how it can help you on the job you are applying for.

Having a plan for your future demonstrates motivation and ambition, both of which are important qualities.

 138 views

42⟩ Telephonic Systems Integration Analyst interview questions

► What are top 3 skills for Systems Integration Analyst ?

► What are common risks for Systems Integration Analyst ? And how to face?

► What three character traits would your friends use to describe you?

► What's your salary history?

► How do you evaluate your ability to handle conflict?

► What is your usual role in a team?

► Example of adaptation to changes and the difficulties.

 119 views

43⟩ Face to Face Systems Integration Analyst interview questions

► When did you last update your Systems Integration Analyst education?

► Try to define processes and methodologies you use in your Systems Integration Analyst job.

► Specific example of a time when criticised your work.

► What do you do if you disagree with your boss?

► What kinds of decisions are most difficult for you?

► What is your greatest achievement outside of work?

► Describe how you have balanced your academic work with your extracurricular activities.

The interviewer is looking for work-related strengths. When answering these typical Systems Integration Analyst interview questions stay focussed on career goals and aspirations. Explain why you are interested in the job and ask questions about what you possibly dislike.

 138 views

44⟩ How do you find if a number is power of two, without using arithmetic operator?

Assume its a question about using bitwise operator as soon as you hear restriction about not allowed to use arithmetic operator. If that restriction is not in place then you can easily check if a number is power of two by using modulus and division operator. By the using bitwise operator, there is a nice trick to do this. You can use following code to check if a number if power of two or not

public static boolean powerOfTwo(int x) {

return (x & (x - 1)) == 0;

}

x & (x-1) is a nice trick to convert right most bit to zero if it's on, I learned from hackers delight book.

 125 views

45⟩ What is the difference between iteration and recursion?

Iteration uses loop to perform same step again and again while recursion calls function itself to do the repetitive task. Many times recursion result in a clear and concise solution of complex problem e.g. tower of Hanoi, reversing a linked list or reversing a String itself. One drawback of recursion is depth, since recursion stores intermediate result in stack you can only go upto certain depth, after that your program will die with StackOverFlowError, this is why iteration is preferred over recursion in production code.

 139 views

46⟩ If I have a Web application that I find is still running (via top/ps/whatever) but users are getting "connection refused" when trying to access it, how would I go about diagnosing the problem?

With the answer to that question, I get to hear about the interviewee's thought process, favorite diagnostic tools, and biases, as well as whether they really know how to solve problems. Getting the "right" answer isn't important, but it tells me about how the person thinks and how well they've familiarized themselves with the tools they use.

 122 views

47⟩ What are some important differences between a linked list and an array?

linked list and array are two of the most important data structure in programming world. Most significant difference between them is that array stores its element at contiguous location while linked list stores its data anywhere in memory. This gives linked list enormous flexibility to expand itself because memory is always scattered. It's always possible that you wouldn't be able to create an array to store 1M integers but can do by using linked list because space is available but not as contiguous chunk. All other differences are result of this fact. For example you can search an element in array with O(1) time if you know the index but searching will take O(n) time in linked list. For more differences see the detailed answer.

 115 views

49⟩ What are the three major types of data integration jobs?

Following are the major data integration jobs:

► Transformation jobs - for preparing data

► Should be used when data must not be changed unless job completion of transforming data of a particular subject of interest

► Provisioning jobs - for transmission of data

► Should be used when data must not be changed unless job transformation when the data provisioning is large.

► Hybrid jobs - to perform both transformation and provisioning jobs.

► Data must be changed irrespective of success / failure.

► Should be implemented neither the transformation nor the provisioning requirements are large

 104 views

50⟩ Is Data integration And ETL programming is same?

► No, Data Integration and ETL programming are different.

► Passing of data to different systems from other systems is known as data integration.

► It may integrate data within the same application.

► ETL, on the other hand, is to extract the data from different sources.

► The primary ETL tool job is to transform the data and loads into other objects or tables.

 116 views

51⟩ Explain about various caches available in Data Integrator?

► NO_CACHE - It is used for not caching values.

► PRE_LOAD_CACHE - Result column preloads and compares the column into the memory, prior to executing the lookup.

► PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.

► DEMAND_LOAD_CACHE - Result column loads and compares the column into the memory when a function performs the execution.

► DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

 137 views

52⟩ What are the factors that are addressed to integrate data?

Following are the data integration factors:

► Sub set of the available data should be optimal.

► Noise/distortion estimation levels because of sensory/processing conditions at the

time of data collection.

► Accuracy, spatial and spectral resolution of data.

► Data formats, storage and retrieval mechanisms.

► Efficiency of computation for integrating data sets to reach the goals.

 124 views

54⟩ Write SQL query to find second highest salary in employee table?

This is one of the classic question from SQL interviews, event it's quite old it is still interesting and has lots of follow-up you can use to check depth of candidate's knowledge. You can find second highest salary by using correlated and non-correlated sub query. You can also use keyword's like TOP or LIMIT if you are using SQL Server or MySQL, given Interviewer allows you. The simplest way to find 2nd highest salary is following :

SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)

This query first find maximum salary and then exclude that from list and again finds maximum salary. Obviously second time, it would be second highest salary.

 118 views

55⟩ Explain about Pivot - Columns to Rows?

► Data Integrator produces a row in the output data set for every value in the designated pivot column.

► More than one pivot column can be set as per the need of application's data integration.

► Pivot Sequence Column - Data Integrator increments a sequence number for every row created from a pivot column.

► Non-Pivot column - The columns that need to appear in the target.

► Pivot Set - A group of pivot columns, unique data field and header column.

► Data Field Column - It contains the pivot data along with pivot columns values.

► Header Column - Lists the name of the columns.

 130 views

56⟩ What is System Design Document (SDD)?

A software design description (SDD) is a written description of a software product, that a software designer writes in order to give a software development team overall guidance to the architecture of the software project. An SDD usually accompanies an architecture diagram with pointers to detailed feature specifications of smaller pieces of the design. Practically, the description is required to coordinate a large team under a single vision, needs to be a stable reference, and outline all parts of the software and how they will work.

 155 views

57⟩ What is the result of 1 XOR 1?

Answer is zero, because XOR returns 1 if two operands are distinct and zero if two operands are same, for example 0 XOR 0 is also zero, but 0 XOR 1 or 1 XOR 0 is always 1.

 124 views

58⟩ Explain what is Traceability Matrix?

A traceability matrix is a document, usually in the form of a table, that correlates any two baselined documents that require a many-to-many relationship to determine the completeness of the relationship.

 131 views

59⟩ Describe how to adjust the performance of Data Integrator?

Following are the ways to perform this:

► Using array fetch size.

► Ordering the joins.

► Extracted data minimizing.

► Locale conversion minimization.

► Setting target-based options to optimize the performance.

► Improving throughput.

► Data type conversion minimization.

 125 views

60⟩ Explain what is Uniform Data Access Integration?

► UDAI places the data in the source systems.

► A set of views are defined for providing access the unified view to the clients / customers.

► Zero latency of data can be propagated from the source system.

► The generated consolidated data need not require separate storage space.

► Data history and version management is limited and applied only to the similar type of data.

► Accessing to the user data overloads on the source systems.

 123 views