SUMMARY

• I have 12.5 years of experience in IT industry and currently working as Senior Informatica Administrator. I Worked in Confidential, Healthcare, Pharmaceutical, and Banking domains.
• Advanced INFORMATICA Admin Certified Professional and also certified in internal ITIL Service Desk Incident, Problem and Change Management.
• Good experience in Informatica Power center server installation and Up - gradations from Informatica 8.1.1 to 8.6.1, from 8.6.1 to 9.6.x and from 9.6.1 to 10.1 and 10.1 to 10.2
• Good experience in Installation, Configuration and Up-gradation of Informatica MDM Hub/Process Server /Active VOS/ and IDD on various versions 10.2 and 10.3, HF1
• I have successfully automated Informatica MDM 10.3 installation and configuration process using shell script
• I have automated MDM services and elastic search services for auto-start, to bring up services automatically after Linux server reboot.
• I have automated to schedule MDM and BDM jobs using CA scheduler tool
• Good experience in creating, configuring and registering system & Operational ORS's for MDM Hub & Cleanse Server's/Process Server's
• Applied Hot Fixes (HF's) and Emergency Bug Fixes for MDM, PowerCenter and Cloud environments.
• Good knowledge with the Installation/Upgrade process for the BDM and EDC(Enterprise Data Catalogue) and their association with the different application services on the domain.
• I have installed and configured Informatica BDM 10.2.0 and integrated with the Kerberos and enabled hadoop Frameworks
• Performed Extensive Performance tuning on JVM with respect to Web Logic and MDM application
• Trouble shooting of Web Services and Web Logic Server on MDM side.
• Strong Knowledge in Informatica Power center, Metadata manager, Informatica Data quality (IDQ), Proactive monitoring- PCPM and Data Validation option (DVO) tools and completely involved in MM and IDQ installation and setup
• Good Experienced in Installation, Configuration, and Administration of Informatica Data Quality (IDQ) and MDM hub
• Good knowledge in Informatica Cloud services (ICS) and Informatica Intelligent cloud services (IICS)
• Good knowledge in up-gradation from ICS (Informatica cloud services) to IICS (Informatica Intelligent cloud services)
• Successfully Installed and configured multiple Secure agents (SA) for ICS and IICS platforms
• Implemented load balancing for ICS and IICS
• Implemented high availability for ICS and IICS
• Provided near to zero down time interim solution for end customer during Informatica cloud release upgrades like from R30 to R31, R31 to R32 release upgrades
• Good experience in regular administration activities for Informatica MDM and for BDM
• Good Experience in Administration, Implementation of Data Warehouse projects with Informatica Power Center versions 10.1/ 9.6.1/9.1/8.6/8.1
• Knowledge in Hadoop Hortonworks Admin support on Ambari console, HIVE,HDFS,PIG and Spark
• Created and Maintained Data Integration service DIS and deployed applications into IDQ
• Created IDQ connections and worked on Analyst tool
• Good Knowledge in Data replication tools like IBM CDC
• Extensively worked in Informatica Admin console and tools Repository manager, Designer, Workflow manager, Workflow monitor.
• Good Knowledge in administration activities using INFORMATICA Administration Console.
• Installation and Configuration of the INFORMATICA servers and involved in trouble shooting of Informatica jobs
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations, database administrations and database connections.
• Worked with pmcmd to interact with Informatica server from command mode and execute the shell scripts.
• Good experience in supporting migrations for Unit testing, System Integration testing, UAT and Production Support for issues raised by application users.
• Good experience in Capturing Business / Technical Requirements, design, development, testing and debugging.
• Expertise in creating mapplets and reusable transformations using Informatica.
• Self-Starter and comfortable in high intensity and challenging work environment.
• I have done Internal ITIL certification and have Good knowledge on Service-Now tool and on ITIL processes

TECHNICAL SKILLS

Informatica Tools: Informatica Power Center 10.2/10.1/9.6.1/9.1/8.6/8.1/7.1 ,PMPC3.0, DVO-960, IDQ, Power exchange, ICS and IICS, IDQ and MDM

Scripting: UNIX Shell Scripting

Databases: SQL Server 2008 and 2012, Oracle 10g, 11g, 12c and DB2

Operating Systems: Win NT/2000/XP, Sun Solaris 8/7/2.7/2.6, HP-UX, Win 3.x/95/98.

Web Technologies: HTML, JavaScript/J2EE, Java, Servlets, JSP

ITIL Tools: HP Peregrine, IBM ISM, Service now

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• I have successfully Installed and configured Informatica MDM Hub, Process Server,Active VOS and IDD on version 10.3
• I have successfully automated Informatica MDM 10.3 installation and configuration process using shell script
• I have automated MDM services and elastic search services for auto-start after Linux server reboot.
• Created, configured and registering system & Operational ORS's for MDM Hub & Process Server's
• Installed and configured MDM 10.3 on 3 node cluster environment on Jboss application server
• Successfully Implemented auto start for MDM (Jboss) services and for Elastic Search services to start services automatically after server reboot
• Supported for MDM application teams during restore from Production to Stage environments
• Deployed various CWS code migrations for MDM on Linux environment
• Helped for application teams to schedule MDM and BDM jobs through CA automation scheduler tool
• I have installed and configured Informatica BDM 10.x and integrated with the Kerberos, enabled hadoop Frameworks
• Supported for BDM application teams for all the time and resolved major issues for critical applications
• Performed various code deployments in BDM environment
• Performed EDC 10.2.2 installation and configuration
• Performed Axon 6.2 installation and configuration
• Successfully Configured and scheduled Postgresql database jobs through CA automation scheduler tool
• Debug MDM regular issues on Jboss and coordinated with Informatica Vendor
• Worked on Power exchange 10.2 listener, logger, and publisher
• Supported for Power exchange application teams all the time
• Performed various Power exchange Data map migrations using Power exchange Navigator from Dev to UAT, Stage and to Production
• Synchronizing Physical data objects

Confidential

Senior Informatica Administrator

Responsibilities:

• I have successfully upgraded from ICS to IICS (Informatica Intelligent cloud services) for multiple application teams
• I have applied multiple patches for ICS and coordinated with Informatica Vendor to resolve issues on-time
• Installed and configured multiple Secure agents (SA) for ICS and IICS cloud platforms
• Installed and configured Informatica MDM Hub/Process Server /Active VOS/ and IDD on various versions 10.1 and 10.2
• Created, configured and registering system & Operational ORS's for MDM Hub & Cleanse Server's Process Server's
• Implemented load balancing for ICS and IICs
• Implemented high availability for ICS
• Provided near to zero down time solution for end customer during Informatica cloud release upgrades like from R30 to R31, R31 to R32
• Worked on critical incident tickets when Informatica Cloud environment was down and proactively worked on Root cause analysis (RCA)
• I worked on Infrastructure setup for Public and Private Cloud Pod’s in Ford environment
• I have helped application teams on-time when they faced Cloud environmental port and firewall issues
• Worked on ICRT (Informatica real time console) issues in ICS and IICS
• Configured proxy.ini file in ICS and IICS
• Involved in on-boarding new applications for ICS
• Client coordination and gathering requirements from client and sharing with my Team
• Involved in Cloud migrations in all phases
• Involved in regular Domain and Service maintenance and restoring the services.

Confidential

Senior Informatica Administrator

Responsibilities:

• Performed end-to-end MDM upgrade from 9.7 to 10.1 on web logic environment
• I have installed and configured Informatica BDM and integrated with the Kerberos enabled Horton hadoop Frameworks
• Performed day to day MDM Administration and security audit activities.
• I did daily health checks on MDM and Web Logic applications.
• Performed code deployments from lower to higher environments
• Applied Hot Fixes (HF's) and Emergency Bug Fixes for MDM and for Power Center.
• Assisted developers in debugging issues for Informatica BDM
• Supported for EDC (enterprise data catalogue) regular activities for application teams
• I have upgraded Informatica Power Center and Metadata manager from 9.6.1, HF3 to 10.1.0 and from 10.1 to 10.2
• Experienced in Installation, Configuration, and Administration of Informatica Data Quality and Informatica Analyst
• Performed Various IDQ deployments by export and import and application deployments in DQ
• Created and Maintained Data Integration service DIS and deployed applications into IDQ
• Resolved Metadata manager major issues and identified bottleneck for issues when application team run MM lineages from MM GUI
• Working as lead for Metadata manager and Analyst tool also working on Data stage 8.5, 9.1, IDQ, MDM 10.1, IBM CDC, Optim and Hadoop admin support
• I did POC on Metadata manager tool and upgraded to version 10.1 successfully.
• I have configured and loaded successfully 220 database resources in MM including Oracle, Sybase, DB2, Sql server, Micro strategy and Paraccel
• Supported regular activities for Informatica MDM and for BDM teams
• Actively involved to resolve Performance issues in Metadata Manager tool when users tried to expand big data lineages
• I have applied multiple EBF's in Metadata Manager 10.1 and coordinated with Informatica vendor actively.
• I have integrated Analytix mapping manager (AMM) with IMM for Data Stage Analytics jobs to fetch data lineages into MM
• Involved in folders/objects migrations in all phases (DEV, INT, TEST, and PRD) of projects.
• Worked on Power exchange for CDC (IBM) on oracle 12c
• Resolved issues during data replication and provided support for Power exchange CDC (IBM)
• Worked on Power exchange 10.2 listener, logger, and publisher
• Supported for Power exchange application teams all the time
• Involved in regular Domain and Service maintenance and restoring the services.
• Resolved critical production/Test issues related to server performance, database issues and Session performance issues on a platform involving more than 80 applications.

Confidential

Team Lead

Responsibilities:

• Informatica software installation/upgrades and applying hot-fixes.
• Managing the Power Center Domain, Nodes, Service Manager.
• Performing Upgrading Informatica Power Center Version7 to 9.1, 8.x to Informatica Power Center Version 9.1
• Involved in Folders/objects migrations in all phases (DEV, INT, TEST, and PRD) of projects.
• Involved in regular Domain and Service maintenance and restoring the services.
• Deployed projects to production and troubleshot issues till they have gone live.
• Handled technical escalations and resolving the major incidents and performed root cause analysis.
• Involved in implementing rare tools like Data Validator option and PCPM in Informatica 9.1 version
• Handled all critical deployments successfully.