SUMMARY:

• 10 plus years of experience in IT Industry with expertise in BI & Data Warehousing, as an ETL/ Informatica administrator with end - to-end upgrade/setup and cloud implementations
• Expertise in High-Availability Architectures with high level monitoring
• High level experience in Security Enhanced Environment builds
• Extensive troubleshoot skills
• Working knowledge of Hadoop, AWS, Azure, SFDC, Zuora and IICS Cloud Platforms.
• Informatica Certifications - R- Architecture and Administration, S- Mapping Design
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse (Target) Designer, Transformation Developer, Mapplet and Mapping Designer
• Experience in installing, upgrading in different environments and performing security administration tasks such as assigning permissions and privileges based on roles and responsibilities
• Experience in Code Migration - Globalization (Code page compatibility, version control, Data movement modes ASCII, UNICODE, Deployment groups) in team-based environment and scripting control files in XML (depcntl.dtd) using pmrep file commands.
• Experience in maintaining Informatica systems software, Backup / Recovery of Informatica software, repository and configurations with automation and applying upgrades/hotfix.
• Managing and monitoring skills in Admin Console, domains, multiple nodes, multiple repositories in a single domain and integration servers
• Strong experience in automation of Informatica products.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. Knowledge of Partitioning Data and session partitions.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Good understanding of Software Development Life Cycle (SDLC)
• Excellent communication skills, documentation skills, team problem solving ability, analytical and programming skills with high speed, quality conscious, multi-tasked environment.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux

Core Tools: INFORMATICA - CLOUD-IICS, POWER CENTER 9.x/10.x, Power Exchange 8.x/9.x IDQ, MDM, IDE

Reporting Tools: COGNOS (Frame work mgr, Report Net), Business Objects (XI R2/6.5), Jaspersoft iReport Professional 4.2.0

Data Mining Tools: SPSS - CLEMENTINE Version 11/12.0, XLminer

Modeling Tools: MS Office Visio, IBM Rational Rose, ERwin

RDBMS: Teradata, PostgreSQL, Netezza, Oracle, SQL-Server, MySQL

Other: Java Script, ODBC - Data Direct, Fusion Bus, Tivoli, C:D, VCS, SVN, HSMP, GPFS, Autosys, Eclipse, BMC-Remedy, HPQC, Cisco Tidal Enterprise Scheduler; Appworx, Perforce, Amazon Web Services (EC2, S3, EBS, RDS, DC, VPC), Azure, Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Informatica Administrator

Responsibilities:

• Gathered business requirement, conducted systems analysis and created technical design documentation with architects and infrastructure teams
• Supported and administered the teams for day to day operational tasks
• Performed upgrading from 9.x to 10.x, Installation, maintaining and monitoring of Informatica client and server components
• Managing and monitoring domains, nodes, repositories and integration services
• Security administrations: creating and managing users, groups and access permissions & privileges based on roles and responsibilities.
• Managing repositories, metadata, globalization, versioning (including check-in/checkout)
• Supporting with best-practices ensuring quality and actively working for fast Performance Tuning, mostly in mapping and shortcuts strategy
• Exporting and importing XML files, flat files using FTP where ever necessary
• Implemented DR performing integration and functional testing in scheduled stages, and monitoring log files on services
• Managing and monitoring Cloud.

Environment: Informatica Cloud, Power Center 10.x/9.x, Oracle 12c/11g, Linux.

Confidential, WI

Informatica Administrator

Responsibilities:

• Design, implement and perform administration functions for Informatica environment.
• Branch Automation (full automation for new lane creation)
• Security Measures - Application level (all tools including MFT) and open passwords encryption
• Architectural best practices for multiple nodes on grid
• MFT automation - for file transfer
• Deployment automation - full deployment with front end web form
• Auditing - proactive monitoring setup
• POC on 9.6, including other tools and services
• 9.6 Upgrade documentation, planning and testing
• Best Practices guidelines and check automation
• Versioning of scripts and PARAM files
• Day-to-Day support
• POC for AWS
• Configure Amazon EC2 instance
• Amazon redshift connectivity - Power exchange and ODBC setting session level properties based on connectivity
• Good knowledge of Amazon Redshift massively parallel processing (MPP) architecture.
• Power Center resource provisioning on Redshift clusters (Groups) in "Distributed and Pseudo Distributed mode"

Environment: Informatica Power Center 9.1.1/9.6 HF3, AWS, Microsoft SQL server, Windows/VMware, CONTROL-M

Confidential, Ohio

Informatica Administrator

Responsibilities:

