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.

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, Redwood, SQL developer, SQL Management Studio, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, NJ

Sr. Informatica Administrator

Responsibilities:

• I nvolved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Installed Informatica 9.x and configured in GRID.
• Upgraded Informatica from 9.5 to 9.5.1 and from 9.5.1 to 9.6.1
• Installation and configuration of Power centre Repository service, Integration service.
• Installed and configured B2B data Exchange, IDQ and power centre integration.
• Migrated the existing Informatica legacy system (Solaris) to Linux environment.
• Configured services like MFT, Activemq, and Dashboards in B2B data Exchange.
• Manage and backup the B2B Data Exchange repositories in frequent intervals.
• Configured load balancer in B2B environment.
• Providing the necessary privileges for team and maintaining the security and permissions to the Active MQ services in B2B DX.
• Configured the batch workflows to the particular integration service in B2B DX.
• Installed Data Archive service to archive the events in B2B DX.
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Configured Content Management service for analyst tool.
• Installed and configured Data Transformation engine in UNIX environment.
• Establishing connectivity with various data sources like Oracle, Green plum, sqlservers, Sybase.
• Experience in writing SQL, T-Sql, PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per the business needs.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Enabling Ge-Coding as per the project need.
• Having experience in architecting and DR process.
• Created projects in the IDQ developer tool.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured Users/Groups from Informatica domain configuration.
• Involved in creation of folders/user permissions and folder groups for power centre.
• Done LDAP configuration and synced users from the external active directory.
• Created technical support documentation for the team for production support.
• Worked on the three tier model (DEV, TEST, and PRODUCTION).
• Worked on offshore/onshore model and coordinate with the team on regular calls.
• Scheduling the workflows using Informatica command-line utilities.
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups.
• Used the email task in the Production to keep the team posted on process status.
• Created stored procedures to implement the logics and using them in Informatica.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.
• Schedule a call to the relevant teams if any abnormal job timing or any unexpected data arrived to understand the current scenario.
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrades to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinated with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.

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, VA

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, Piscataway Township, NJ

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.