SUMMARY

• Around 18 years of experience on Informatica - Power Center Administration, Data Warehousing, Data Flow Architecture, Data Analysis, Data Issue Resolution.
• Working as an Informatica Admin for the past 11 years - Daily tasks such as running repo queries, copying objects using labels from DEV to INT to TEST to PROD Repositories, version control, etc. Creating and managing the DB connections, User Groups, Users (Security), Folder Permissions.
• Extensively worked on data analysis, ETL data flow, data integration, performance tuning, system testing and documentation
• Ability to interact with end users, quick learner and team player with excellent communication, analytical and interpersonal skills

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Informatica Administrator

Responsibilities:

• Installation and Configuration of Informatica Products on AWS (PowerCenter 9.6.1/10.1.1 , IDQ 9.6.1/10.1.1 , MDM 9.7.1/10.1 on Linux Servers)
• Deploying the etl code from DEV to TEST/PROD.
• Worked on Informatica mappings to load the Landing and Staging tables
• Extensively worked on shell scripts on automation (Auto restart of services/servers, Disk space utilization, Informatica Server monitoring and Linux file system maintenance and clean-up, infacmd, pmcmd and pmrep operations).
• Monitoring the services on AWS Management Studio
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy/TFS tool. Documenting common issues and resolution procedures.
• Escalation of Informatica issues to Informatica Tech Support.
• Supporting the application project team requests on adhoc basis (Ex: verifying the data source connectivity, coordinating the Outages, disk space issues, Assigning permissions, data loads)
• Good understanding of ITIL V3 lifecycles and processes
• ITIL Service Strategy - focusing on understanding customer needs, directions, requirements, helping improve IT over time
• ITIL Service Operations - focusing on the day-to-day care and feeding of services

Confidential, Houston, TX

Informatica Administrator / Lead Developer

Responsibilities:

• Installation and Configuration of Informatica Products on AWS (PowerCenter 9.6.1/10.1.1 , IDQ 9.6.1/10.1.1 , MDM 9.7.1/10.1 on Linux Servers)
• Deploying the etl code from DEV to TEST/PROD.
• Worked on Informatica mappings to load the Landing and Staging tables
• Extensively worked on shell scripts on automation (Auto restart of services/servers, Disk space utilization, Informatica Server monitoring and linux file system maintenance and clean-up, infacmd, pmcmd and pmrep operations).
• Monitoring the services on AWS Management Studio
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy/TFS tool. Documenting common issues and resolution procedures.
• Escalation of Informatica issues to Informatica Tech Support.
• Supporting the application project team requests on adhoc basis (Ex: verifying the data source connectivity, coordinating the Outages, disk space issues, Assigning permissions, data loads)
• Good understanding of ITIL V3 lifecycles and processes

Confidential, Houston, TX

Informatica Administrator / Lead Developer

Responsibilities:

• Installed Informatica PowerCenter 9.5 on Linux Servers.
• Applied Informatica Hotfixes.
• Deploying the etl code from lower environments to PROD.
• Performance Tuning
• Maintaining Informatica Repository.
• Escalation of Informatica issues to Informatica Tech Support.
• Supporting the application project teams requests on adhoc basis (Ex: verifying the data source connectivity, coordinating the Outages, disk space issues, Assigning permissions, data loads, etc…)

Confidential, Houston, TX

Mid-Tier Informatica Administrator

Responsibilities:

• Monitoring the Application Services thru Site Scope / NetIQ. Deploy the etl folders from lower environments to PROD.
• Installed the Informatica 7.1.1/8.1.1 SP 3/8.6.1/9.0/9.5.1 and BO 6.5/XI on the Physical Servers.
• Installed Informatica Power Exchange 8.5.1 for nergize project for a change data capture project.
• Applying the EBF patches and Service Packs for Informatica.
• Prepared the Test Cases and Test Plans for Operational Acceptance Testing using Quality Center to verify how the new project impacts on the Server with existing applications running.
• Upgraded the Informatica versions from 6.2 to 7.1, 7.1 to 8.1.1. SP3, 8.1.1 SP3 to 8.6, 8.6 to 9.0, 9.0 to 9.5.1
• Coordination between the Application team and Firewall team to resolve the firewall issues on the application servers for the upstream data loads.
• Maintaining Informatica Repository and Business Objects Servers.
• Escalation of Informatica Issues to Informatica Tech Support
• Supporting the application project team’s requests on adhoc basis.
• Verifying the data source connectivity, coordinating the Outages, Disk Space issues, Login issues on Citrix.
• Worked with infrastructure teams to ensure an effective operating environment
• Defined standards and implemented INFORMATICA best practices.
• Supported highly available and distributed ETL environment (GRID). Hands on knowledge on Integration Services Architecture and its components such as Load Balancer, DTM processing, Grids, code pages and data movement modes etc.
• Imparted 24/7 on call support on a monthly rotation basis.
• Defining the Job Groups, Jobs, Job dependencies on Tidal Enterprise Scheduler
• Setting the Tidal Job rules and defining schedule dependencies

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Involved in extracting the data from the flat files
• Created mappings, mapplets to load the data from base tables into data marts.
• Worked on Performance issues with the existing mappings to reduce the time and memory usage.
• Worked on CRC (Cyclic Redundancy Check) Stored procedure to check the uniqueness of a record.
• Prepared software requirement specifications through interaction with business representatives.
• Created reusable mapplet transformations to load data from operational data source to Data Warehouse
• Accessed data from relational tables that are not sources in mapping using Lookup Transformation.
• Used Sys Admiral Tool (Tidal) Schedules to run the informatica sessions.