OBJECTIVE

• Seeking assignments for application administration and issue analysis in Informatica PowerCenter, Informatica Information Lifecycle Management and related application where my abilities and experiences can add value.

SUMMARY

• 4.5 years of experience in Installation/Administration/Issue - Analysis/Maintenance with Informatica PowerCenter.
• Experienced in working in dedicated Admin teams and individual contributor roles which require complete analysis with respect to ongoing project for next level upgrade.
• Good leadership skills developed through work experience.
• Proactively working on POC related to tools new functionality.
• Partially involve in ETL development activities.
• Informatica and Informatica ILM, DVO, IDQ Administration.
• Responsible for Installation & configuration of Informatica PowerCenter 9.1 (Client, Repository Service & Integration Service) on UNIX machine.
• Joining additional node in existing system for better performance,
• Analyzing newly added functionality with extensive effort and sharing POC experience/document with development/Production support.
• Performed Informatica upgrade from v9.1.0 - 10.1HF2. Patch installation, EBF (Emergency Bug Fix) Installation, applying patches for temporary fix and validation.
• Configured Master gateway Node and worker nodes under High Availability environment.
• Enabling spy log, heap log for detailed analysis of issue,
• In case of any product related issues, work with Informatica support.
• Repository Service Backup, Recovery and Migration between Dev, UAT and Prod environments.
• Validation of directory mount point and running cleanup script for cleaning old catch/log.
• Observing CPU utilization on daily basis by using UNIX commands and generating nmon report.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, Custom roles and assigned them to user group.
• Ensure that all support requests are properly approved, documented.
• Documenting common issues and resolution procedures.
• Hands on knowledge on MDM(Master Data Management).
• Hands on experience in installation/configuration of DVO (Data Validation Option) v9.1 - 10.0 and ILM v6.1.1 - 6.4 HF2, Data Visualization reports, JReport.
• Load balancing based on job health and configuring agent, data vault, ILM.
• Hands on experience on Application retirement using ILM, Querying data vault using SQL worksheet and putty.
• Report Designing based on project requirement using JReport v11 - 13.
• An effective team player with exceptional planning and execution skills coupled with a systematic approach and quick adaptability.
• Adoption of New functionality of application and tools.

TECHNICAL SKILLS

Primary Skills: Administration in Informatica PowerCenter and ILM, DVO, IDQ, Trained on DDM(Dynamic Data Masking)Databases: Oracle, Data vault, MS SQLServer

Reporting Tools: JReport Designer

Dependency Database Tools: SQL Developer, Toad

OS Platform: Linux, AIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

• Installation and configuration of Informatica Power Center 10.1 and other related products.
• Managing the DEV/QA/UAT/PROD environments with High Availability and GRID setup
• Worked closely with Informatica support team on ongoing issue and provide required information to find the root cause.
• Support development teams with performance issues and troubleshooting to find the root cause
• Handle day to day Informatica object migration tasks
• Scheduling and Monitoring Informatica repository backups
• Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed
• Root Cause analysis for ETL job failures/Data issues raised by business
• End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup
• Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.
• Hands on experience in installation/configuration of DVO (Data Validation Option) v9.1 - 10.0 and ILM v6.1.1 - 6.4 HF2, Data Visualization reports, JReport.

Confidential

Programmer Analyst

Responsibilities:

• Installation and configuration of Informatica Power Center and other related products.
• Managing the DEV/QA/UAT/PROD environments with High Availability and GRID setup
• Worked closely with Informatica support team on ongoing issue and provide required information to find the root cause.
• Support development teams with performance issues and troubleshooting to find the root cause
• Handle day to day Informatica object migration tasks
• Scheduling and Monitoring Informatica repository backups
• Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed
• Root Cause analysis for ETL job failures/Data issues raised by business
• End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup
• Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.

Confidential

System Analyst

Responsibilities:

• Monitoring Dev/QA/MAINT/MAINTREG/Production
• User creation and access approval for reports.
• Installation/upgrade/EBF/Patch/
• Data vault migration using SSADBCOPY.
• JReport report/ EDM xml migration based on Dev team request.
• Maintenance activities/ Production code changes during weekend.
• DVO/PowerCenter installation/ upgrade.
• Used DVO to validate Data vault DB using JDBC connection.

Confidential

System Analyst

Responsibilities:

• Installation and configuration of ILM 6.2 server
• Installation and Configuration of Data Validation Option (DVO) tool
• Installation and setup of ILM File Archival server
• Worked on proof of concepts for Archival of Siebel Sample Database into ILM Data Vaults
• Proof of Concepts on JReport Designs and Data Visualization Reports

Confidential

Informatica Admin

Responsibilities:

• Installation and configuration of Informatica Power Center and other related products.
• Managing the DEV/QA/UAT/PROD environments with High Availability and GRID setup
• Worked closely with Informatica support team on ongoing issue and provide required information to find the root cause.
• Support development teams with performance tuning and troubleshooting issues
• Handle day to day Informatica components migration tasks
• Scheduling and Monitoring Informatica repository backups
• Working with DBA, Network and UNIX team to resolve the ongoing issue.