Summary
Overview
Work History
Education
Skills
Disclaimer
Timeline
Generic

Subramanyam M

Informatica Administrator

Summary

Confident and committed technical professional seeking a challenging role as a Technical Team Member in a dynamic work environment. Bringing expertise in problem-solving, technical analysis, and communication, with a strong focus on responsibility and success. Eager to apply my experience and skills toward mutual growth and organizational development.

Overview

9
9
years of professional experience

Work History

Software Engineer

Deloitte
07.2023 - Current
  • A project I used to support the informatica applications like Informatica PowerCenter, IDQ, DDM and IICS for various platforms named as ICS, WMAP, Aspire, Sales vision etc
  • The data integration, warehousing and masking as per the business needs
  • Having experience of Installation and Configuration and upgradation of Informatica power center and data quality Server/Client Version 10.2.0, 10.5.2, DEV, QA, UAT and Production environments
  • Bouncing up of the Informatica repository servers - Bringing the Informatica Integration services down/up for planned down times
  • Services maintenance when any security level patches planned
  • Creation of Informatica application services like Repository, Integration Services and GRID setup
  • Analyzing the environment issues and report to Informatica support team for the permanent solution
  • Installed the new hot fixes to adopt the resolution from Informatica code bugs or enhancements
  • Creation of Informatica new users and groups & giving necessary Access privileges to them
  • Creation of New folders in Repository and granting permissions
  • Monitoring the Repository & Integration services of all Development, QA& Production
  • Maintenance of the script's usage on servers such as Repository backup, Disk Space monitoring, Server monitoring for all the Environments
  • Power Exchange configuration in addition to the Informatica powercenter
  • Creation of Relational connections in workflow manager
  • Migration of the UNIX scripts, Parameter files from one environment to another
  • Worked on Versioned Repository with code check-in & check-out functionality
  • Provide support to ETL application development/production teams
  • Import & Exporting of the objects into the Shared folders and in the required folders
  • Managing and Scheduling the Backups of all the Domain and Repository
  • Worked on Tidal scheduler to schedule the Informatica workflows and configuring the tidal agents
  • Analyzing and enhancing the existing Informatica domains with proper business standards
  • Providing the technical support guidance for the own team members to fix the critical issues arrives in the environments
  • Worked on IDQ address doctor license renewal and update
  • Installing the DR setup for existing production environment
  • DDM installation and upgradation to 8x versions, and applying the masking rules
  • Involved in IICS configuration, Code promotions across various environments
  • Planning on Incidents, Service catalog tasks, Problem tickets and CSI activities on day-to-day activities
  • Having Good knowlege on AWS components like S3, EC2 & RDS etc.
  • Environment: Informatica Power center 10.5.1, 10.5.2, IDQ 10.5.2, DDM 8x, IICS, Oracle 12c, Linux, Informatica, BMC Remedy, Putty, Winscp, Bladelogic
  • RHEL 8x

Software Engineer

Cognizant
08.2021 - 03.2023
  • Company Overview: Kilinio Bibliotheek is an insurance company which provides the insurance data to integrate with various platforms
  • Manage Informatica environment which involved products like: Power Center, IDQ
  • Follow and Educate users on the standards set in the platform
  • Involved in Intake calls for new project setup and understand their requirements
  • Setup new project folders according to their platform requirements
  • Involved in Platform expansion by adding new servers
  • Platform upgrade from 9x versions to 10x versions which involves other application upgrades like Oracle upgrade to 11G, Java Upgrade and OS upgrade
  • Scripts modifications to meet platform upgrade requirements
  • Worked on Performance issues reported by application users
  • Collect core dumps, stack traces to investigate on the Informatica product issues
  • Applying EBFs for the product issues
  • Send Weekly SOX reports to application owners
  • Send CPU and Memory utilization reports to application owners on monthly basis
  • Configure OS profile in PowerCenter environment
  • Enable TLS in Power Center environments
  • Kilinio Bibliotheek is an insurance company which provides the insurance data to integrate with various platforms
  • Environment: Informatica10.5.1, SQL Server, Oracle, MySQL, Linux, Informatica, Service Now, Putty

