SUMMARY

• 16+ years of professional experience with expertise in Design, Development, Data Conversion and Implementation of Data warehouse applications and Database business systems
• Extensive experience with Data extraction, Transformation and Loading(ETL) from data sources relational databases like Oracle, SQL Server..etc to Targets(Relational/Flatfiles…etc)
• Successfully delivered upgrade Projects for OS/Informatica/Cognos/Monitoring Applications successfully delivered migration projects from Informatica to Databricks
• Handlingprojectsolution delivery by coordinating with customer, partner, and internal team to assure successful implementations
• Strong Experience in Informatica, IDQ/MDM/DIH/IICS/B2B/BDM/EDC/AXON and Snaplogic
• Delivered successfully MDM Upgrade Projects with Application Server as WebSphere,Weblogic and JBoss
• Strong Experience in Informatica HA Setup (Power Center,IDQ,MDM,IICS,BDM,EDC and AXON)
• Strong Experience in Informatica B2B (DX,VL Proxy,TIBCO for HIPPA Validation)
• Having strong Experience in Onsite offshore Model
• 13+ years of ETL experience using Informatica Power Center 10.x/9.x/8.x/7.x Expert level skills in developing strategies for extraction, transformation and loading mechanism
• 10+ Years of experience in Informatica Development (Power Center,IDQ,MDM)
• 14+ years of experience in INFORMATICA AND COGNOS ARCHITECT/ ADMINISTRATOR/DEVELOPER.
• 5+ years of experience in Informatica IDQ,TDM and B2B
• 2+ years of experience in Informatica EDC/AXON
• 4+ years of experience in Cognos and Control - M Administration
• Having Knowledge on SAP-BIW,iWAY ETL tool.
• 1+ Yr of experience in TM ART and ITCAM Monitoring Setup/Support
• Strong experience in installation of informatica products in UNIX, Migration of repositories, up gradation of repositories.
• Strong experience in entire life cycle of Data warehouse/Data mart using Informatica tools
• Experience with relational and dimensional models using Facts and Dimensions tables.
• Strong experience in Business Intelligence tools.

TECHNICAL SKILLS

Industry Skills: Banking, Pharmaceutical, Retail, Healthcare and Insurance

ETL’s & Utilities: Informatica Power Center,Cognos,Tableau,Alteryx,Informatica MDM,Informatica IDQ,TDM,Snaplogic,iWay Data Migrator, Tidal, Peregrine Service Center,Spark,Databricks

Language: C

Database: Oracle 12c/11g/10g/9i/8i,DB2UDB 9.7 and SQL Server 2008/2012

Operating Systems: UNIX (Sun Solaris, AIX, HPUX), Linux,Windows NT/ 2000/2008/2012

Tools: Peregrine Service center5.1,MQC, Clearquest, and Clearcase, TOAD, Putty, SQL Developer,Tidal,Power Center Designer,Repository Manager,Workflow Manager,Workflow Monitor,Power Center Visio,Edit Plus, Control M,TM ART and ITCAM

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Administrator

Environment: Informatica IDQ/MDM/DIH/B2B/BDM/EDC/AXON/IICS, Informatica Cloud, AWS,RDS,Cognos, WebSphere,Control-M,Linux

Responsibilities:

• Working as Sr Informatica Administrator
• Handlingprojectsolution delivery by coordinating with customer, partner, and internal team to assure successful implementations on Informatica Products (Power Center,IDQ,MDM, BDM/IICS/EDC and AXON)
• Conduct internal and customer interacting Weeklyprojectcalls
• Handling the DI Platform Team on DI Technical Architecture decisions, Development and Administration(Power center,IDQ,MDM,BDM, Informatica Cloud,EDC and AXON)
• Successfully Upgrade Informatica,IDQ and MDM to 10.4.1
• Worked on IICS Application Integration components like Processes, Service Connectors and process object.
• Working with Informatica MDM (Stage Load, Load, Match and Merge)
• Working with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Supported the Informatica Development team on issues and provide the technical solutions in Power Center/IDQ/MDM/Informatica Cloud/BDM
• Provide solutions on Install/Informatica Upgrade issues/Development support as needed for Informatica(PC/IDQ/MDM,BDM,IICS,EDC and AXON)
• Extensively worked on Automation of the upgrade Projects with various tools
• Implemented CI/CD framework in Informatica

