SUMMARY

• Over 10+ years of experience in ETL technologies with specialization on Informatica PowerCenter & Data Quality (IDQ), Informatica Big Data Management (BDM), Informatica Data Engineering Integration (DEI), Informatica Cloud (IICS) administration, Informatica Master Data Management (MDM) and Informatica Enterprise Data Catalog (EDC) on multiple platforms including RedHat/Oracle Linux, Windows, and AWS environments
• Extensive experience on Informatica PowerCenter 10.x/ 9.6.1/9.1/8.6.1/8.6/7.1. x/6.2.x/6.x/5.x, Informatica Data Quality (IDQ) 10.2 HF 2/10.1/9.6.1 , Informatica Enterprise Data Catalog (EDC) 10.4.x/10.5 SP1 Enterprise level Architectural Designing, System Configuration, Installation, Administration on RedHat Linux, Windows, AWS & Azure
• Migrate the On - Premises Informatica PowerCenter and DEI applications to AWS cloud
• Install, configure, and upgrade the Informatica MDM using WebSphere and Jboss as Application server
• Extensive experience on Informatica Enterprise Data Catalog (EDC) 10.4.x/10.5.x installation, configuration, and Administration on RedHat Linux
• Upgrade Informatica Enterprise Data Catalog (EDC) 10.4.1 to 10.5 SP1 and 10.5.1
• Extensive Experience on Informatica Intelligent Cloud Services (IICS), Secure Agent, Installation and Configuration & Administration, Security Management, Code Migrations on AWS Cloud, Linux, and Windows
• Extensive Experience on design, Build, Manage Informatica Domain & Application Services in a Multi Node, High Availability (HA) and Server Grid Configuration to avoid single point of failure for Informatica Services
• Informatica Domain Security Configuration & Administration (Users, Groups, Roles), Account Management, OS Profiles, Audit Reporting and Repository Folder, Object and Connection Security
• Informatica Upgrades, Hotfix Upgrades, Patch installation (EBFs/Service Pack) in a cross-platform environments to support Applications, Infrastructure and Vendor support requirements and to assure security and compliance requirements
• Active Directory (AD) Authentication and LDAP Configuration, Setup SSL certificates to Manage Informatica Security
• Informatica Domain & Node Management, Domain Folder Management, Security Administration, Log Management, Service Management and Domain Reports, Automatic Domain Backups and Restarts
• Migration (Deployment/Rollback, Export/Import) of Objects from lower environment to production
• Repository Folder Management, Object Management, Relational & FTP Connections and across multiple environments
• Domain & Repository Backups, Automatic Shutdown & Restart of Domain, Node, PC Repository, Integration, Model Repository, Data Integration, Analyst Services
• Maintain Disaster Recovery (DR/BCP) Plans, Coordinate Execution activities related to platform maintenance, Disaster Recovery (DR/BCP) and Software release management
• Extensive Experience on Version Controlled Process, Change Management, Release Management & Outage handling procedures
• Informatica System Level Monitoring and Alerting, Capacity Planning (CPU, Memory, Loads (sessions), I/O, etc.). using Monitoring tools to proactively increase System Capacity as needed
• Performance diagnosis/improvement for ETL processes, Co-ordinate & support environment for Infrastructure changes related to UNIX, Windows, Storage, Network, Middleware
• Monitor, Troubleshoot, Debug and Fix Failures & Performance issues. Log file analysis for Domain, Service and User Activity. Manage Log Aggregator to collect, debug Domain and Node information, Hang & Crash analysis of services and collaborate with vendor in analysis of log files
• Work & coordinate with various on-site/off-shore APP & Infrastructure teams on various Infrastructure and Development teams support activities during new app releases, scheduled/monthly maintenance activities
• Training on New features of Informatica & Advanced Techniques, best practices for various Business groups and users
• L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis. Experience in Task Allocations & Project Delivery
• Provide 24 x 7 on-call rotation for Infrastructure Administrative and Production issue analysis & resolution

TECHNICAL SKILLS

Data Integration Tools: Informatica PowerCenter 10.4/10.2/10.1/10.1.1/10.1.1. HF1, 9.6.1/9.5.1/9.1 PC Repository, Integration Service, Web Services Hub, High Availability (HA), Grid, Data Analyzer, LDAP. Data Quality 10.2 HF2/10.2 HF 1/10.1/9.6.1 , 9.5.1 HF4, 10.1 Model Repository, Data Integration, Content Management, Analyst, Search, Profiling, Scorecard, Address Doctor, Identity Match, Accelerator, Data Domain Content & Rules, Excel 1.2, LDAP. BDM/BDQ 10.2.x, EDC 10.2/10.4.1/10.5 SP1, Axon 6.2, LDAP, SAML SSO, SSL, Informatica Cluster Service (ICS), Catalog Services, Model Repository, Data Integration, Content Management, Profiling Warehouse, EDC admin tool, EDC catalog UI, IDL UI, B2B Data Transformation Informatica MDM 10.3 HF1, 10.3 HF3, 10.1, 9.7.1 HF5, 10.2 Power Exchange for SAP, Power Exchange for Snowflake, Salesforce.com Informatica Intelligent Cloud Services (IICS), Secure Agents, Data Integration, Mass Ingestion, Amazon Redshift, Amazon S3, REST, Salesforce.com, SharePoint, PostgreSQL, Data Bricks AWS Cloud, Cloudera distribution of Hadoop, Pentaho DI and BA, SAS, Business Objects, SAS 9.2/9.3, HDFS, HIVE, IMPALA, Spark, Sqoop, Kafka, Elastic Search

