SUMMARY

• Over 8+ 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 configuring security access manager, resource loading and monitoring operations of MDM HUB.
• Experience with Metadata Manager, Business Glossary, IDQ, IDD, Data Profiling and Data Analyst.
• Expertise in installing, configuring and maintaining Informatica PowerCenter (8.x & 9.x) versions.
• 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.
• 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 … DB2/UDB, MS SQL Server … 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.
• Experience with Production support (Analyzing, Troubleshooting and identifying root cause analysis for the failure).
• 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.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

PROFESSIONAL EXPERIENCE

Confidential - Reston, VA

Informatica Administrator

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.
• 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.5.1 to version 9.6.1 on Linux servers.
• 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.
• Worked closely with Development managers to evaluate the overall project timeline.
• Install and Configure MDM HUB software and setup databases for the Hub store.
• Configure security access manager, resource load and monitor operations of MDM HUB.
• Utilized Informatica Data Quality (IDQ) extensively for loading the data into Informatica MDM Hub.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• 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 Production Support to research and resolve the daily load issues and trouble shoot them.
• Document the Production 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).
• Supported production Implementations and migrations, worked with Informatica vendor to get the root cause/fix on issues. 24/7 on-call support.
• 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 9.6.1/9.5, Power Exchange, Oracle 11g, Toad, SQL Developer, SQL Loader, IDQ, Informatica MDM HUB 9.6.1/9.7, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Autosys.

Confidential - New York, NY

Informatica Administrator

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 PowerCenter mappings to calculate the load times for batch processing and tuning the mappings.
• Installed and Configured Informatica PowerCenter 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.
• 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. 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.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type 2.
• 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 and provide 24/7 on call support.
• 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, 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.

Confidential - Bloomington, IL

Informatica Administrator

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.
• Installed, Configured Informatica product suite such as PowerCenter 8.6.1, Metadata Manager.
• Responsible for Capacity planning, server monitoring, setting up load balancing techniques on all Informatica environments/servers.
• Responsible for resolution of all issues related to platform which includes product functionality, operational, performance and security issues.
• Involved in setting up the security process and ldap configuration for Enterprise Informatica platform.
• Single point of contact for raising service requests with Informatica for resolving any product related issues.
• Maintained Run book, periodically logging in all the latest issues, resolutions, workarounds, Contact lists etc. thereby eliminating similar outages in the environment.
• Active participation in Enterprise data warehouse Design, Data analysis, Meta data strategy, Architecture, code Deployment and migration policy, setting up Audit and various other security compliances.
• Effectively utilized Push Down Optimization (PDO) and optimized performance intensive jobs cutting the run time by 70%.
• Participated in developing the coding standards and best practices for Informatica developers across Enterprise.
• Capacity planning of all Informatica and Oracle servers.
• Prepare DR plan and recovery process for Informatica platform.
• Provided 24*7 primary on-call support for all Informatica environments/applications.

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

Confidential - Washington, DC

Informatica Administrator

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 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapp lets, 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.1, Power exchange for Oracle, DB2, Business Objects 6.0, UNIX Shell Scripting, DB2 8.0, Oracle 10g, SQL Server 2008, TOAD, Linux/Solaris.