Confidential

Informatica Administrator

Environment: Informatica 9.x/10.x/IDQ/MDM/DIH, Informatica Cloud, AWS,RDS,Redshift,, Spark,Databricks,Airflow,,Linux,AWS,Oracle,Snaplogic,Weblogic

Responsibilities:

• Working as BI Architect
• Handlingprojectsolution delivery by coordinating with customer, partner, and internal team to assure successful implementations on Informatica Products (Power Center,IDQ,MDM,DIH,Snaplogic and Informatica Cloud)
• Upgraded Informatica,IDQ,MDM and DIH Servers to 10.2.2 HF2
• Conduct internal and customer interacting Weeklyprojectcalls
• Handling the DI Platform Team on DI Technical Architecture decisions, Development and issues(Power center,IDQ,MDM,DIH, Informatica Cloud and Snaplogic)
• Supported Airflow Servers,Databricks and Redshift.
• Worked on IICS Application Integration components like Processes, Service Connectors and process object.
• Working with Informatica MDM (Stage Load, Load, Match and Merge)
• Working with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Supported the Informatica Development team on issues and provide the technical solutions in Power Center/IDQ/MDM/Informatica Cloud/Snaplogic
• Provided solution on AWS Redshift/S3 Integration/Anaplan with Informatica Servers(on-premise and cloud integration) and Snaplogic
• Developed custom mappings in Informatica to validate Redshift/S3 Connections with Power Center
• Implemented Informatica/Snaplogic Upgrade/Best Practice on Informatica Upgrade.
• Provide solutions on Informatica Upgrade issues/Development support as needed for Informatica/Snaplogic Upgrade issues

Confidential

Informatica/Cognos/Monitoring Administrator

Environment: Informatica 8.x/9.x/TDM/Power Exchange /IDQ, Cognos 8.x/10.x,TMart,ITCAM, Linux,AIX,Control-M,MoveITCentral, WebSphere,Informatica B2B

Responsibilities:

• Worked as a Team Architect/Informatica/Cognos Administrator/Developer/Monitoring Specialist
• Design the system/resource requirement for Informatica and Cognos to run in the enterprise Environments(Dash boards, Score cards, Report Studio)
• Installed Informatica 8.1.1, 8.5.1,8.6, 9.0.1,9.1.0,9.5.1,9.6.1 and 10.1
• Install and configure Informatica TDM
• Installed Cognos 8.2,8.4,8.4.1,10.1.1 and Cognos 10.2
• Installed control-M servers and agents
• Upgraded Informatica 8.1.1 to Informatica 8.5.1 and 8.6.1,9.0.1,9.1.0 HF4,9.5.1,9.6.1 and 10.1
• Upgraded Cognos server from 8.2 to 8.4.1 and 8.4.1 to 10.1.1 and 10.1.1 to 10.2
• Involved in design the SSO Integration for Cognos reports with WebSphere and Batch job execution scripts.
• Installed and Configured Informatica B2B(DX,VP Proxy,TIBCO for HIPPA Validation)
• Hands on experience working on Analyst tool to create Rules, Scorecards, Reference tables and data profiling.
• Installed and Configured the ITCAM and TMart Monitoring for Enterprise Servers
• Working with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Applied Informatica Patches to the Informatica servers
• Developed complex mappings in Informatica to support for Health Care Enterprise application
• Developed complex scripts for the follow the Business requirements
• Troubleshooting the issues in Informatica
• Migrating the cognos reports from one environment to another environment
• Troubleshooting the issues in cognos reports
• Involved and resolving the issues (Tickets) in Informatica Power center.

Confidential

Informatica Administrator/Test Lead/On-site Coordinator)

Environment: Informatica Power Center 7.1.4, Tivoli, SQL Server 2003, XML, PL/SQL, SQL*Plus OAD 8.5, Windows XP, AIX.

Responsibilities:

• Worked as a Team Lead/Informatica Administrator
• 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 Power center.

Confidential

Informatica Administrator

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

Responsibilities:

• Working as Informatica Administrator.
• 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 Confidential .
• Involved and resolving the issues (Tickets) in Informatica Power center.
• Giving L2/L3 Support for all applications in Confidential .
• Giving 24/7 Production Support for all application.