Premium Employer

i

This company page is being actively managed by Infosys Team. If you also belong to the team, you can get access from here

Infosys Verified Tick Work with us arrow

Compare button icon Compare button icon Compare

Filter interviews by

Infosys Senior Datastage Developer Interview Questions and Answers

Updated 29 Dec 2020

Infosys Senior Datastage Developer Interview Experiences

1 interview found

I applied via Walk-in and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How to implement SCD Type 2?
  • Ans. 

    SCD Type 2 is implemented by creating a new record for each change in dimension attributes and maintaining a history of changes.

    • Identify the dimension attributes that need to be tracked for changes

    • Add a surrogate key to the dimension table

    • Create a new record with a new surrogate key for each change in dimension attributes

    • End-date the previous record when a new record is created

    • Maintain a history of changes by keeping a...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - For 3 year experience

What people are saying about Infosys

View All
yedabhai
2d
works at
Hyperpure
Are we not even safe in our own workplaces?
An Infosys employee was arrested for secretly recording women in the office washroom. Over 30 videos were found on his phone. This isn't just shocking, it's horrifying. Offices are meant to be safe, respectful spaces. 🙎 When will companies truly prioritize safety and surveillance in all corners, not just the visible ones?
FeedCard Image
Got a question about Infosys?
Ask anonymously on communities.

Interview questions from similar companies

I applied via LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Easy logical questions
basic quant

Round 2 - Coding Test 

Easy level coding questions
Counting frequency of alphabets

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go through the basics of javascript
Hoisting

Senior Datastage Developer Interview Questions Asked at Other Companies

asked in Infosys
Q1. How do you implement SCD Type 2?

Interview Questionnaire 

1 Question

  • Q1. How to use multiple dispatch in redux?
  • Ans. 

    Multiple dispatch is not a feature of Redux. It can be achieved using middleware or custom logic.

    • Middleware like redux-thunk or redux-saga can be used to dispatch multiple actions based on a single action.

    • Custom logic can be implemented in the reducer to handle multiple actions based on a single action type.

    • For example, a single 'ADD_ITEM' action can trigger multiple actions like 'UPDATE_TOTAL', 'UPDATE_HISTORY', etc.

    • M...

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What technical challenges have you faced in your work till now and how did you overcome it?
  • Ans. 

    Faced various technical challenges, including system integration and performance optimization, which I successfully navigated through strategic solutions.

    • Integration of legacy systems with modern applications: I utilized APIs and middleware to ensure seamless data flow.

    • Performance bottlenecks in a web application: Implemented caching strategies and optimized database queries, resulting in a 40% speed increase.

    • Debugging...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be truthful and give detailed explanation of the issues and how it was resolved. Explain the severity of the problem and what blockage it had caused in your daily work. How did you chose a solution and how fast was it implemented.

I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1.Technical Ques(OOPS Concept)and 2. Area of Interest 3. About Company 4. more

Interview Preparation Tips

Interview preparation tips for other job seekers - Hello Folks,
Sharing some tips while facing Interview Assessment or GD Round Assessment.
1. Be Confident always give the answer what they ask for, Never connect your answer with different topic.
2. Always go through Company Portal or wiki about their Operation & Function.
3. Always have positive vibes that whatever yes or No, You will surely gain something.
All the Best..!!

Interview Questionnaire 

1 Question

  • Q1. All about SQL joins,data warehouse.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared and answer only if you know the concept clearly.
Are these interview questions helpful?

I applied via Naukri.com and was interviewed before Apr 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Technical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - I have visited interview location on morning 7am DLF block Hyderabad. Buy my interview was taken in evening 6:45pm. That was not an interview test it was a patience test.

Interview Questionnaire 

3 Questions

  • Q1. Tell me something about yourself
  • Ans. 

    I am a passionate software developer with 5 years of experience in developing web applications using various technologies.

    • 5 years of experience in software development

    • Proficient in developing web applications

    • Skilled in using various technologies

    • Passionate about coding and problem-solving

  • Answered by AI
  • Q2. What is the difference between encapsulation and polymorphism?
  • Q3. What do you mean by deadlock in OS?
  • Ans. 

    Deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular waiting state.

    • It happens when processes compete for resources and each process holds a resource that another process needs.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and ...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: We were asked to solve a questionnaire containing 25 questions based on logical reasoning and basic mathematics. We went to the test center in their recruitment center where there were many desktops for the candidates to sit and give the test. At the entrance, they checked the letter we got from them to authenticate us.Then they gave us a login ID and password. Exactly when the test started, the portal became active and we were asked to enter the credentials. I completed the test in half the time as it was pretty easy and straightforward.
