We provide IT Staff Augmentation Services!

Senior Informatica Administrator Resume

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

Senior Informatica Administrator

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.

Hire Now