SUMMARY:

• Over 9+ years of experience in the field of Information Technology with good hands on experience with ETL Informatica administration.
• Expertise as Informatica Administrator to setup new Informatica environments and Upgrade existing Informatica environments to new versions.
• Expertise in installing, configuring and maintaining Informatica Power Center (8.x & 9.x) versions.
• Experience with creating Model Repository Service, Data Integration Service, Data Analyst and Search service.
• Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
• Good experience with change management, deploying code from DEV to TEST and PROD - using deployment groups in Informatica Repository manager.
• Excellent knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, Repository management and administration.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
• Pertinent experience using heterogeneous databases such as Oracle 9i/10g/11g, DB2/UDB, MS SQL Server 2012/2008, XML and various Flat File (Structured/Unstructured) systems for integration into Enterprise/Business Analysis DWH.
• In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
• Experience in writing shell scripting for various ETL needs.
• Proficient in applying performance tuning concepts to Informatica Mappings, Session properties, and database.
• Well exposed and worked closely with testing teams in performance unit testing, user acceptance testing and system integration testing.
• Proficient in applying performance tuning concepts to Informatica Mappings, Session properties, and database.
• Used Auto Sys for automatic job management, event driven scheduling and programmable error recovery.
• Support the Testers, Deployers and KT to the Team about the best Practices.
• Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Centre 9.0.1,9.5.1 & 9.6.1

RDBMS: Oracle11g,SQL,IBM DB2

Test Management Tools: ALM 11.52 & TCM

Bug Tracking Tools: ALM, Team track, Jira, Support Central and BMS Help Desk

Query Language: SQL

Servers: IIS, Tomcat and Web sphere

Others: WinScp, Time Sharing Option (TSO),excel macros

Input/output file system: 200 Bytes, ini, excel and txt

Web Technologies: XML, Web services

Configuration Mgmt Tools: Microsoft VSS 6.0, CVS, SharePoint and SVN

Operating Systems: Windows XP, 2003,UNIX,Mainframe

PROFESSIONAL EXPERIENCE:

Confidential - Madison, WI

Senior Informatica Administrator

Responsibilities:

• Provided 24/7 production support as a senior level Informatica Administrator
• Installed/Upgraded, maintained and provided DEV/Production support from infrastructure perspective for Informatica PowerCenter 10.0, PowerExchange 10.0, CDC implementation for SQL Server and Oracle, Informatica Cloud Services, Informatica Data Quality, Metadata Manager, Informatica Data Quality, Web Services and Active Batch implementation.
• Implemented Informatica cloud data integration with Amazon Redshift and S3.
• Supported production Implementations and migrations, Worked with Informatica vendor to get the root cause/fix on issues.
• Implemented automated scripts to monitor Informatica PowerCenter and PowerExchange Services, monitor disk spaces, cleanup & backup scripts in timely manner.
• Installed and managed, Voltage encryption tool, freetds, Paraccel, Python 2.7 to support various project needs.

Environment: Informatica Power Center 9.x/10.x, Power Exchange 9.x/10.x, Informatica Cloud Data Integration, SQL Server 2012, Oracle 12c, DB2 9/10, PL/SQL, Linux

Confidential - Philadelphia, PA

Senior Informatica Admin

Responsibilities:

• Building and Managing Informatica Shared Services Environments
• Installing Informatica Power Center 8.6.1 & 9.5.1 on Linux Servers and applying Patches/Hot fixes.
• Participating in BCP and DR Tests for the existing and newly build environments and creating DR documents to effective support in during a DR incident.
• Power Center 861 HF 13 environment setup for Prime Services.
• Creating and Configuring Power Center Domains, Nodes, Grids, Repository Services, Integration Services, Data Analyzer Services, Metadata Manger Services etc.
• Troubleshooting issues related to all Informatica environments.
• Creating SR to Informatica Corporation for any Informatica Product issues and queries.
• Setup and maintain ETL administration best practices and procedures
• Upgrade from 8.6.1 to 951 Informatica Version.
• Handled B2B Exchange administration.
• O.S Profile setup.
• Handled Multiple Outages in our environment and have coordinated the activities with various teams involved in the Outage.
• Configuring Oracle, SQL Server, MQ Series connectivity at Informatica level and UNIX Level
• Provided 24X7 On call Support during weekends
• Deploying Informatica Code from lower environments to higher environments, while strictly adhering to the Change Management Policies.
• Reluctantly involved in understanding the problem faced by the Informatica users and provided them optimal and on time solutions to address their issue.

Environment: Power Center 7.1.4/7.1.5/8.6/8.6.1/9.1, Power exchange, Oracle 9i R2/10g, OEM, Oracle 10g Grid Control, Tidal, Remedy, Toad, PL/SQL, SQL plus, Windows XP/NT, Windows server 2003/2008, Confidential UNIX.

Confidential - Louisville, KY

Senior Informatica Admin

Responsibilities:

• Design, implement, support and operating Data Integration Infrastructure.
• Worked on planning, design and implementing the standards, guidelines and best practices.
• Worked with various teams including DBAs, Production Office, Security Administration, Architects, Middleware Teams to setup and design the data integration environments.
• Extensively worked in design, configure and upgrade Informatica PowerCenter services - Repository Service, Integration Service and Web Service Hub, Data Quality services - Model Repository Service, Data Integration Service, Analyst Service, Content Management Service and Search Service along with Metadata Manager and act as a SME.
• Provided day to day on call support for ETL services.
• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• Responsible for day-to-day admin activities including creating/changing/managing folders, users, roles, groups, privileges, connection objects, promoting/rollback of deployment groups from development to QA and to production environment, code reviews, domain management tasks (including backup and restore), configuring DB connections, managing downtimes etc.
• Extensively worked on OS migration during the AIX to Linux migration of Data integration services.
• Doing POC’s for new functionalities being used for first time(IDQ, PMPC).
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.
• Configuration and management of application services, license service etc.
• Troubleshooting issues related to databases, job failures, software bugs and performance bottlenecks to all incidents working with multiple cross functional teams like DBA, Unix Server Administrator, Informatica Global Support and work on problems and drive them to resolutions.
• Worked with Informatica for software licenses, hotfixes, EBFs, patches, Informatica bugs, issues etc.
• Provided technical documentation as a part of support/upgrade/maintenance.

Environment: Informatica, winscp, Oracle 11g, Putty

Confidential

Informatica Admin

Responsibilities:

• Working on Informatica 8.x and Informatica 9.x versions.
• Working on Informatica and B2BExcahnge administration.
• Worked on the Informatica upgrade from Informatica 8.x to Informatica 9.x
• Maintaining 30 Inormatica servers DEV/SIT/UAT/TECHTEST/PROD/DR.
• Working on the Informatica Disaster Recovery test.
• Creating folders in Informatica.
• Work with Informatica support for critical issues.
• Creating SR with Informatica.
• Release management.
• Migrating code to different environments.
• Working on aix, solaris, linux servers.
• Creating NSR for DB activity.
• Support installation and maintenance of new PowerCenter features

Environment: Power Center 7.1.4/7.1.5/8.6/8.6.1/9.1, Power exchange for CDC, Informatica IDQ, Oracle 9i R2/10g, OEM, Oracle 10g Grid Control, Tidal, Remedy, Toad, PL/SQL, SQL plus, Windows XP/NT, Windows server 2003/2008, Confidential UNIX..