SUMMARY

• 13+years of IT experience in INFORMATICA with full ETL life cycle implementations including analysis, design, development, testing, deployment, post - production support/maintenance and documentation.
• Comprehensive industry experience. Have worked in Telecommunications, Banking and Insurance, Health Care and Retail industries.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica PowerCenter suit on various versions like 6.x, 7.x, 8.x, 9.x and 10.1 (latest version)
• Experienced in Installing and configuring Repository Service, Metadata Manager Service, Data Analyzer and Web Service Hub with High Available (HA) & Grid option enabled.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica MDM on various versions like 9.x, 9.7 and 10.2 (latest version) & trouble shooting performance issues and supporting activities on both WebLogic and JBoss app servers.
• Experienced in creating and registering ORS's for MDM.
• Experienced in creating and configuring Address Doctor, Identity Match reference data components for MDM Hub & Cleanse Server(s).
• Experienced in integrating Informatica MDM with Informatica PowerCenter IDQ.
• Experienced in ORS's & Cleanse Server upgrade and code deployments to a higher environment.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica B2B Components.
• Experienced in Installing & Configuring Proactive monitoring PMPC, RTAM and PMR.
• Experienced in Installing & Configuring Data Validation Option (DVO).
• Experienced in upgrading Informatica PowerCenter across different versions like 8.1 to 8.5, 8.6 to 9.x, 9.x to 9.6 and 8.6 to 9.6 & 10.1 with latest Hot fix etc.,
• Experienced in Installing & Configuring Informatica Cloud Secure Agent& trouble shooting and support.
• Experienced in Installing & Configuring Informatica Lifecycle Management(ILM /TDM)& trouble shooting and support.
• Day to day Informatica environment maintenance and support activities.
• Excellent implementation of data warehouse/data marts using various data warehouse concepts and principles like Change Data Capture, Slowly Changing Dimensions, Normalization/De-normalization (Star and snow-flake Schema Modeling).
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2 and 3 to keep track of historical data.
• Developed Data Warehouse/Data Mart systems, using various RDBMS (Oracle, MS SQL Server, Mainframe file, Teradata and DB2).
• Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for Data Warehousing and Data Migration, Data Synchronization projects using Informatica Power Center including Designer, Developer Repository Manager, Workflow Manager, Workflow Monitorand Administration Console etc.,
• Profound Experience in Project Environment setup such as Installation,configuration and Administration of Informatica products Client/Server environment.
• Experience in data management activities like data integration, data migration and data Synchronization using heterogeneous source like Oracle/ Exadata 9i/10g/11g/12c, DB2, Flat Files, XML Files, Netezza, Teradata, MS SQL Server 2012/2008/2005 and MS Access 2007/2003.
• Developed Complex mappings from varied transformation logics like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Involved in Informatica ETL Performancetuning, testing and troubleshooting w.r.t Mappings, Sessions and Workflows.
• Experience in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings and Shortcuts.
• Experience using Informatica Power Exchange (Power Connect) for SAP to pull data from SAP R/3.
• Experience using Informatica Change Data Capture (CDC) functionality to pull the real time data.
• Experience in UNIX shell scripting, Pre-Session, Post-Session UNIX Commands for automation of Informatica job scheduling, backup of repository etc.,
• Experience in exporting and importing (loading) data to/from heterogeneous source systems using Teradata utilities such as BTEQ, Fast Export, Fast Load and Multi Load.
• Extensively worked with SFTP/SSH file transfer and loading using SQL, PL/SQL, SQL *Loader.
• Experience in using the Informatica command line utilities like pmcmd, pmrepserver, infacmd, infasetup and pmrepagent to execute or control sessions, tasks, workflows and deployment of groups in non-windows environments.
• Experienced in different Project Management Methodologies like Traditional water fall and Agile.
• Proactive in learning new technologies and updating my skills including Strong analytical, verbal, written and interpersonal skills.
• Proven team player with excellent communication and interpersonal skills for meeting the deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1, 9.6, 9.1.0,9.0.1, 8.6.1,8.5.1,8.1.1,7.1.x, Power Exchange, IDQ, IDE-(B2B), MDM 10.2, 9.7.1, ILM /TDM Proactive Monitoring, RTAM, Data Validation Option(DVO) and Informatica Cloud

Databases: Exadata Oracle 12c, 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , Teradata, DB2 and MS Access

Operating systems: Windows 7/XP/ 2003/2000/2008/2012 RT/NT, UNIX-SOLARIS, LINUX and AIX

