PROFESSIONAL SUMMARY:

• Having 10+ years of IT experience in Analysis, Design, Development and Implementation, support of various EAI (Enterprise Application Integration), EDW (Enterprise Data warehouse) projects using ETL processing tool Informatica7.x,8.x,9.x(Designer, Workflow Manager, Workflow Monitor,Power exchange) in various domains like Banking, Insurance, Health insurance and Retail. Team Player with excellent communication, analytical, verbal and writing skills.
• Currently working as ETL Informatica Administrator.
• Experienced in performing informatica admin activities like installation, configuration of repository, integration services, back up of repositories, creating folders, migration of code and granting role access to users/groups to appropriate data maps by using admin console and repository manager and applying upgrade patches.
• Good Knowledge on UNIX Shell Scripting, familiar with perl scripting and scheduling using crontab, Control - M & Autosys tools
• Extensive experience working with business users, SMEs, App DBAs, infrastructure leads, Prod support team as well as senior management.
• Have experience in relational and dimensional data modeling for creating Logical and Physical Design of Database and ER Diagrams. Worked in security implementation based on roles.
• Experience in administration of IBM info sphere Change data capture(CDC) tool which has mapping tables from different sources like DB2,SQL server to oracle ODS of large volumes where data refresh and mirroring happens.
• Knowledge in Installation & Configuration like Informatica, BoxiR2 and Oracle.
• Good overview of production support procedures and change management.
• Strong in Datawarehousing concepts Fact table, dimension table, star and snowflakes schema methodologies.
• Experienced in writing oracle Sql queries and Pl/Sql procedures, functions packages, Materialized Views and performance tuning.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, Problem Solving, Communication and Interpersonal skills.
• Experience in working on onsite and offshore delivery model.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1, 8.x, 7.x (Repository Manager, Administration Console, Designer, Workflow Manager, Workflow Monitor,), Power Exchange, Syncsort

RDBMS: Oracle11g / 10g / 9i, SQL Server 2000/2005, DB2, Teradata,Netezza

Operating System: UNIX,AIX Windows NT/2000/XP/7

Job Scheduling Tools: Control-M,Autosys

Languages: SQL, PL/SQL, Unix, perl scripting

Tools: IBM CDC, MS Office, TOAD, Winscp, Putty, Squirrel, File zilla,BMC

Products: IBM CDC(Change Data capture), SVN Subversion, IBM cognos, BMC Remedy,Elementool

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

ETL Developer

Responsibilities:

• Administration of a production Informatica Power Center environment.
• Install and configure Informatica software; Maintain all necessary upgrades and/or patches for the ETL environment, including evaluating patches and upgrades to the current environment
• Administration of a production Informatica Power Center environment.
• Install and configure Informatica software; Maintain all necessary upgrades and/or patches for the ETL environment, including evaluating patches and upgrades to the current environment
• Migrate objects and performance tune / optimize applications.
• Migrate Informatica Power Center mappings, Workflows, Sessions and Shared Objects
• Code/folder migration from one environment to another as part of release management.
• Setup appropriate ETL administration best practices and procedures.
• Monitors and tunes ETL repository and system for performance improvements.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Define best practices for developers
• Identify and evaluate utilities and tools to assist in basic operations
• Know what types of permissions are needed to run and schedule Workflows.
• Know what permissions are needed to perform various operations with the Workflow Manager.
• Know what permissions are required to make all possible changes to Workflow properties.
• Be familiar with the security permissions for application users.
• Be familiar with the meaning of the various user types for an Informatica system.
• Know the basic steps for creating and configuring application users.
• Understand how user security affects folder operations.
• Know what passwords are needed to install new client software.
• Should be able to provide on-call support, as needed
• Ability to perform root cause analysis, performance monitoring and application related issues.
• Know how to abort or stop a Workflow or Task.
• Know how to use the Workflow Monitor to quickly determine the status of any Workflow or Task
• Understand how and why target rows may be rejected for loading.
• Know the reasons why a Workflow may fail and how these reasons relate to the Workflow properties.

Environment: PowerCenter 8.6.1,9.5.1,PowerExchange 8.6.1,MetaDataManager 8.1.1,DataQuality,DataProfiling,DataValidation(DVO),Solaris10,Teradata TTU 13.0,Oracle 11g,MainFrame DB2,SSIS Packages,Remedy Picasso.

Confidential, Chicago, IL

ETL Administrator

Responsibilities:

