SUMMARY

• Informatica Administrator with 7+ years of IT experience in Design, Development, Administration and Maintenance of Data warehouse applications as an Informatica Administrator and ETL Developer.
• Install, Configure and Upgrade Informatica Power center 9.5.1/9.1.0 /9.0.1/8. x/7.x on IBM AIX, SUN - SOLARIS and LINUX.
• Experience in Applying Informatica Hot fixes/EBF
• Installed & configured Informatica 9.5.1 B2B Data Transformation.
• Experience in configuring Power Exchange for Teradata Parallel Transporter (TPT)
• Extensively worked on migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Experience in Informatica Data Quality, Data Explorer and Power Exchange.
• Experience in 24X7 on call Production support and preparing procedures/documentation whenever necessary.
• Having sound knowledge on Teradata utilities like Multi load, Fast load, Fast Export&TPUMP.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, VSAM, DB2, Oracle, SQL Server and Teradata.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner and Update Strategy
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process
• Good knowledge on Insurance, Health care and Retail Domains.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5.1, B2B DT & Informatica Data Quality

Databases: Oracle 11g/10g, MS SQL Server2005/2008, Teradata 14

Reporting Tools: OBIEE

Languages: SQL, PL/SQL, Unix Shell Scripting.

Operating System: UNIX (AIX, Solaris, LINUX), Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Informatica Administrator

Responsibilities:

• Installed, configured & upgraded to Informatica Power Center 9.5.1 from previous versions.
• Assists team in defining solutions using Informatica.
• Plans and manages software upgrades and installation.
• Create Users, Groups and Roles in Admin console(Administrator) and assign the privileges to the same.
• Create the Folders and assign permissions to developers for Folders depending up on the environments.
• Maintain the Log Management
• Perform CODE DEPLOYMENTS of ETL jobs across various ETL projects and servers.
• Provide Application support to ETL application development teams.
• Create, backup, restore and DR for Informatica Repositories.
• Establish projects, roles, users, privileges in different ETL environments (DEV, UAT& PROD).
• Perform and assume other duties and responsibilities as required at direction of management.
• Provide 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica Server, unexpected Informatica services failures, Repository issues etc.)
• Record and maintain ETL software procedures.
• Perform independently with little direct supervision in administration of ETL.
• Communicate infrastructure needs and directions with management.
• Implement procedures to maintain, monitor, backup and recovery operations for ETL environment.
• Report regularly on health and performance of ETL environment and jobs.
• Preparing weekly and monthly progress report

Environment: Informatica Power Center 9.5.1/9.1.0 , Oracle 11g/10G, IBM AIX, Teradata, Ctrl M.Windows XP professional.

Confidential, NC

Informatica Administrator

Responsibilities:

• Analyzed Incident and Change requests and complete the requests as per Configuration Management Releases.
• Creating SR to Informatica Inc- related to any Power center product issues.
• Installing Informatica Power center 8.6.0 on SUN-SOLARIS and applying Patches/Hot fixes.
• Performed Upgrading Informatica Power center Version 8.X to Informatica Power center 9.0.1.
• Ensures proper configuration of the Power Center Domain components
• Configuring nodes, Repository services, Integration services and SAP BW services.
• Configured Informatica Data Quality 9 on PowerCenter 9.0.1
• Create and maintain ETL administration best practices and procedures.
• Create Operating System Profiles and assign the OS profiles to folder.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements.
• Perform root cause analysis, performance monitoring and application related issues.
• Handle user access / security role requests for new developers and projects.
• Write Repository Queries in support of developments and Production statistics.
• Ensures proper application of the licensing files
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Performs Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Work with UNIX Admin and DBA team related to OS and Database related issues.
• Monitoring the Jobs and sever space availability and CPU Process.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process
• Add and update ODBC and TNS entries.
• Preparing standard operating Procedures for related Informatica issues

Environment: Informatica Power Center 9.0.1/8.6.1 , Oracle 10G/9i, Red hat LINUX/Sun Solaris, Teradata, UC4, and Windows XP professional.

Confidential, SFO, CA

Informatica Administrator

Responsibilities:

• Installing Informatica Power center 8.1.x on IBM-AIX and applying Patches/Hot fixes.
• Performed Upgrading Informatica Power center Version 7.X to Informatica Power center 8.X.
• Migration of Informatica objects across different environment like DEV, QA, UAT and PROD.
• Create Users, Groups and Roles in Admin console and assign the privileges to the same.
• Create the Folders and assign privileges to developers for Folders depending up on the environments.
• Maintain the Log Management.
• Monitoring the Informatica environments by using automated UNIX scripts and make sure Informatica up and running.
• Create and maintain the Relational and Loader ODBC connections in Development, QA and Production environments.
• Import and export INFA xml’s across repositories from clear case versioning server.
• Creation of Static and Dynamic deployment Groups, Labels and Queries
• Deployments from one repository to another repository using Labels, queries and dynamic deployment groups
• Handling space issues on UNIX servers to minimize the repository unavailability
• Extensively worked on Folder deployments across different repositories
• Monitoring the scheduled jobs and UNIX servers over 24/7 rotations
• Extensively worked on migration of UNIX files and directories in UNIX environments across different servers
• Backup and recovery management

Environment: InformaticaPowerCenter 8.6.1 & 7.1.2, Oracle 10G/9i, Teradata, IBM-AIX, Windows XP professional.

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Installing Informatica Power center 7.1.2 on SUN-SOLARIS and applying Patches/Hot fixes.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Create Users, Groups and Roles and assign the privileges.
• Create Folders and give permissions for the folders in a repository.
• Stop and Start the Informatica services by using UNIX Server.
• Create the Relational and Loader ODBC connections in Development, QA and Production environments and assign privileges to Connections as per the environment standards.
• Create service accounts and encrypt the passwords and maintain in UNIX Password file.
• Import and export INFA xml’s across repositories.
• Folder deployments from one repository to another repository and within the same repository.
• Monitoring the scheduled jobs and UNIX servers over 24/7 rotations.
• Backup the Informatica Repositories as per the schedule.
• Preparing standard operating Procedures for related Informatica Production issues.
• Preparing weekly and monthly progress report.

Environment: Informatica Power Center 7.2(Repository Manager, Designer, Workflow Manager and Work flow Monitor), Oracle 9i PL/SQL, FTP (Client and Server), MS Office (Excel 2000/MS word/MS Access)

Confidential

Informatica Developer

Responsibilities:

• Gathering requirements from the various systems business users.
• Worked on InformaticaPowerCenter tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Designed and developed Informatica Mapping for data load and data cleansing.
• In Workflow Manager created connections, sessions, tasks, workflows etc.
• Created complex SCD type 1& type 2 mappings using dynamic lookup, Joiner, Router, Expression, Update Strategy and Sequence Generator.
• Worked on performance tuning of the complex transformation like SCD type 1 & SCD Type 2.
• Extracted, transformed data from various sources such as Flat files, MS SQL Server and Oracle transferred data to the target data warehouse Flat files.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading.

Environment: Informatica Power Center 7.1.2 (Repository Manager, Designer, Workflow Manager), Oracle 9i, MS Sql Server 2000.