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 Availability (HA) installation and configuration on AWS and F5 & Grid option enabled.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica MDM Hub/Process Server /Active VOS /and IDD on various versions like 9.x, 9.7 and 10.2 (latest version).
• Experienced in creating, configuring and registering(Administering) system & Operational ORS's for MDM Hub & Cleanse Server(s) /Process Server(s).
• Experienced in Installing, Configuring, Upgrading and Administering WebLogic & JBoss app servers.
• Performed Extensive Performance tuning on JVM with respect to WebLogic & JBoss and MDM application.
• Experienced in complete end-to-end MDM upgrade from 9.x to9.7 and 10.2 (latest version).
• Experienced in installing & configuring Address Doctor Engine-reference Data on MDM / IDQ/IPC.
• Experienced in creating and configuring Identity Match, Informatica Data Director and other reference data components for Trillium Data Director on MDM Hub & Cleanse Server(s) /Process Server(s).
• Experienced in creating and configuring Java User exits.
• Trouble shooting performance issues and supporting activities on both WebLogic and JBoss app servers.
• Trouble shooting on JAVA & User exits and SIF services and also tuned match/merge process.
• Performed day to day Administration and security audit activities.
• Performed daily health checks on MDM / WebLogic / JBoss applications.
• Performed code deployments to/from higher environments and may more...
• 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, Crontab and UC4

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

Web Technologies: XML, WebLogic, JBoss, Amazon AWS and F5

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 ATLAS Program

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 CMW Reporting System

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 MMe-DW Reporting

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.

Confidential

Informatica Admin Sunrise DSR Reporting

Responsibilities:

• Environment setup by Installation and configuration of Informatica suite (IPC, IDE, IDQ & MDM).
• Implemented Hot fixes and EBF’s on top of Informatica Up-gradation.
• Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.
• Installed and configured the Data Quality application services w.r.t 8.6 and v9.
• Installed and configured the content including out-of-the-box and address validation files w.r.t IDQ.
• Implemented the Data Director Service for Data quality.
• Adding new users and providing the required roles and privileges Using Admin Console.
• Created and Managed OS profiles w.r.t IPC suite.
• LADP authentication and configuration.
• Created and configured the Reporting and Dashboards service for Data Quality application.
• Creating and managing connections and providing the required access levels Using Repository Manager.
• Regular Monitoring and troubleshooting the Informatica domain.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Regular health checkups w.r.t Domain, Node and application services as well as space related activities.
• Provided E2E support for Informatica Environment.
• Initially Implemented full proof of concept (POC) as part of Informatica Up-gradation 8.5 to v9.
• Managed the Informatica Logs and space related issues.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through Tivoli Maestro Job scheduler using UNIX scripts.
• Played a key role in all the ETL phases and responsible for production support as well.
• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Worked on Informatica 9.0.1/8.6.1 in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volumes of data as part of performance tuning.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Developed workflow tasks like Email, Event wait, Event Raise, Timer, Command and Decision.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL, PERL scripts to automate the process.
• Created UNIX Shell scripts and called as pre session and post session commands.

Environment: Informatica PowerCenter 9.0.1/8.6.1 /8.5, Power Exchange, Oracle10g, Teradata, TOAD 10.1 for Oracle, Oracle Goldengate, DB2, Flat Files, PL/SQL, SAP R3, ERWIN 4.x Data Modeling tool, Windows XP SP3, SunOS, UNIX PERL scripting and Tivoli Maestro.