• Administration of a production Informatica Power Center environment.
• Install and configure Informatica software; Maintain all necessary upgrades and/or patches for the ETL environment, including evaluating patches and upgrades to the current environment
• Administration of a production Informatica Power Center environment.
• Install and configure Informatica software; Maintain all necessary upgrades and/or patches for the ETL environment, including evaluating patches and upgrades to the current environment
• Migrate objects and performance tune / optimize applications.
• Migrate Informatica Power Center mappings, Workflows, Sessions and Shared Objects
• Code/folder migration from one environment to another as part of release management.
• Setup appropriate ETL administration best practices and procedures.
• Monitors and tunes ETL repository and system for performance improvements.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Define best practices for developers
• Identify and evaluate utilities and tools to assist in basic operations
• Know what types of permissions are needed to run and schedule Workflows.
• Know what permissions are needed to perform various operations with the Workflow Manager.
• Know what permissions are required to make all possible changes to Workflow properties.
• Be familiar with the security permissions for application users.
• Be familiar with the meaning of the various user types for an Informatica system.
• Know the basic steps for creating and configuring application users.
• Understand how user security affects folder operations.
• Know what passwords are needed to install new client software.
• Should be able to provide on-call support, as needed
• Ability to perform root cause analysis, performance monitoring and application related issues.
• Know how to abort or stop a Workflow or Task.
• Know how to use the Workflow Monitor to quickly determine the status of any Workflow or Task
• Understand how and why target rows may be rejected for loading.
• Know the reasons why a Workflow may fail and how these reasons relate to the Workflow properties.

Environment: PowerCenter 8.6.1,9.5.1,PowerExchange 8.6.1,MetaDataManager 8.1.1,DataQuality, Solaris10,,Oracle 11g,MainFrame DB2,XML,BMC Remedy.

Confidential, Chicago, IL

ETL Admin

Responsibilities:

• Informatica Administration Support - Informatica administration support, to make sure Informatica services are up and running 24/7.
• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• On call support for Informatica services.
• Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.
• Support assistance to Informatica developers and advice on their queries.
• Co-ordinate with other support groups in case of planned/un-planned down time.
• Support for annual DR testing.
• Do POC’s for new functionalities being used for first time.
• Prepare RCA for Informatica service failures and follow-up with relevant stake holder if required.
• Create service requests with Informatica support for unknown errors and follow-up.
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.
• Monitoring and adding tables in CDC for RCT and TAP ODS systems using Data mirroring and refresh methods.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Keep tracking of all CI list, maintaining versions and Change requests.

Environment: Informatica 8.6,Oracle 10g,SQL server 2008,IBM CDC,SAP BOXIR3,BMC remedy,control-m

Confidential

ETL Admin

Responsibilities:

• Informatica administration support, to make sure Informatica services are up and running 24/7.
• Migrate objects and performance tune / optimize applications.
• Migrate Informatica Power Center mappings, Workflows, Sessions and Shared Objects
• Code/folder migration from one environment to another as part of release management.
• Informatica administration support, to make sure Informatica services are up and running 24/7.
• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• On call support for Informatica services.
• Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.
• Support assistance to Informatica developers and advice on their queries.
• Co-ordinate with other support groups in case of planned/un-planned down time.
• Authored Specifications documents for several extracts along with the team members.
• Responsible for monitoring all the sessions that are scheduled for run, investigation of failed session and debugging the corresponding mappings
• Created sessions using Informatica power centre workflow manager.
• Involved in Unit Testing and prepared Test Cases
• Worked on SQL performance tuning to fix slow running informtica Wfs.

Environment: Informatica 8.6,TeradataV2R5

Confidential

ETL Developer

Responsibilities:

• Migrate objects and performance tune / optimize applications.
• Migrate Informatica Power Center mappings, Workflows, Sessions and Shared Objects
• Code/folder migration from one environment to another as part of release management.
• Developed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations.
• Created different transformations for loading the data into stage and main schemas of oracle database using Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Created data flow diagrams which helped the DQ team to prepare data lineage from source to target systems.
• Authored Specifications documents for several extracts along with the team members. Preparation of Unit Test Case and unit testing
• Keep track of status of ETL jobs responsible for Cognos/BO report data.
• Preparation of low level design document

Environment: Informatica 7.x,ERWIN4.0,cognos8,BO5.x,oracle 10g,control-M

Confidential

 Jr ETL Analyst

Responsibilities:

• Analysis of the specifications provided by the clients and Understanding source system
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Using designer to create source definitions, design targets, create mappings, sessions and developing transformations and created data maps in power exchange navigator
• Created different transformations for loading the data into oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Implemented SCD type 2 mappings.
• Responsible for monitoring all the sessions that are scheduled and re running the failed sessions after debug the Mapping
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility
• Involved in Unit Testing and prepared Test Case
• Involved in Performance tuning and testing at mapping level.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.