Database/Tools: Oracle 12cR1/11gR2/10gR2/9i/8i, MS SQL Server 2016/2012/2008 R2/2005, db2, RMAN, PostgreSQL, TeradataAmazon RDS for Oracle, Amazon RDS for SQL Server, Amazon Redshift

Database Management & Performance: DB2 Data Studio, DB2 Connect, SQL Management studio

Developer Tools: Toad, Business Objects

Monitoring Tools: EMAN

Change Management Tools: ServiceNow, CISCO Remedy Incident Management Tool, IRSP tool

Scheduler Tools: UNIX Crontab, ControlM

Operating System: RedHat Linux 5.x/6.x/7.x, Windows 2016/2012R2/2008R2, Windows 7

Cloud Environment: AWS, Azure

General Tools: WinSCP, MobaXterm, PuTTY, Windows AD, LDAP, Microsoft Office suite, Tomcat, MS SharePoint, MS Outlook, SSH Tectia Client 6.4.1.19, System capacity graphing Trends (CISCO tool)

Storage: SAN, Amazon S3, AWS EBS

PROFESSIONAL EXPERIENCE

Confidential

Informatica Administrator

Responsibilities:

• Configured Informatica components and assisted infrastructure team on installation, upgrades
• Installed and configured the Informatica MDM, and Active Vos BPM suite
• Installed and configured the Red Hat Jboss EAP application server for MDM
• Performed Informatica administration activities including Cloud Secure Agent installations & Configuration on windows / Linux platforms
• Worked on coordinating with different stakeholders to analyze the efforts consumed to perform Informatica On-Premises application to Informatica Cloud with varied complexities
• Migrated Informatica application from on-premises data center to AWS cloud
• Integrated IICS with third party tools (Control-M/ Databricks) with CLI by engaging Control-M Vendors and security team
• Worked on the Root Cause analysis for ETL job failures, Data issues and technical issues in IICS.
• Coordinated, planned, and executed activities related to platform maintenance, disaster recovery
• Assists with application health and server metrics collection and reporting.
• Also, Performance tuned SQL/PLSQL queries and other complicated database issues of various applications
• Involved in complete end to end ETL project lifecycle and architectural design of Informatica Cloud
• Performed and applied EBFs and CP 10.4.1.3.11 to overcome Log4J vulnerability security issues in EDC Development
• Created users, groups, connections, assign roles and privileges to enforce security authorizations on accessing the repository on Informatica Cloud
• Communicate with application teams and business on IICS patch schedules and updates
• Also, contributed to Informatica Enterprise Data Catalog upgrade from 10.4 to higher version 10.5

Environment: Informatica Power center, Data Quality, DEI, Informatica EDC, Axon, Azure platform, MDM

Confidential

Informatica Administrator

Responsibilities:

• Supporting Informatica PowerCenter, IDQ, BDM tools in their DEV, QA, Model and PROD environments.
• Worked on upgrades of above mentioned Informatica stack to latest versions
• Working on migrations/elevations and code deployments to higher environments
• Scheduling the jobs of BDM in Control-M and helping trouble shooting issues that developers encounter while running the jobs also supporting performance tuning for both BDM and PC in all the environments.
• Led and managing all administrative tasks from USI like installation, configuration and health checks of PC, BDM 10.2.1 HF1, IDQ 10.1.1 HF1 and DEI 10.4.1 on Linux platform, respectively
• Migrated the On-Premises Informatica PowerCenter and DEI applications to AWS cloud with EMR cluster
• Configure Informatica environments for Grid set up, High Availability and Disaster Recovery for on-prem as well as cloud setups
• Performed complete end-to-end design and migration for using custom Amazon tools, viz., S3 and Redshift to develop a working prototype to analyze the data using Informatica
• Improved the performance of Informatica jobs by restructuring underlying infrastructure
• Responsible for Pre-planning of Informatica Applications Upgrades with the respective team and provisioning of necessary AWS ec2 infrastructure for the setup and security
• Integrate Informatica with the applications like Salesforce and SAP HANA database, Kafka, Greenplum, Oracle, sources/targets etc.
• Involved in performing end to end testing after the informatica product gets installed, ensuring seamless performance and stable environment

Environment: Informatica Power center, Informatica DEI, AWS platform

Confidential

Application Admin Architect

Responsibilities:

