SUMMARY

• Over 10 years of IT experience in the System Analysis, Design, Development, Implementation, Testing and Reporting for Data Warehousing.
• 10 years of experience in ETL processes using Informatica Power Center 9.6.1/9.1/8. x for multiple database source environments to Data Warehouse/Data Mart in Windows environments.
• Experience in Relational and Dimensional modeling.
• Dimensional modeling using star and snowflake schemas and implemented Slowly Changing Dimensions.
• SQL Server, Oracle 11g, TeraData,DB2, OLTP, OLAP, Data Reports, Erwin
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations, database administrations and database connections.
• Worked with PMCMD to interact with Informatica server from command mode and execute the shell scripts.
• Expertise in creating mapplets and reusable transformations using Informatica.
• Tidal scheduler for scheduling Informatica jobs.
• Self - Starter and comfortable in high intensity and challenging work environment.
• Extensive experience in financial, banking, telecom, healthcare & pharmaceutical industries.

TECHNICAL SKILLS

Informatica Tools: Informatica Power Center 9.6.1/9.1, Metadata manager 9.6.1, B2B Data Exchange, B2B Data Transformation, Power Exchange, Data Quality (IDQ), Data Masking and Informatica Cloud.

Scripting: Unix Shell Scripting (Korn shell, Bourne Shell).

Databases: SQL Server 2008, Oracle 11g, TeraData, IMS(Mainframe),DB2

Operating Systems: Win NT/2000/XP, Sun Solaris 11, HP-UX, Confidential -AIX.

Scheduling Tools: Autosys, CA WorkStation (ESP), Informatica Scheduler, Tidal.

Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. Informatica Administrator

Responsibilities:

• Install Informatica PowerCenter 9.6.1 and then upgraded it to PowerCenter 9.6.1
• Folder migrations from PowerCenter 9.5 to 9.6
• Mentor Informatica developers and Administrators.
• Manage Security and permissions using Admin Console.
• Use Repository Manager for managing Deployment groups.
• Created Informatica Queries to query Informatica Metadata.
• Informatica Code migration from PowerCenter 9.5 to PowerCenter 9.6
• Migrate param files, source files and target files as needed.
• Creating Standards documents to help developers have a road map of coding standards.
• Assigning security to the developers using Informatica Admin Console.
• Starting and stopping services and server when required.
• Implement Velocity document as suggested by Informatica.
• Help developers tune their workflows and sessions for better performance.
• Create the paper work to buy the software and hardware required for 961 implementation.

Environment: Informatica Power Center 9.6/9.1,UDB DB2,Unix AIX, SQL Server 2008, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality.

Confidential, GA

Sr. Informatica Developer/Administrator

Responsibilities:

• Install Informatica PowerCenter 9.6.1
• Repository upgrade from PowerCenter 9.1 to PowerCenter 9.6.1
• Installed and Implemented Informatica Cloud.
• Built reusable Informatica Cloud mappings to load data from SalesForce into SAP .
• Assigning security to the developers using Informatica Admin Console.
• Responsible for translating business requirements into Technical documents.
• Used ER studio for Data Modeling target database.
• Worked on both Dimensional model databases and Relational model databases.
• Extensively used Informatica to load data into Oracle 11g database using CDC real time and Batch workflows.
• Used Data Profiling to understand the source system data and develop rules.
• Wrote shell scripts to cleanse source data before loading it through Informatica.
• Created Informatica Mappings, Sessions, Workflows and scheduled it through Shell Scripts.
• Created relational connections and ODBC Connections for sources and targets.
• Implemented Oracle Partitioning for Yearly data.
• Created Materialized views to get local copy of Remote data. Used DBLinks.
• Use Repository Manager for managing Deployment groups.
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.1
• Migrate param files, source files and target files as needed.
• Creating Standards documents to help developers have a road map of coding standards.
• Help developers tune their workflows and sessions for better performance.

Environment: Informatica Power Center 9.6.1,Unix AIX, Putty, Crontab, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Profiling and Data Quality.

Confidential, IL

Sr. Informatica Administrator

Responsibilities:

• Install Informatica PowerCenter 9.1 and then upgraded it to PowerCenter 9.5
• Folder migrations from PowerCenter 8.6.1 to PowerCenter 9.1 and then to 9.5
• Mentor Informatica developers and Administrators.
• Manage Security and permissions using Admin Console.
• Use Repository Manager for managing Deployment groups.
• Created Informatica Queries to query Informatica Metadata.
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.5
• Migrate param files, source files and target files as needed.
• Creating Standards documents to help developers have a road map of coding standards.
• Assigning security to the developers using Informatica Admin Console.
• Starting and stopping services and server when required.
• Implement Velocity document as suggested by Informatica.
• Help developers tune their workflows and sessions for better performance.
• Create the paper work to buy the software and hardware required for 901 implementation.

Environment: Informatica Power Center 9.5/9.1/8.1,UDB DB2,Unix AIX, SQL Server 2008/2005, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality.

Confidential, CT

Sr. Informatica Administrator

Responsibilities:

• Responsible for creating, adding Repository using Repository Manger.
• Installed Informatica Power Center 8.6.1 on Development and Production Windows Environments.
• Used to create the relational connections and ODBC Connectivity’s for sources and targets schemas.
• Helped developers create and configure Workflows, Worklets, and Sessions tasks to transport the data to target using Informatica Workflow Manager.
• Also created various tasks such as command task, email task, Decision task, timer tasks,
• Responsible for migrating code.
• Responsible for enforcing standards.
• Developing proof of concept for new projects.

Environment: Informatica Power Center 9.0/8.6/8.1,UDB DB2,Unix AIX, SQL Server 2008/2005, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality

Confidential, NE

Sr. Informatica Developer /Administrator

Responsibilities:

• Extensively used Informatica to load data from Flat Files, Mainframes and SQL Server.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Extracted data from Mainframes IMS databases and VSAM files using Power Exchange.
• Used XML as sources and Target in Informatica mappings.
• Extensively used Triggers, Stored Procedures and Functions.
• Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Checked and tuned the performance of application.
• Developed data Mappings between source systems and warehouse components.
• Created and defined DDL’s for the tables at staging area.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Environment: Informatica Power Center 8.6/8.1/7.2, SQL Server 2005/2000, Metadata Manager, MS Access, ER Studio, Microsoft Reporting services, Web services, Data Masking, Data Explorer and Data Quality

Confidential

ETL Developer

Responsibilities:

• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations
• Created reusable transformations and Mapplets and used them in complex mappings.
• Maintain Development, Test and Production Repositories using Repository Manager.
• Wrote shell scripts and PMCMD to interact with Informatica server from command mode.
• Extensively worked on views, stored procedures, triggers and sql queries and defined DDL’s for loading the data before feeding the flat files.
• Migrated mappings from Development to Testing to Production.
• Created various documents such as Source-To-Target data mapping document, Backroom Services Document, Unit Test Cases and Data Migration Document.

Environment: Informatica Power Center 7.2, SQL Server 2005, Oracle 9i, ER Studio, Microsoft Reporting services, Web services provider.