SUMMARY:

• Over 15 years of IT experience in the System Analysis, Design, Development, Implementation, Testing and Reporting for Data Warehousing.
• 15 years of experience in ETL processes using Informatica Power Center 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 2016, Oracle 12c, 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.

SKILL:

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

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

Databases: SQL Server 2016, Oracle 12c, Teradata, IMS(Mainframe),DB2

Operating Systems: Windows 2012, Sun Solaris 11, HP-UX, Confidential -AIX.

OOD ER studio: Scheduling Tools Autosys, CA WorkStation (ESP), Informatica Scheduler, Tidal

Methodologies: Waterfall, Agile

Version Control: Subversion

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Administrator

Responsibilities:

• Install and upgrade Informatica PowerCenter to 10.2 HF1
• Install and upgrade Informatica PowerExchange to 10.2 HF1
• Install Informatica Cloud Secure Agent for IICS
• Install IDQ and MDM 10.2 HubStore, HubServer, Hub Console and Process server
• Use IICS to connect to Salesforce and AWS and run jobs on Informatica Cloud
• Configured Informatica PowerCenter, IDQ and MDM to run on Multi-node architecture for High availability.
• Folder migrations from PowerCenter 9.6 to 10.2
• Mentor Informatica developers and Administrators.
• Use Repository Manager for managing Deployment groups and code migration
• Created Informatica Queries to query Informatica Metadata.
• Migrate param files, source files and target files as needed.
• Create Standards documents to help developers have a road map of coding standards.
• Assigning security and permissions to the developers using Informatica Admin Console.
• 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 10.2 and Cloud implementation.

Environment: Informatica Power Center 10.2, MDM, Informatica Cloud, Windows 2012 R2, Exadata, Solaris 11, SQL Server 2016, Oracle 12c, Metadata Manager, Web services, Korn Shell

Confidential, IL

Sr. Informatica Administrator

Responsibilities:

• Install Informatica PowerCenter 9.6.1 and then upgraded it to PowerCenter 10.1
• Folder migrations from PowerCenter 9.5 to 9.6
• Install MDM 10.1 HubStore, HubServer, Hub Console and Process server
• Install MDMExecuteBatch to run MDM jobs using shell scripts.
• 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 10.1/9.6, MDM,UDB DB2,Unix AIX, SQL Server 2008, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality (IDQ).

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

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.