Sumanth

Sumanth

Informatica Administrator
India

About Me

Having 4.6 years of Industry experience on Informatica Administration. Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on Windows and UNIX…

Experience

Informatica administrator

Infosys
Sep 2023 - Present · 2 years 9 months

Having 4.6 years of Industry experience on Informatica Administration.
Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on Windows and UNIX platforms, backup and recovery, folder and user account maintenance.
Involved in Installation and Configuration and up gradation of Informatica Power Center9.x/10.2x/10.5x
Proven knowledge on Informatica Administration like Creating and configuring the Informatica Domain, Application services like Integration, Repository and web services and creating the users and giving proper privileges to them.
Upgraded to Informatica Power Center 9.6.1HF4 from version 10.2 Installed Hot fixes, utilities, and patches released from Informatica Corporation
Worked on Informatica repository backups & restore activities.
Configure security for the Users and User groups, providing resolution for the issues raised by the users, involved in the LDAP configuration of Informatica.
Enabling and Disabling Services, Start or Stop the Power Center services on nodes.
Experience of Informatica Bug fixes, Patches/Hot Fixes, Automation of Backups, Purge, build scripts, start-ups and shutdown scripts.
Involved in Implemented the High Availability (HA) grid and upgrade the repository to version 9.x/10.x.
Experience of Informatica Code migration through Copy Folder / Export and Import of Objects/ Deployment groups.
Experience in Informatica IICS Cloud Administration
Creating new connections and projects and providing access to the users in IICS Console

Informatica administrator

Infosys
Sep 2023 - Dec 2023 · 3 months

Created the required Informatica relational source and target connections requested by project teams.
Performed password changes for repository and domain.
Worked on Informatica domain and repository backups and restore activities.
Moved parameter files, updated the TNS and ODBC entries, and tested them on the server side.
Created folders, groups, roles, and users and provided necessary privileges to users.
Closely monitored the Informatica production jobs.
Migrated code from one environment to another environment.
Identified, troubleshot, and resolved issues within SDLC environments.
Worked with Network, System Engineers, Storage, and DBAs to troubleshoot issues.
Worked with Informatica product support in raising service requests to solve Informatica service and infrastructure issues.
Automated monitoring of Informatica environments using UNIX, pmrep, pmcmd, and other Informatica command line language.

Informatica administrator

TCS
May 2022 - Dec 2022 · 7 months

Handled all the Informatica admin activities.
Created new users and groups and gave necessary access privileges.
Created new folders in Repository and granted permissions.
Monitored the Repository and Integration services of Development, Test, UAT, and Production.
Migrated Repository XML objects from Development to Test, UAT, and Production.
Changed admin passwords for maintaining security.
Handled outages during weekends and weekdays.
Migrated UNIX scripts and parameter files from Dev. to Test, UAT, and Production.
Worked on requests given by Dev., Enhancement, and Support teams.
Created relational connections in workflow manager.
Installed new hot fixes to adopt resolutions from Informatica code bugs or enhancements.
Maintained scripts on servers such as repository backup, disk space monitoring, and server monitoring for all environments.
Managed and scheduled backups of all the Domain and Repository.
Provided support to ETL application development and production teams.
Imported and exported objects into shared folders and required folders.
Granted additional permissions and privileges to Repository users.

Informatica administrator

DELL
Jun 2018 - Apr 2022 · 3 years 10 months

Installed the required plug-in on Informatica production and non-production environments.
Created and configured Power Centre Domains, Nodes, Grids, Repository Services, and Integration Services.
Installed new hot fixes to adopt resolutions from Informatica code bugs or enhancements.
Created required Informatica relational source and target connections requested by project teams.
Performed password changes for repository and domain.
Worked on Informatica domain and repository backups and restore activities.
Moved parameter files, updated the TNS and ODBC entries, and tested them on the server side.
Created folders, groups, roles, and users and provided necessary privileges to users.
Closely monitored the Informatica production jobs.
Participated in weekly status, infrastructure, and release meetings.
Identified, troubleshot, and resolved issues within SDLC environments.
Worked with Network, System Engineers, Storage, and DBAs to troubleshoot issues.
Worked with Informatica product support in raising service requests to solve Informatica service and infrastructure issues.
Automated monitoring of Informatica environments using UNIX, pmrep, pmcmd, and other Informatica command line language.

Skills

Database Administration Coordination MS SQL DBA MS SQL MS Sql Server MySQL Unix Administration UNIX Linux/Unix Oracle SQL Professional Linux OS Informatica PowerCenter Windows Mac OS Oracle 10g Oracle 11g SQL Server Control-M Informatica Scheduler ServiceNow Jira Airflow DB Weaver PagerDuty IICS Cloud Administration LDAP pmrep pmcmd ETL High Availability (HA) Copy Folder Export and Import Deployment groups SQL Snowflake Salesforce Redshift
Report this Profile?