Home

Bhargav Sai - Informatica Administrator

[email protected]

Location: Remote, Remote, USA

Relocation:

Visa: H1b

Bhargava Sai Chalamalasetti Phone: 8036863686 Professional Summary: 7 years of experience in handling admin activities of Informatica Power Center(PWC), Informatica Data integration hub(DIH), Informatica Data quality(IDQ), Informatica Big data management(BDM),IICS and IDMC. Expertize in performing installations, version upgrades, hotfixes and applying EBFS, Edifecs patches on Informatica Power center, Informatica Data integration hub, Informatica Data quality and Informatica BDM. Automation of regular activities like housekeeping, Repository Backups. Handling User Access Management via LDAP and SAILPOINT for Informatica PWC, DIH, IDQ, BDM, Remote desktops, and for Qlikview. Code migrations across the environments for Informatica PWC, DIH, IDQ, BDM and IDMC through manual, deployment groups, CICD pipelines. Creation of connections to SAP systems, Oracle systems, odbc(sql,hadoop), teradata(tpt), Salesforce, Azure DWV3. Performing activities like Updating bashprofiles, folder creation at Server and client level, maintaining passwords, connection password resets, updating host names at connection level, unlocking users, deletion of objects, permission issues. Regular Health checkups of Linux servers and windows remote desktops. Applying SSL certificates. Applying new and incremental licenses. Creation /Handling of services based on the requirement like integrations services based on the type of network, SSL enabled and non SSL enabled systems and type of connecting systems. Maintaining secured and non - secured Oracle clients both at server and client level. Installations and upgrades of client tools like SQLA(Teradata), SQL developer(oracle), SQL server management studio (sql servers). Establishing sftps through exchange of keys between the servers and also testing the sftp connectivity among the servers. Handling job failures, performance issues and Platform related issues. Handling the applications at times of OS and DB patching. Working with infra team to ensure with firewall access. Handling vulnerability tickets of informatica and Talend. Informatica power center Job monitoring and performing YEC and Mid-YEC activities. Audit reports for Quarterly and Annual basis. Handling service- now tickets with P1, P2 tickets of 24x7 service and p3 and p4 tickets of 5x18hrs service. Worked as an associate for moving servers from on-premise servers to Azure cloud (for POC). Collaborating with Architects, Technical leads for new requirements/setups. Collaborating with Informatica global support for new issues, with infra teams (OS, Linux, DBA teams) and other supporting system teams during application related issues. Taking up interviews, nurturing the new talents and making them to work independent through practice of documentation. Basic development activities in informatica power center. Regular Backup activities in case of disasters. Creation of org and sub-org in IICS and IDMC. Creation of users, user groups assigning privileges in IICS and IDMC. Migration of assets among the orgs in IICS and IDMC. Creation of connections and adding new connectors in IICS and IDMC. Installation of secure agents on Linux and windows servers in IICS and IDMC. Maintaining alerts for secure agents,disc space utilization,cpu utilization,memory utilization in IICS and IDMC. Technical Skills: Skill/Tools Versions Informatica Power Center 9.6, 10.2, 10.2HF2, 10.4.1,10.5.2 Data Integration Hub 9.6, 10.2.3 IDQ 10.4.1,10.5.2 Informatica BDM 10.4.1 Linux Red Hat Linux 5*,6* Sql 13.0 Teradata 13.0,14.0,14.1,15.0 Sql Developer 4.1.1, 4.1.2,4.1.3, 17.2 Sql server management studio 17.0,18.0 Service-Now NA Microsoft DLP 2016 Qlikview 12.4 IICS IDMC Educational Details: Bachelors in Electronics and Communication KL UNIVERSITY, INDIA Professional Experience: Cognizant Technologies Client : Centene, United States of America JUN 2022 JUN 2023 Role: Informatica Admin Responsibilities: Installation of informatica power center 10.4.0. Upgraded Informatica power center from 10.4.0 to 10.5.2. Installation of Inforamtica Data Quality 10.4.0. Upgraded Informatica Data Quality from 10.4.0 to 10.5.2 Applying Edifecs on Informatica Power center. Handling vulnerability tickets across informatica and Talend. Weekly maintenance activities like services restarts of Power center, IDQ and BDM. Health monitoring of the servers. Talend Deployments. User access management of Informatica power center, IDQ and Talend. Migrations of codes across the environments of Informatica power center via Jenkins, CICD pilplines and Talend via JFROG and TAC. Handling performance issues at Informatica power center. Working on health condition of the Linux servers like CPU utilization and disk space management. Creation of connections, migration of code in IDMC. Collaborating with infra teams, integrating system teams for OS, Linux, and application related issues Working on shifts and 24x7 support for P1 and P2 tickets and handling release and change tasks within the time windows. Creation of connections for Oracle, SQl server and Teradata systems. Wrt IICS and IDMC, moving files from Local machine to S3 bucket and from S3 bucket to EC2 instance and vice versa. Creation of org and sub-org in IICS and IDMC. Creation of users, user groups assigning privileges in IICS and IDMC. Migration of assets among the orgs in IICS and IDMC. Creation of connections and adding new connectors in IICS and IDMC. Installation of secure agents on Linux and windows servers in IICS and IDMC. Maintaining alerts for secure agents, disc space utilization, cpu utilization, memory utilization in IICS and IDMC. Cognizant Technologies Client: Kaiser Permanente, United States of America MAR 2021 JUN 2022 Role: Informatica Admin Responsibilities: Applying Log4j EBF across Informatica power center and BDM. Handling 43 Informatica Repositories, 5 environments of BDM, 3 environments of IDQ, 2 environments of TDM. Weekly maintenance activities like services restarts of Power center, IDQ, BDM, MM and TDM. User access management of Informatica power center, IDQ, BDM and TDM. Code deployments across the environments. Health monitoring of the servers. Handling performance issues of Informatica power center. Handling truststore and Keystore of informatica power center. Activities like updating bashprofiles , folder creation at Server and client level, creation of connections, connection password resets , updating host names, unlocking users, deletion of objects, permission issues. Exchanging of keys for establishing of Sftps. Testing of sftp connectivity between the servers. Testing the servers post upgrade/patching activities of OS and DB level. Synching the parameters across the environments of IDQ and BDM. Collaborating with infra teams, integrating system teams for OS, Linux, and application related issues Working on shifts and 24x7 support for P1 and P2 tickets and handling release and change tasks within the time windows. Wipro Technologies Client: Philips, Netherlands JAN 2016 MAR 2021 Role: Informatica Admin Responsibilities: Automation of Housekeeping activities and Repository Backups Upgraded informatica power center from version 9.6 to 10.2. Applied hotfix 2 on informatica power center 10.2 Upgraded Informatica Data Integration Hub from version 9.6 to 10.2.3 Applying EBF's. User Access Management via LDAP and SAILPOINT for informatica power center, Data integration hub,Remote desktops and for Qlikview. Handling platform related issues on Informatica power Center and DIH across 4 environments each. Informatica power center /DIH Code migrations across the environments Installations and upgrades of client tools like SQLA(Teradata), SQL developer(oracle), SQL server management studio (sql servers). Ensuring firewall access through collaborating with Infra team Handling the applications at times of OS and DB patching. Upgrading the client s tools at server level of informatica power center like oracle and Teradata clients. Exchanging of keys among the servers for establishing of Sftps. Testing of sftps, firewall access, Connectivity checks post upgrade/patching activities of OS and DB level. Regular Health checkups of servers including remote desktops. Creation of connections to SAP systems, Oracle systems, odbc(sql,hadoop), Teradata(tpt), Salesforce, Azure DWV3, Activities like Updating bashprofiles, folder creation at Server and client level, maintaining passwords, connection password resets, updating host names, unlocking users, deletion of objects, permission issues. Applying certificates for SSL-oracle connections. Maintaining both secured and non- secured Oracle clients both at server and client level of Informatica power center. Applying License including new and incremental licenses. Creation /Handling of services of informatica based on requirement like integration services based on the type of network, ssl enabled systems and connecting systems. Audit reports for Quarterly, Annual basis. Informatica power center Job monitoring and performing YEC and Mid-YEC activities. Working with Informatica Global support on new issues. Leading the Functional application Support of Informatica power center, Data integration Hub and Remote Desktops. Worked as an associate for POC for moving servers from on-premise servers to Azure cloud. Collaborating with infra teams, integrating system teams for OS, Linux, and application related issues. Working on shifts and 24x7 support for P1 and P2 tickets. Collaborating with Architects, Technical leads for new requirements/setups. Taking up interviews, nurturing the new talents and making them to work independent through practice of documentation. Education Details: Electronics and Communication Engineering, KL University, Andhra Pradesh, India Keywords: materials management sthree database