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.
• Expertise in installing, configuring and maintaining Informatica Power Center (9.x & 10.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.
• 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.
• Well exposed and worked closely with testing teams in performance unit testing, user acceptance testing and system integration testing.
• Used Auto Sys for automatic job management, event driven scheduling and programmable error recovery.
• Experience with Metadata Manager, Business Glossary, IDQ and Data Analyst.
• 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.

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/, 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, Power Exchange/Power Connect, Data Analyst, Metadata Manager, IDQ, Informatica MDM HUB 9.1/ 9.7/10.2 , Business Glossary.

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.

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Sr. Informatica Administrator

Responsibilities:

• Ensured support - services are up and running in all environments.
• Responsible for releasing Code to Production Environment (Developer will release code to QA initially)
• As the Informatica Administrator responsible for the smooth operation of Informatica in the Data Warehouse environment, including installing, upgrading, maintaining and tuning Informatica Power Center versions 8.1 through to 10.1 in four environments - Development, Testing, Quality Assurance and Production.
• Installed, configured, as well as actively involved in performing POC’s forData Quality, Metadata Manager,Data Analyzer, ILM - Data Subset, Data Archive and TDM
• Designed DR strategy for Informatica application.
• Involved in Informatica issue resolution, folder migration using Deployment groups, Administration and served as the first point of contact for any Informatica issues raised by project teams
• Actively involved in DR testing
• Managed successful migration of critical production and contingency servers with minimal business impact to application systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked on creation of ICS based data synchronization and data replication and mapping configuration tasks and ICRT (Real Time) based Guide, Processes, Objects, Connection, Service connectors, Process Objects using Informatica cloud application.
• Scheduled and Deployed new event driven processes, ICS tasks and ICRT tasks.
• Used Informatica cloud real-time for salesforce Managed package, which provides out of the box integration with salesforce and creation of salesforce specific guides.
• Responsible for Technical management/communication planning, charter, scope, estimates/forecasts, status reports, change management, training development for team members, scheduling and tracking projectfinancial goals, business objectives, risk registry, milestones and deliverables.
• Opening Informatica SR's (service requests) and working with INFA support to investigate/resolve issues.
• Responsible for the maintenance of all the Informatica environments (Production, Test, Development) including installation, configuration, performance tuning, monitoring and backups.
• Developed various utilities to automate admin tasks such as Informatica ETL Migration Automation, ETL Standard validation Utility, History Loads, Suspended Workflow List, Informatica Service Status Alerts, Disk Space Alerts, Invalid ETL Objects Tracker, Metadata Manager Refresh Utility, Missing Workflow Schedules, Schedule/Un-schedule Jobs, Cleanup Utilities using Informatica and UNIX shell scripting
• Involved in various DB upgrade projects
• Worked with Operations teams to help fixing infrastructure related issues pertaining to Network, Database and Unix
• Designed end to end Data Lineage analysis using Informatica Metadata Management tool.
• Designed and Developed ETL process using Informatica Power Center &Power Exchange.
• Developed Complex mappings to feed Integration Repository, Data warehouse & Data marts.
• Measuring the performance benchmarking and tuned Informatica Mappings, Sessionsand SQL for better performance by eliminating various performance bottlenecks.
• Created Database Stored Procedures, and Functions to process intermittent SQL queries directly on database.
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
• Provided technical guidance and best practices to other developers and groups as Technical Lead.
• Created and delivered Integration architecture presentations to the Architecture Review Board (ARB); participated in the architecture peer review process to ensure consistency of designs across the organization.
• Delivered major projects which includes implementation of LDAP Integration across environments, Proactive Monitoring Tool for Governance and Operations, Informatica cloud integration, Cloud Integration with Data Integration HUB
• Designed and Developed ETL process using Informatica Power Center &Power Exchange.
• Measuring the performance benchmarking and tuned Informatica Mappings, Sessions, and SQL for better performance by eliminating various performance bottlenecks.
• Created Database Stored Procedures, and Functions to process intermittent SQL queries directly on database

Environment: Informatica Power Center 10.1/9.6.1, Informatica MDM 10.2/9.1, Metadata Manager, IDQ, DVO, JBoss EAP, Oracle 11g/12c, Toad, SQL Developer, Redwood, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Soap/Rest UI.

Confidential, Silver Spring, MD

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.6.1 to version 10.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.
• Integrated Informatica with HDFS and Hive. Load data to HDFS and Hive.
• 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 Auto sys 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.4, 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, New York, NY

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.
• 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.6.1/9.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, Autosys.

Confidential, Fairfax, Virginia

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 7.1/8.1 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.

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.