Skip to contentSkip to footer

Senior Informatica Developer Interview Questions

Salaries
Interviews

25 senior informatica developer interview questions shared by candidates

1. A scenario in your project where you tuned the performance of the mappings, how did you tune it? 2. How will you identify where or which transformation needs tuning? 3. What operations can be performed using update strategy? 4. Scenario: I have 10 source files and 10 target tables. How will you load the data from these files to 10 target tables using only one mapping? (Dynamic parameters) 5. Scenario: I have 10 source files and 1 target table. How will you load the data from these 10 files to 1 target table using only one mapping? 6. About dynamic lookup and can it be used as connected or unconnected lookup 7. How will you get the performance statistics for a mapping? 8. Advantages of incremental aggregation 9. Scenario: A file has 3 fields. What is the unix command to fetch the third field in sorted manner 10. How will you find out the status of a running job in unix? Unix command 11. Scenario: You know the file name but do not know where it is in the file system. How will you search for that file using UNIX command? 12. How will you find duplicate records in a table? 13. How will you delete duplicate records from a table? 14. How will you deal with a conflict that arises with your team member? 15. When the requirements are incomplete or not clear, and you do not receive any further inputs, how will you design or implement in this case? 16. You are working on a priority issue with av extremely short deadline and you get a request from the client for another very high priority task. How will you deal with this kind of scenario? 17. The server goes down for 3 days and all the jobs or help up. Once the server is up, what will be your approach or what steps will you take after the server is up or during such failures?
avatar

Sr. Informatica Developer

Interviewed at Amdocs

3.7★
Sep 17, 2020

1. A scenario in your project where you tuned the performance of the mappings, how did you tune it? 2. How will you identify where or which transformation needs tuning? 3. What operations can be performed using update strategy? 4. Scenario: I have 10 source files and 10 target tables. How will you load the data from these files to 10 target tables using only one mapping? (Dynamic parameters) 5. Scenario: I have 10 source files and 1 target table. How will you load the data from these 10 files to 1 target table using only one mapping? 6. About dynamic lookup and can it be used as connected or unconnected lookup 7. How will you get the performance statistics for a mapping? 8. Advantages of incremental aggregation 9. Scenario: A file has 3 fields. What is the unix command to fetch the third field in sorted manner 10. How will you find out the status of a running job in unix? Unix command 11. Scenario: You know the file name but do not know where it is in the file system. How will you search for that file using UNIX command? 12. How will you find duplicate records in a table? 13. How will you delete duplicate records from a table? 14. How will you deal with a conflict that arises with your team member? 15. When the requirements are incomplete or not clear, and you do not receive any further inputs, how will you design or implement in this case? 16. You are working on a priority issue with av extremely short deadline and you get a request from the client for another very high priority task. How will you deal with this kind of scenario? 17. The server goes down for 3 days and all the jobs or help up. Once the server is up, what will be your approach or what steps will you take after the server is up or during such failures?

Viewing 11 - 20 interview questions

Glassdoor has 25 interview questions and reports from Senior informatica developer interviews. Prepare for your interview. Get hired. Love your job.