Tips: Practice simple aptitude questions for greater speed and accuracy.
Duration: 1 hour
Total Questions: 20

Round: Group Discussion
Experience: Ten candidates who were shortlisted from the written test attended the group discussion. The topic given to us was fairly simple and lucky for me, I used to work as an anchor, and being a strong feminist person, I had a lot of valid points to put forward. I was the one to start the discussion, and I felt I was the best speaker there. The topic was something that I follow regularly, yet I came across a few unique points from the other candidates.
Tips: Improve your English speaking skills. Be assertive and speak concisely.
Duration: 15 minutes

Round: HR Interview
Experience: The interview basically revolved around this one question which had a few follow-up questions, such as who all are there in my family, what are my strengths and weaknesses, and why am I fit for this job.
Tips: Be confident and honest about yourself.

Round: Technical Interview
Experience: I tried to be as calm and confident as possible during the whole of the interview

College Name: Guru Nanak Institute of Technology (GNIT)

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Process builder. 2.types of relationships. 3.difference in user ,profile and role. 4.workflow. 5.Admin questions
  • Ans. 

    Answering questions related to software development and Salesforce administration.

    • Process Builder is a visual tool in Salesforce used to automate business processes.

    • Types of relationships in Salesforce include lookup, master-detail, and many-to-many relationships.

    • User represents an individual who can log in and access Salesforce, Profile defines the permissions and settings for a user, and Role determines the hierarchy...

  • Answered by AI
  • Q2. What configuration i have done.
  • Ans. 

    I have configured various software systems and tools for development purposes.

    • Configured IDEs such as Eclipse and Visual Studio for development

    • Set up version control systems like Git and SVN

    • Installed and configured build tools like Maven and Gradle

    • Configured application servers like Tomcat and JBoss

    • Set up databases like MySQL and Oracle for development and testing

  • Answered by AI
  • Q3. Salary negotiations

Interview Preparation Tips

Round: Manager round
Experience: Configuration and what work ee have done in your previous company.

Skills evaluated in this interview

Tell us how to improve this page.

Join Infosys Creating the next opportunity for people, businesses & communities

Interview Questions from Similar Companies

TCS Interview Questions
3.6
 • 11.1k Interviews
Accenture Interview Questions
3.8
 • 8.6k Interviews
Wipro Interview Questions
3.7
 • 6.1k Interviews
Cognizant Interview Questions
3.7
 • 5.9k Interviews
Capgemini Interview Questions
3.7
 • 5.1k Interviews
Tech Mahindra Interview Questions
3.5
 • 4.1k Interviews
HCLTech Interview Questions
3.5
 • 4.1k Interviews
Genpact Interview Questions
3.8
 • 3.4k Interviews
LTIMindtree Interview Questions
3.7
 • 3k Interviews
IBM Interview Questions
4.0
 • 2.5k Interviews
View all
Infosys Senior Datastage Developer Salary
based on 7 salaries
₹4.9 L/yr - ₹15 L/yr
24% less than the average Senior Datastage Developer Salary in India
View more details

Infosys Senior Datastage Developer Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Technology Analyst
55.8k salaries
unlock blur

₹4.8 L/yr - ₹11.1 L/yr

Senior Systems Engineer
53.8k salaries
unlock blur

₹2.5 L/yr - ₹6.3 L/yr

Technical Lead
35.1k salaries
unlock blur

₹9.4 L/yr - ₹16.4 L/yr

System Engineer
32.5k salaries
unlock blur

₹2.4 L/yr - ₹5.3 L/yr

Senior Associate Consultant
31.1k salaries
unlock blur

₹8.1 L/yr - ₹15 L/yr

Explore more salaries
Compare Infosys with

TCS

3.6
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.7
Compare
write
Share an Interview