SUMMARY

• Having around 8 years of IT experience in Administrative, Development, and Support of Data Warehousing and Data Integration solutions using the Informatica tool.
• Hands - on knowledge and experience with Informatica Power Centre (PC), Informatica Data Quality (IDQ), Informatica Intelligent Cloud Services (IICS), and Master Data Management (MDM).
• Experience with Install and configure and maintaining of MDM Hub and MDM application server (WebLogic, JBOSS) and MDM data stores.
• Experience and hands-on knowledge about resolving development and environment-related issues by working with developers and Informatica vendors.
• Proficient in applyingperformance tuning concepts to Informatica Mappings, Session properties, and database.
• Knowledge and Hands-on Experience in Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• 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.
• Experience in troubleshooting the Session Logs, workflow log files, and debugging the code to fix the Testing issues.
• Experience in Upgrading Informatica Power Center from v .2 Versions.
• Involved in Requirement Analysis, designing overall Architecture, Identifying anomalies, IDQ Mapping development, and Testing.
• Experience in applying Hot Fixes and Patches to Informatica Platform.
• Experience in working with Informatica team regarding Production issues.
• Experience in analysing and resolving issues using data viewer and mapping logs.
• Experience in troubleshooting issues in data integration logs, model repository logs, and domain logs.
• Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.
• Good Knowledge in Cloud ETL applications like Snaplogic and Glue.
• Hands on Experience in Git hub activities and AWS services
• Experience in working on all IICS admin activities and hands-on experience in performing the migrations from lower environments to upper environments.
• Experience in troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances.
• Hands-on experience onGit Hub integrations with Cloud Applications.
• Experience in performing the tuning concepts to Informatica Mappings, Session properties, and database.
• Team player with good interpersonal and problem-solving skills, ability to work in a team andwork individually.

TECHNICAL SKILLS

RDBMS: Oracle 19C/12c/11g/, SQL Server 2012/2008, DB2 10.2/9.7 FP1, Sybase 15.x.

ETL Tools: Informatica Power Center 10.1/9.6.1/9.1/8. x, IDQ, TDM, IICS and Power Exchange, AWS, BDM

Operating System: Unix-AIX/Linux/Solaris

Languages: SQL, PL/SQL, Shell Scripting

Modeling Tools: MS Visio.

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

PROFESSIONAL EXPERIENCE

Confidential, Bowie, MD

ETL Admin

Responsibilities:

• Participated in meetings with respective teams to gather requirements for project set up
• Installed Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
• Provisioned the Users, Groups, Roles, and grant privileges to the users.
• Experience in creating the users manually and configuring the LDAP setup for users’ access.
• Created folders, Relational and Application connections and configure the ODBC connectivity.
• Participated in meetings with developer team and proposed the best practices
• Created test jobs to check the connectivity between the various databases and Informatica application.
• Responsible for the table imports and data map imports across the environments
• Experience in working with Production support and handling long running jobs in Production server.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Worked with developers on performing tuning of Informatica Mappings for optimum performance.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in creating the Unix Scripts, and used PMCMD and PMREP to interact with Informatica Server from command mode.
• Experience in Configuring the Secure Agents in IICS Application.
• Worked on migrating the files between the S3 buckets and ec2 instances to local desktop.
• Worked on creating the IICS Users and creating the cloud and ON PREM connections.
• Worked on troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances
• 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.

Environment: Informatica Power Center 10.2/9.6.1, Power Exchange, IDQ, Informatica MDM HUB 10.2, IICS, SQL Developer, SQL Loader, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Autosys.

Confidential, Pittsburg, PA

ETL/Informatica Admin

Responsibilities:

• 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·Performed Repository and Domain Backup and Restores as needed.
• Upgraded Informatica PowerCenter 9.6.0 to 9.6.1 and from 9.6.1 to 10.1
• Responsible to work with Informatica support, provide feedback to managers, find a root cause, and take necessary steps to prevent ongoing issues.
• Experience in providing on call 24*7 support.
• Coordinating all code migration efforts between all Dev, QAT, and Production environments.
• Performed Daily activities - Health check of all DEV, QAT, and PROD servers.
• Maintaining all Informatica repositories (DEV, QAT, and PROD).
• Performed Repository and Domain Backup and Restores as needed.
• Setup Maintenance Jobs for the start-up, shutdown, backup, purge, Space usage alert.
• Code Review for Production release.
• Interact with the network, database, and UNIX administrators to implement Informatica infrastructure and troubleshoot issues.
• Coordinating with users to resolve issues in Informatica Jobs and raising SR’s with Informatica Tech Support.
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing, and running the Batches and Sessions and scheduling them to run at specified time

Environment: Informatica PowerCenter 9.1/9.6.1, MDM 9.6/10.1, IDQ 9.6.1, Oracle 11g, SQL Server 2005/2008, Linux RHEL 6.x/5.x, IBM DB2, SQL Developer, Windows XP, PL/SQL, Sybase, Autosys.

Confidential, Tampa, Florida

Informatica Admin

Responsibilities:

• Implemented Hot fixes and EBF’s on top of Informatica Up-gradation.
• Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.
• Implemented the Data Director Service for Data quality.
• Created and configured the Reporting and Dashboards service for Data Quality application.
• Created and managed connections and providing the required access levels Using Repository Manager.
• Regular Monitoring and troubleshooting the Informatica domain.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Provided E2E support for Informatica Environment.
• Implemented full proof of concept (POC) as part of Informatica Up-gradation 10.2 to v10.4
• Managed the Informatica Logs and space related issues.
• Identified performance bottlenecks and involved in performance tuning of sources, targets, mappings, transformations, and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• 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.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Created UNIX Shell scripts and called as pre session and post session commands.

Environment: Informatica PowerCenter 9.1/9.5, Power exchange 9.1/9.5, IDQ 9.1/9.5, Business Objects 6.0, UNIX Shell Scripting, DB2 8.0, Oracle 10g/11g, SQL Server 2008, TOAD, Linux/Solaris, MDM.

Confidential

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.