SUMMARY

• Over 7+ years of experience in the field of Information Technology with good hands - on experience with ETL Informatica administration/design/development and Data Warehouse Implementation/development.
• Expertise as Informatica Administrator to setup new Informatica environments and Upgrade existing Informatica environments to new versions.
• Experience with Install and configure and maintaining of MDM Hub and MDM application server (WebLogic, JBOSS) and MDM data stores.
• Experience with Metadata Manager, Business Glossary, IDQ, IDD, Data Profiling and Data Analyst.
• Expertise in installing, configuring and maintaining Informatica Power Center (8.x, 9.x&10.x) versions.
• Experience with creating Model Repository Service, Data Integration Service, Data Analyst and Search service.
• Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
• Good experience with change management, deploying code from DEV to TEST and PROD - using deployment groups in Informatica Repository manager.
• Excellent knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, Repository management and administration.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Expertise with Hortonworks Hadoop platform (HDFS, Hive, oozie, Sqoop, Yarn)
• Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
• Pertinent experience using heterogeneous databases such as Oracle 9i/10g/11g, DB2/UDB, MS SQL Server 2012/2008, XML and various Flat File (Structured/Unstructured) systems for integration into Enterprise/Business Analysis DWH.
• In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
• Experience in writing shell scripting for various ETL needs.
• Proficient in applying performance tuning concepts to Informatica Mappings, Session properties, and database.
• Well exposed and worked closely with testing teams in performance unit testing, user acceptance testing and system integration testing.
• Used AutoSys for automatic job management, event driven scheduling and programmable error recovery.
• Proficient in applying performance tuning concepts to Informatica Mappings, Session properties, and database.
• Used Auto Sys for automatic job management, event driven scheduling and programmable error recovery.
• Support the Testers, Deployers and KT to the Team about the best Practices.
• Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/, Virtualization,SQL Server 2012/2008/2005 , DB2 10.1/9.7 FP1, Sybase 15.x.

ETL Tools: Informatica Power Center 10.1/9.6.1/9.1/8. x/7.x Power Exchange/Power Connect, Data Analyst, Metadata Manager, IDQ, IDD, Informatica MDM HUB 9.6.1/ 9.7, Business Glossary.

Operating System: Unix-AIX/Linux/Solaris, Windows NT/2000/XP/7/8.

Languages: SQL,PL/SQL, Shell Scripting

Modeling Tools: ER Studio, Erwin 4.1, MS Visio.

Dimensional Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension Tables, Logical and Physical Data Modeling.

Other Tools: SQLPlus, Toad, AutoSys, SQL developer, WebLogic, JBOSS, SQL Management Studio, Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Informatica Admin

Responsibilities:

• Gathering the requirements for the Informatica Power Center Install on Servers.
• Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
• Configure the Security (LDAP), enabling the OS profiles and Applying Patches on the base install.
• Install and Configure HA for domain repository service and Integration service.
• Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Upgraded Informatica power center 9.6.1 to version 10.1 on Linux servers.
• Install, upgrade and configure Informatica 10.1 in POC environment.
• Install and Configure Informatica DR environment platform.
• Created Shell scripts to automate the Backups, ETL Execution. Worked on Managing the Alerts for the server failures using SMTP Configuration.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Performed tuning of Informatica Mappings for optimum performance.
• Implemented Informatica Power Center DR.
• Install Metadata Manager and load resource and generate lineage.
• Metadata manager linking rules.
• Worked closely with Development managers to evaluate the overall project timeline.
• Experience in Installing and configuring MDM HUB software and setting up databases for the Hub store.
• Experience with configuring security access manager, resource loading and monitoring operations of MDM HUB.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Involved in Prod Support to research and resolve the daily load issues and trouble shoot them.
• Document the Prod job failures and provide the root cause analysis to the management.
• Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD).
• Developed UNIX scripts for scheduling the delta loads and master loads using Autosys Scheduler.
• Scheduled meetings with Senior Data Leads and analyzed the data.

Environment: Informatica Power Center 10.1/9.6.1, Power Exchange, Metadata Manager, IDQ, DVO, Hortonworks 2.2, Informatica MDM HUB 9.6.1/9.7, Oracle 11g, Toad, SQL Developer, SQL Loader, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Autosys.

Confidential, Cary, North Carolina

Informatica Admin

Responsibilities:

• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for maintaining repository backups and their restorations.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Bench Mark testing of Hardware and Informatica Power Center mappings to calculate the load times for batch processing and tuning the mappings.
• Installed and Configured Informatica Power Center on Client and Server Machines and Configure Informatica Server and Registered Servers.
• Install and configure Power Exchange for Oracle and SQL server.
• Implemented Type II Slowly Changing Dimension methodology for accessing the full history of customers.
• Upgraded Informatica from 9.1 to 9.6.1 version
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the Source data and developed the code to extract the data and implemented in the informatica.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Worked on various tasks like Session, E-Mail task and Command task.
• Used mapplets, parameters and variables in mappings as per the requirement.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Support Production job failures and resolve the issue in timely manner.
• Troubleshoot the Productions failure and provide root cause analysis.
• Worked on emergency code fixes to Production.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• Tested different data load databases by comparing source and target table counts and tested Informatica data loads from database to database.
• Developed UNIX scripts for scheduling the delta loads and master loads using Autosys Scheduler.

Environment: Informatica Power Center 9.1/8.6.1, IMM, MDM, Oracle 11g, SQL Server 2005/2008, AIX 6.1/ Linux RHEL 6.x/5.x, Toad, IBM DB2, PL/SQL, SQL Developer, Windows XP,PL/SQL, Sybase, Autosys.

Confidential, Minneapolis, MN

Informatica Admin

Responsibilities:

• Installed and Configured Informatica PowerCenter on Client and Server Machines and Configure Informatica Server and Register Servers.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for maintaining repository backups and their restorations.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Managed one-time migration of data with planned outages in the weekend.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Bench Mark testing of Hardware and Informatica PowerCenter mappings to calculate the load times for batch processing and tuning the mappings.
• Experience with Production support. Working in Incident tickets and providing 24/7 on-call support.

Environment: Informatica Power Center 8.6.1 Power exchange for Oracle, DB2, UNIX Shell Scripting, DB2 8.0, Oracle 10g, SQL Server 2005, TOAD, Linux/Solaris.

Confidential

Informatica Consultant

Responsibilities:

• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for maintaining repository backups and their restorations.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Populated data into staging tables from flat files, XML sources and Relational Sources.
• Installed and Configured Informatica Power Center on Client and Server Machines and Configure Informatica Server and Register Servers.
• Worked on Informatica Power Center 7.1/8.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Managed one-time migration of data with planned outages in the weekend.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Bench Mark testing of Hardware and Informatica PowerCenter mappings to calculate the load times for batch processing and tuning the mappings.
• Developed Unix Shell scripts to extract and convert data from different legacy systems in databases.
• Generated reports for Underwriting, Claims and Payments, tuned Reporting Queries for faster retrieval time.

Environment: Informatica Power Center 8.5.1/8.1, Power exchange for Oracle, DB2, Business Objects 6.0, UNIX Shell Scripting, DB2 8.0, Oracle 10g, SQL Server 2008, TOAD, Linux/Solaris.