Informatica Administrator Interview Questions and Answers

Steps to be taken when prod goes down

• Identify the root cause of the issue

• Notify the relevant stakeholders

• Initiate the incident management process

• Restore the service as quickly as possible

• Conduct a post-mortem analysis to prevent future occurrences

Prod deployment involves several steps including testing, installation, hotfixes, and bugfixes.

• Create a deployment plan and schedule

• Test the deployment in a non-production environment

• Install the software on production servers

• Apply hotfixes and bugfixes as needed

• Perform post-deployment testing to ensure everything is working correctly

Informatica upgrade involves upgrading the Informatica PowerCenter software to a newer version.

• Before upgrading, check the compatibility of the new version with the existing hardware and software.

• Create a backup of the existing repository and domain databases.

• Install the new version of Informatica PowerCenter software.

• Upgrade the repository and domain databases.

• Test the upgraded environment thoroughly before putting it into production.