SUMMARY

• 14 Years of IT experience and technical proficiency in the field of Data Warehousing and proven hands on experience in Informatica Administration and Architecting cloud based applications.
• 7 + years of experience in ETL Informatica Administration, Installation/Upgrade, Applying Hot Fixes, EBFs, Configuration, maintenance and troubleshooting on UNIX and Windows.
• Experience in Installation, Administration, Configuration, Code migration, job monitoring and Scheduling of Informatica Data Quality, DIH, ILM and Informatica Cloud service (ICS) products.
• Experience in setting up single/Multi node cluster for Mule 3.9 & 4.x engine on Linux, Anypoint Studio 6.x/7.x setup and managing Mule Anypoint Platform Upgrading Agents, Anypoint Monitor Agents, Applying fix - packs as per the business need.
• Setting up Alert mechanism for Informatica environment health check, Server resource Utilization -Disk utilization/Swap space/CPU Utilization on server, Informatica and Tablespace utilization of Application database.
• Experience in Setting up the various Database Connections using ODBC/Native Drivers - Azure SQL DB, MS SQL server, Teradata, Oracle, DB2,Sybase, JMS & MQ Connections in Informatica .
• Outage Handling (for any OS patching, Application upgrade) on Middleware application severs and scheduled Unix scripts to back up Informatica -Domain, Repository, Log files clean-up, Version purge across the environments.
• Extensive experience on providing performance tuning solutions at ETL and Database levels and providing optimal solutions for platform migrations.
• Good understanding business requirements from client and translate them into technical Architecture/design and helped them with analytical, problem solving and decision making skills.
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Experienced in leading and managing large teams with proven record for minimal turnaround time on assigned tasks and delivering successfully.
• Excellent communication skills with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.
• Basic understanding of Hadoop ecosystem, Experience in creating new users/users space/folder structure/privileges for new Application in HDFS cluster and Hue as well.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, IDQ, IICS, ILM, DIH

Programming languages: Unix Shell Scripting, PL/Sql, Python basics.

Relational Database: IBM DB2 10.1, Teradata 13, SQL Server, Oracle 9i, 10g, Azure SQL D

Job Scheduling: AutoSys, Control-M, JAMS.

Tools: Used: PuTTY, Eclipse, IBM MQ Explorer, AnyPoint Studio, Control-M,PL/SQL Developer, Toad, Service Now, ITSM.

PROFESSIONAL EXPERIENCE

ETL Administrator

Confidential

Responsibilities:

• Responsible to maintain the Informatica PowerCenter, IDQ and IICS applications across all 3 environments (Dev/QA/Prod).
• License Consolidation - Migration projects/environments to Enterprise environment.
• NAS/Data Centre Migration/validation.
• PowerExchnage installation for Azure SQL DW and MS BLOB.
• Performing the code migration using -Deployment group, export/Import or Folder copy.
• Configuring Ldap Authentication to accommodate other projects joining Enterprise environment.
• Outage handling - OS patching/Storage migration/Unplanned
• Applying EBF & Hotfixes across the environment.
• Maintaining User/Groups/Roles/Workflow Connection creation across the environment.
• Providing required support to application users and resolving their issues across the environment and weekend support on rotation basis.
• Escalates issues with other teams (infrastructure, DBAs, Developers, Networking, software vendors in order to fix production issues.

Skills: Informatica PC/IDQ, Mule & Tomcat, Unix Scripting, Putty,SQL Developer, Azure SQL DB/Blob Storage, IBM MQ explorer, AnyPoint Studio.

Informatica Administrator

Confidential

Responsibilities:

• Responsible to maintain the Informatica/DIH/ILM/Hadoop applications on UNIX/AIX across the environments.
• Responsible for Installation & configuration of Informatica Power enter/DIH/Hadoop Cluster on UNIX/AIX machines.
• Informatica/DIH -Code migration across the environment, scripted the manual migration approach.
• Informatica ILM installation & configuration and setup the archive & purge job.
• Outage handling - OS patching/Storage migration/Unplanned
• Applying EBF & Hotfixes across the environment.
• Maintaining User/Groups/Roles/Workflow Connection creation across the environment.
• Providing required support to application users and resolving their issues across the environment and weekend support on rotation basis.
• Escalates issues with other teams (infrastructure, DBAs, Developers, Networking, software vendors in order to fix production issues.

Skills: Informatica Power center, DIH, ILM,Unix, AIX,Hadoop Eco-system.

Confidential, Orlando

ETL Administrator

Responsibilities:

• Responsible for Installation & configuration of Informatica Power Center/Power Exchange on UNIX machines.
• Informatica code migration across the environment. Created Shell script to automate the manual migration process and File migration across the environments.
• Outage handling - OS patching/Storage migration/Unplanned
• Maintaining User/Groups/Roles/Workflow Connection creation across the environment.
• Providing required support to application users and resolving their issues across the environment and weekend support on rotation basis.
• Escalates issues with other teams (infrastructure, DBAs, Developers, Networking, software vendors in order to fix production issues.

Skills: Informatica PowerCenter 9.x, 10.x, Unix Scripting.

Confidential

IDQ Administrator

Responsibilities:

• Responsible for maintaining IDQ 9.5 environments, upgrade from IDQ 9.5 to 9.6 and applying EBF & Hotfixes across the environments.
• Configured Model Repository, Data Integration and Analyst services for Data Profiling and Quality with using Admin Console.
• Prepared implementation process document, Backup plans (i.e. Configuration blue print document, repository backup, groups, LDAP groups, users list, ODBC connections, relational database connections etc.)
• Worked with Informatica Product team, Infrastructure support team and application users to troubleshoot long running jobs.
• Informatica Server monitoring and mount drive file system maintenance and clean-up, and scripts using Informatica Command line utilities.

Skills: Informatica PowerCenter, IBM MQ, MFT, Unix Scripting.