• Upgrade from 8.x to 9.x, Code migration
• Installing/Upgrading/applying ebf fix in Informatica environments
• Design, implement and perform administration functions for Informatica environment.
• Execute strategy, architecture, design and implement data masking using Informatica Persistent Data Masking Tool.
• Determine the impact upon software deployments, operations, and supportability to ensure timely and uninterrupted service for the customer.
• Participated in design sessions with architects and implements the design.
• Configure, manage and troubleshoot PowerCenter domain, nodes, Service Manager, Application Services and licensing.
• Developed disaster recovery and failover strategies for the data integration environment.
• Responsible for High Availability and PowerCenter Grid configuration and creates nodes/services as needed.
• Managing user and user group access to the domain components.
• Managing backup and recovery of the domain metadata and appropriate shared file directories.
• Test and implement new technical solutions related to Informatica.
• Collaborated, coordinated, and communicate across disciplines and departments.

Environment: Informatica Power Center/Data Quality 9.5.1/9.6.0 , Oracle 11g, AIX, ILM, TSM, CONTROL-M, AUTOSYS.

Confidential, CA

Informatica Administrator

Responsibilities:

• Upgrade from 8.x to 9.x, Code migration
• Installing/Upgrading/applying ebf fix in Informatica environments
• IDQ installation including Reporting and Dashboards Service, Content Management Service, Analyst Service
• Creating, managing and monitoring users, groups, permissions and privileges
• Monitoring and managing domains, nodes, repositories and integration servers on grid
• Monitor and resolve issues related to data integration tools and environment.
• Develop and implement monitoring, backup and restore process to ensure high availability of the tools
• Create and maintain the software migration process, coordinator and implement improvements to the migration process.
• Perform daily operations to support ETL development including import definition, creating folders, resolving migration issues.
• Shell script automation to backup/purge logs/Archive files
• Setting up and Running power center Reports
• Support development, testing & production support teams to resolve any issues
• Communicate with informatica global support to troubleshoot

Environment: Informatica Cloud, Power Center 8.1.1 - Power Center 9.5.0, IDQ 9.5, Oracle 10g, RHL 5.8, Jaspersoft iReport Professional 4.2.0

Confidential, IL

Informatica Administrator / Technical Manager (Infrastructure)

Responsibilities:

• Installing/Upgrading/applying ebf fix in Informatica environments
• Creating, managing and monitoring users, groups, permissions and privileges
• Worked on Informatica Analyst & Developer, Web Services, Jasper soft repository, Data Services and Profiling Option
• Monitoring and managing domains, nodes, repositories and integration servers on grid
• Monitor and resolve issues related to data integration tools and environment.
• Develop and implement monitoring, backup and restore process to ensure high availability of the tools
• Create and maintain the software migration process, coordinator and implement improvements to the migration process.
• Perform daily operations to support ETL development including import definition, creating folders, resolving migration issues.
• Working with environment managers to build Dev/IT/TEST/QA/PROD environments
• Deploying deployment groups using control scripts
• Shell script automation to backup/purge logs/Archive files
• Support development, testing & production support teams to resolve any issues
• Communicate with infa global support to troubleshoot
• Import objects from PowerCenter to Salesforce
• SAP configuration with power exchange
• Integration with B2B data Transformation
• Test queue connections on servers (WebSphere MQ)

Environment: Power Center/ Power exchange 9.0.1 HF2, IDQ 9.1, Informatica Cloud, MDM, Oracle 11g, AIX 5.6, RHL 6.0 Remedy, HPQC

Confidential, Florida

Informatica Admin/ ETL Support Lead

Responsibilities:

• Leading offshore team in distributing/prioritizing given requirements to complete task as per given ETA
• Gathered business requirement, conducted systems analysis and created technical design documentation for ongoing/new task.
• Installing/Upgrading Informatica environments (OCS)
• Creating, managing and monitoring users, groups, permissions and privileges
• Monitoring and managing domains, nodes, repositories and integration servers
• Managing, monitoring and performing Benchmarks on regular intervals (24/7 Support)
• Quick problem solving (on-time SLA) and giving permanent solutions on short time. (Remedy tickets)
• Active participation with all team coordination in resolving any issues.
• Programming Unix Shell scripts in applications to execute, monitor, validate, schedule and archive the data.
• Security administrations: creating and managing users, groups and access permissions & privileges based on roles and responsibilities.
• Review, optimize, validate and test ETL jobs, Purge & Archive data.
• Import/Export from Test to QA to Production (with change management approval process)
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs.
• Performing integration and functional testing in scheduled stages, and monitoring log files on services
• Worked on JAVA /KML / ArcGIS / COGNOS Report Net / ksh Shell scripting

Environment: Power Center 8.6.1, Oracle 10g, SQL Navigator 5.0, Eclipse IDE & IBM Web sphere (Java), COGNOS BI 8 (Report Net), ESRI - ArcGIS, AIX, Remedy BMC-CTRLM.