• Installed the 4 Informatica products as below on Dev, SIT, Performance, Production and Dev2 environments: Informatica PowerCenter Informatica Data Quality Informatica Master Data Management Multidomain Edition Informatica Product 360
• Manage upgrade of MDM MDE from 10.3 HF1 to 10.3 HF3
• Implemented TLS hardening at application level and secure protocol between the application and databases to maintain the Confidential security standards
• Integrated with the applications like Kafka, Greenplum, Oracle, sources/targets, etc.
• Managed Go - Live activities from admin team for four domains as follows: Facility, Item Product, and Supplier
• Managed task coordination with the stakeholders at Confidential as part of maintenance activities, DB password policies, LDAP issues, Load balancer issues/P360 issues

Environment: s: Informatica PowerCenter, Informatica Data Quality Informatica Master Data Management Multi domain Edition Informatica Product 360

Confidential

Responsibilities:

• End to end setup, install, implementing, maintain and setting up of Informatica data suite products including PC, IDQ, MDM, EDC, Axon
• Configure backup automation for EDC/Axon using Shell Scripting
• Experience in setting up multi-node EDC setups with both embedded and external cluster configurations
• Securing EDC/Axon with LDAP configurations, SAML/SSO integration and applying SSL certificates
• Define AWS Disaster Recovery strategy, High Availability and performed testing for the same
• Configuring load balancing for EDC jobs using AWS ELB
• Provide architect and admin services to support all Informatica client environments.
• Allow all data citizens to be able access information about data assets across the enterprise without requiring outside help (self service).
• Develop processes and a scalable framework for data engineers to collect and share metadata from enterprise solutions
• Complete tracking of data movement including column/metric level and detailed impact analysis
• Creation of 360-degree view of the customer hierarchies, relationships, and affiliations
• Implemented various Metadata loads, process for importing Lineage from BTEQ scripts, export for Bodhi from EIC for tagging of Compliance programs, new Data Source for lineage, Data lineage end to end- amazon s3 to, Business term association, custom attributes and related to objects, search functionality becomes easier
• Integrate Informatica EIC with Axon to obtain data governance goal

Confidential

Informatica Administrator

Responsibilities:

• Perform architecture assessment, design, and capacity planning for MPD solution
• Conduct an architecture review of existing environment, and perform upgrades for Informatica PowerCenter (PC), Data Quality (DQ) and MDM 10.2
• Perform Installation of Informatica MDM 10.1 on DEV, TEST & PROD
• We split one Master domain into three domains thereby ensuring seamless performance and maintenance
• Delivered cost-effective and time-saving upgrade solution and reduced the delivery timeline from 12 week(projected) to 8 weeks
• Stabilized the environment by augmenting maintenance scripts to automate backups & start/stop of Informatica environments

Environment: Informatica PowerCenter, Informatica BDM, Informatica EIC, Informatica IDL on AWS cloud.

Confidential

Informatica Administrator

Responsibilities:

• Architect, Implement and support the Informatica PowerCenter 10.1 on AWS EC2 instance
• Integrate Informatica PowerCenter with Amazon RDS (SQL Server and Oracle) and Amazon S3 bucket source/targets
• Architect, Implement and support the Informatica Big Data Management (BDM), Enterprise Information Catalog (EIC), and Intelligent Data Lake (IDL) v10.1.1 HF1 on Dev and Prod environment
• Upgraded Informatica BDM, EIC and IDL from v10.1.1 HF1 to v10.2 Update 2 on development environment
• Implemented complex use cases to show data lineage in Enterprise Data Catalog
• Implemented Business Glossary synchronization with EDC from Analyst tool and vice-versa

Confidential

Informatica Administrator

Responsibilities:

• Installed, Upgraded, evaluated, and delivered Informatica PC & IDQ v9.6.1 HF4 to v10.1
• Perform periodic upgrades for all tools in the Informatica stack
• Working on migrations/elevations and code deployments to higher environments

Environment: Informatica Power center, Informatica Data Quality

Confidential

Informatica Administrator

Responsibilities:

• Installed Informatica Big data management, SAS
• Performed Informatica Cloud secure agent
• Installed Informatica private cloud
• Worked on set up of SSO / SAML authentication in Informatica Cloud

Environment: Informatica Secure agent, BDM, SAS, Informatica cloud, Hadoop

Confidential

Informatica Administrator

Responsibilities:

• Upgraded IDQ v9.5.1 HF4 to v10.1
• Supporting performance tuning for both BDM and PC in all the environments
• Perform periodic upgrades for all tools in the Informatica stack
• Experience in delivering secure environments by implementation of SSL and SSO on Informatica products

Environment: Informatica Power center and Data Quality

Informatica Administrator

Responsibilities:

• Upgraded IDQ v9.5.1 HF4 to v10.1
• Troubleshooting post upgrade issues for IDQ by improving profiling performance and tweaking DIS settings
• Upgrade complex MDM setup to higher versions
• Migration of MDM ors schemas from old to new environments
• Experience with JBoss application server for hosting MDM application
• MDM Active VOS, Resource Kit and Address Doctor configuration and setup
• Perform parallel upgrade for MDM to minimize disruption to client development activities
• Troubleshooting post upgrade issues for MDM by tweaking heap size and job performance

Environment: Informatica Relate 360, Informatica MDM Product 360 (PIM 360).