Software Engineer Trainee

Reflex Solution
06.2018 - 05.2019
  • Company Overview: Hibbett Sports, Inc
  • Is an American publicly traded holding company for Hibbett Sporting Goods, a full line sporting goods retailer headquartered in Birmingham, Alabama
  • Creation of Informatica users and groups & giving necessary Access privileges to them
  • Creation of New folders in Repository and granting permissions
  • Creating new relational connections, ODBC and FTP connections and resolving all the connection related issues
  • Monitoring the Repository & Integration services of all Development and Production
  • Monitoring the servers, NAS mounts, CPU utilization related and disk space of the same
  • Handling outage and scheduled down times
  • Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language
  • Support multiple Informatica environments, production and development
  • Providing Root Cause analysis for ETL job failures/Data issues raised by business
  • Installation and configuration of Informatica Power Center
  • Involved in upgrades, applying EBF, contacting vendor and Carrying out root-cause analysis and solution development
  • INC/Remedy Ticket handling and problem ticket analysis with in SLA
  • Handling outage and scheduled down times, QMW (Quarterly maintenance activities) and DR activities
  • Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes
  • Hibbett Sports, Inc
  • Is an American publicly traded holding company for Hibbett Sporting Goods, a full line sporting goods retailer headquartered in Birmingham, Alabama
  • Environment: Informatica10.2, Management console, SQL Server, Linux, Toad, DB Visualizer, Putty (Telnet Client)

Software Engineer Trainee

Avidex Infotech
08.2016 - 05.2018
  • Company Overview: M&S is a online home store application with headquarters in London that specializes in selling furniture, home products and home needs
  • Deployed the Informatica Objects from one environment to another environment non-Prod (Dev-QA-Stage) and PRODUCTION
  • Have Installed the required plug-in on Informatica production and non-production environments
  • Created and Configuring Power Centre Domains, Nodes, Grids, Repository Services, Integration Services
  • Installed the new hot fixes to adopt the resolution from Informatica code bugs or enhancements
  • Created the required Informatica relational source and target connections requested by project teams
  • Moving Para files, updating the TNS and ODBC entries and test the same on server side
  • Created the folders, Groups, Roles, users and providing necessary privileges to the users
  • Closely monitored the Informatica production jobs
  • Participated in weekly status, Infrastructure and Release meetings
  • Identify, troubleshoot, and resolve issues within SDLC environments
  • Closely work with Network, System Engineers, Storage and DBA's to trouble shoots the issues
  • Actively work with Informatica product support in raising the service requests (SR#) to solve Informatica service, Infrastructure issues
  • Handled Multiple Outages in our environment and have coordinated the activities with various teams involved in the Outage
  • M&S is a online home store application with headquarters in London that specializes in selling furniture, home products and home needs
  • Environment: Informatica 9.6, Management console, SQL Server, Linux, Toad, DB Visualizer, Putty (Telnet Client)

Education

Master of Computer Applications -

VTU
Bengaluru, India
04.2001 -

Skills

Informatica PowerCenter, IDQ

AWS, IICS

Linux, Shell Scripting

Oracle, SQL

Disclaimer

I hereby declare that the above furnished Particulars are true to best of my knowledge and belief.

Timeline

Software Engineer

Deloitte
07.2023 - Current

Software Engineer

Cognizant
08.2021 - 03.2023

Software Engineer Trainee

Reflex Solution
06.2018 - 05.2019

Software Engineer Trainee

Avidex Infotech
08.2016 - 05.2018

Master of Computer Applications -

VTU
04.2001 -

Similar Profiles

CREATE PROFILE
Subramanyam MInformatica Administrator