SUMMARY

• 11+ years of professional experience with expertise in Design, Development, Data Conversion and Implementation of Data warehouse applications and Database business systems.
• Playing a role as Senior Informatica Consultant
• Having strong Experience in Onsite offshore Model
• 10+ years of ETL experience using Informatica PowerCenter 10.x/9.x/8.x/7.x Expert level skills in developing strategies for extraction, transformation and loading mechanism Architect
• Strong Experience in Onshore and offshore model
• Played as a technical Lead on onshore and offshore Model
• 3+ Years of experience in Informatica Development
• 10+ years of experience in Informatica Administrator (Power Center, PWX, MM, DDM)
• 4+ years of experience in Informatica MDM,IDQ,IICS
• Strong experience in installation of informatica on UNIX and Linux, Migration of repositories, up gradation of repositories.
• Experience in creating Informatica services monitoring scripts, automation scripts to start informatica services and scripts for Automation Informatica deployment and automated repository backups
• Strong experience in the entire life cycle of Data warehouse/Data mart using Informatica Power Centre (Designer, Repository manager, Workflow manager and Workflow monitor).
• Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions.
• Experience with relational and dimensional models using Facts and Dimensions tables.
• Strong experience in database applications such as Oracle, TOAD, SQL, PL/SQL, Functions, Procedures, Triggers, Cursors, SQL*Plus and Control - m, CWA.
• Strong experience in Business Intelligence tools.
• Versatile team player with excellent analytical, communication and presentation skills.

TECHNICAL SKILLS

ETL tools: Informatica PowerCenter 10.x/9.x/8.x/7.x, Power Exchange, Metadata Manager, Dynamic Data Masking,MDM,IDQ,IICS

Database and related tools: Oracle 18c/12c, MS SQL Server, SyBase, MySQL, PostGress, MS Access, PL/SQL, TOAD

BI and Scheduler tools: BO, TWA

Programming: SQL, PL/SQL, SQL*Plus, UNIX shell scripting

Operating Systems: HP Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

Informatica Consultant (MDM/IDQ/PC)

Responsibilities:

• Working as Informatica Consultant.
• Up-grade Informatica Services from 9.1.0 to 9.5, 9.5 to 10.1.0 and 10.1.0 to 10.4
• Installed Informatica 9.1.0, 9.5,10.1.0,10.2.1 and 10.4
• Install and Configure the Secure Agents for IICS
• Configure the High Available Secure Agents for IICS Jobs to run in cluster AWS Servers
• IICS Deploy the code across the organizations (DEV,TEST and PROD)
• Implemented Security access/SSO for IICS
• Install and configure the Informatica MDM/ActiveVOS
• Installed and upgrade Informatica MDM 9.x/10.x (Hub Server and Cleanse Server)
• Installed and upgrade IDQ
• Working with PC,Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ and also working in Informatica MDM (Stage Load, Load, Match and Merge)
• Implemented MDM Batch execution via Command line
• Managing Informatica DEV, QA, UAT and PROD environments
• Installed and configure the Pro-Active Monitoring for Informatica
• Installed and setup Metadata manager 10.1.0 and upgraded to 10.2 and 10.4
• Installed and setup Power Exchange and upgraded from 10.1 to 10.4
• Installed Informatica Dynamic Data Masking 9.8.2 and upgraded to 9.9
• Installed Data flux and migrated from Unix to Linux
• Migrating Informatica code form QA-UAT and UAT-PROD
• Configured PowerCenter to various database connections (MYSQL, SYBASE, POSTGRES, Salesforce)
• Designed, developed, and tested the Simple Mappings, Sessions and Workflows
• Created Informatica services monitoring scripts, automation scripts to start informatica services and scripts for Automation Informatica deployment and automated repository backups
• Applied Informatica Patches/Hotfix to the Informatica services
• Migrated Informatica from Unix to Linux
• Worked on code page changes to fix special character issues
• Troubleshooting the issues in Informatica
• Involved and resolving the issues (Tickets) in Informatica PowerCenter, Metadata Manager, Data flux, Dynamic Data Masking and File pro jobs
• Involved in the performance tuning
• Creation of folders/user permissions
• Implementing the standards in the release basis
• Support Non-PROD and PROD DW loads and support around 1500 ETL jobs
• Giving 24/7 Production Support.

Environment: Informatica PowerCenter 10.x/9.x/8.x, Metadata Manager 10.X, MDM 10.x,IDQ 9.x/10.x,IICS,Data flux, Dynamic Data masking 9.x, Oracle 19c/18c/12c/11g, SQL*Plus, TOAD 8.5, Windows XP, HP Unix, CWA.

Confidential

Informatica Administrator/Developer

Responsibilities:

• Up-grade Informatica Services from 8.6.0 to 9.5
• Installed Informatica 8.6, 9.1.0 and 9.5
• Upgraded Informatica services 8.6.,9.1 and 9.5
• Designed, developed, and tested the Simple Mappings, Sessions and Workflows
• Interacted with management/SME to gather/Understand their requirements
• Applied Informatica Patches/HotFix to the Informatica services
• Troubleshooting the issues in Informatica
• Involved and resolving the issues (Tickets) in Informatica PowerCenter
• Involved in the performance tuning
• Creation of folders/user permissions
• Implementing the standards in the release basis
• Giving L2/L3 Support.
• Giving 24/7 Production Support.

Environment: Informatica PowerCenter 9.x/8.x,Oracle 11g, SQL*Plus, TOAD 8.5, Windows XP, Red Hat Linux 5.3.

Confidential

Informatica Administrator/ Test Lead

Responsibilities:

• We are testing the informatica code according to the new releases
• We are handling 3 test environments for testing the code in parallel.
• Transformed data from source system to target.
• Writing the queries on metadata level to figure it out the standards
• Implementing the standards in the release basis.
• Migration of objects from Dev-SIT, SIT - PPE and PPE - PROD
• Handling the issues in the informatica level
• Creation of folders/user permissions.
• Handling other informatica administration activities
• Upgrading the Informatica Repositories from 6.x to 7.x.
• Giving L2/L3 Support for all applications.
• Giving 24/7 Production Support for all application.
• Involved and resolving the issues (Tickets) in Informatica PowerCenter.

Environment: Informatica PowerCenter 7.1.4, Tivoli, SQL Server 2003, XML, PL/SQL, SQL*Plus, TOAD 8.5, Windows XP, AIX.

Confidential

Informatica Administrator

Responsibilities:

• Playing a role as Technical lead.
• Installing and configuration of Informatica 7.x on UNIX.
• Having Experience in Allocation of space on Sun Solaris server for various operations to the ETL
• Migration of informatica Repositories (DEV-UAT, UAT-Prod).
• Upgrading the Informatica Repositories from 6.x to 7.x.
• Given the informatica supporting for all the applications in Credit-Suisse.
• Involved and resolving the issues (Tickets) in Informatica PowerCenter.
• Giving L2/L3 Support for all applications in Credit-Suisse.

Environment: Informatica 7.x/6.x, UNIX (Sun Solaris), Oracle 10g