Language: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Scheduling Tools: Tivoli Maestro, $Universe, Autosys and UC4

OLAP/BI Tools: Business Objects XI / 6.5 and Crystal Reports 8 / Cognos.

Web Technologies: XML, WebLogic

Other Tools: Teradata SQL Assistant, TOAD, Apex Explorer For Salesforce Queries(SOQL), Oracle Goldengate, Win SCP, ERwin 4.x/3.x, MS Office, MS Visio and MS VSS

BIG DATA: Informatica BDE / Hadoop Administration

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr.Informatica MDM Admin

Responsibilities:

• Installed, Configured and Upgraded Informatica PowerCenter 9.6.X to 10.1 with latest Hot Fix.
• Installed, Configured and Upgraded Informatica PowerCenter TDM /ILM to 10.1 with all EBF’s.
• Installed and re-configured and upgraded Informatica PowerCenter suite (like IPC, ILM, TDM, IDEand IDQ) on a multi flavored environment (heterogeneous environment) as part of the upgrade process.
• Installed, configured & Upgraded Master Data Management 9.7.1 (MDM) to 10.1 with latest Hot Fix on WebLogic Application Server on Linux and Windows environments.
• Informatica MDM Code Deployments and environment tuning.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud environments.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed/ Migrated MDM, IDQ & DT Service code to higher environments to till Production & DR.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copyand Export& Import etc.,
• Trouble shooting of Web Services & SAP BW services and WebLogic Server on MDM side.
• Backup & Restore activities including but not limited to Disaster Recovery (DR) activities.
• Daily, Weekly & Monthly etc., Maintenance activities w.r.t Informatica PowerCenter & MDM Environment(s).
• Trouble shooting and supporting Informatica PowerCenter, IDQ, PWX, ILM and MDM Environments.
• Taking help from Informatica vender(GCS) support as we needed.

Confidential, Hoboken, NJ

Sr. Informatica Admin Marshmc Informatica Upgrade

Responsibilities:

• Installing and Upgrading Informatica PowerCenter from 8.6 HF6 to 9.6 with HF3.
• Installed and configured Informatica PowerCenter suite (like IPC, PWX, TDM, IDE and IDQ) on a multi flavored environment (heterogeneous environment). Like Linux and Windows.
• Installed and configured Proactive monitoring PMPC, RTAM and PMR.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed MDM, IDQ & DT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy and Export& Import.
• Trouble shooting of Web Services & SAP BW services.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter Environment.
• Trouble shooting and supporting Informatica PowerCenter Environment.
• Taking help from Informatica vender support as we needed.

Confidential, Quincy, MA

Sr.Informatica MDM Admin

Responsibilities:

• Installed and Configured Informatica PowerCenter 9.6.X.
• Installed and Configured Informatica PowerCenter TDM /ILM.
• Installed and configured Informatica PowerCenter suite (like IPC, ILM, TDM, IDEand IDQ) on a multi flavored environment (heterogeneous environment).
• Installed and configured Master Data Management 9.7.1 (MDM) on WebLogic.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed MDM, IDQ & DT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy and Export & Import.
• Trouble shooting of Web Services & SAP BW services.
• Backup & Restore activities including but not limited to DR activities.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter & MDM Environment(s).
• Trouble shooting and supporting Informatica PowerCenter & MDM Environment(s).
• Taking help from Informatica vender (GCS)support as we needed.

Confidential, Springfield, MA

Sr.Informatica Admin

Responsibilities:

• Multi Domain & Multi Node HA Informatica Environment support and maintenance.
• Installed and configured Informatica PowerCenter suite (like IPC, IDE, IDQ & MDM) on a multi flavored environment (heterogeneous environment).
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's).
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• DeployingDT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy, Export & Import.
• Added new nodes to the existing domains.
• Security implementation w.r.t. LDAP & Native authentication.
• Users and User Group access management.
• Creating and managing Application services.
• Creating and Managing Global Objects & its access.
• Trouble shooting of Web Services & SAP BW services.
• Day to day backup and restore repository & Domain activities.
• Configuring & Testing Disaster Recovery (DR) w.r.t PROD Environment.
• Installing, Configuring & Trouble shooting Informatica Cloud Secure Agent.
• Installing, Configuring & Trouble shooting Informatica PMPC, RTAM & PMR.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter Environment.
• Trouble shooting and supporting Informatica PowerCenter Environment.
• Taking help from Informatica vender support as we needed.