SUMMARY:

• IT professional with 10 years of experience in the Development and Implementation of Data warehousing with Informatica Power Center, OLTP and OLAP using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Exposure with Installation and Configuring of Informatica tools.
• Experience in Agile and water fall framework.
• Good amount of experience in Autosys Scheduler.
• Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing of Data warehouses using ETL.
• Strong Data warehousing experience using Informatica Power Center 9X/8x/7x.
• Extensively used Informatica tools such as Informatica Server and Client tools like Designer, Workflow manager, Workflow Monitor, Repository Manager.
• Experience in implementing the complex business rules by creating transformations, re - usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings, and SQL Stored Procedure, and Triggers.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp).
• Used Incremental Aggregation to update the values in Summary tables.
• Developed mapping using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Extensive experience in implementing Real time CDC using Informatica Power Center 9.x/8.x/7.x.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experience using Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
• Having command on troubleshooting with the help of error logs generated by Informatica server.
• Extracted data from various sources like Oracle, Flat file, SQL SERVER, XML files, loaded into Oracle database.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Experience with UNIX shell scripting for File validation and SQL programming.
• Practical understanding of Star Schema and Snowflake Schema Methodology.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.
• Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.

TECHNICAL SKILLS:

Tools: Informatica PowerCenter (versions 9x/8x), Visio, Oracle Designer, Rapid SQL and Autosys Scheduling Tool

Operating Systems: UNIX (Sun Solaris, Linux), Windows XP/2000

Databases: Oracle 7, 8, 8i, 9i, 10g database/associated tools/Oracle Enterprise Manager, Microsoft SQL Server, Microsoft Access, Flat file systems, MYSQL, DB2 and Sybase.

Languages: SQL, PL/SQL, UNIX shell scripts, Perl, JavaScript, C, C++

Industries: Healthcare & Insurance

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

ETL/Informatica Developer & Team Lead

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Created Real Time Change Data Capture framework to capture change records at real time then and there which helps consumers to use the real time data without any delay.
• Also Run Continuous option has been enabled to execute the workflow continuously which reads data from source system and load into target system.
• Created Data Map and Registration map for the CDM database tables and setup logger and listener for the same.
• Agile model followed throughout the project.
• Created autosys jobs for client, field and product subject area.
• Created four informatica map per table (Ex - CLT LEGAL ENTITY) which includes initial load map, incremental load map, validation map and delete mapping.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Scheduled Informatica jobs using Autosys Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Implemented Optimization/performance tuning techniques to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
• Debugged and sorted out the errors and problems encountered in the production environment.

Environment: Informatica 9.6, DB2, Sybase, flat files, Windows Vista, UNIX & Linux and autosys.

Confidential, Denver, CO

ETL/Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared Confidential (Technical Design Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created reusable Mapplets transformations to load data from operational data source to Data Warehouse and involved in Capacity Planning and Storage of data.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Developed complex mappings such as Slowly Changing Dimensions Type 2, Type 3, type 1 - Time Stamping in the Mapping Designer.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Used the Target Load Ordering with Stored Procedures to update database.
• Used Variables and Parameters in the mappings to pass the values between sessions.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Implemented Optimization/performance tuning techniques to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.

Environment: Informatica 9.0.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, flat files, Windows XP, UNIX.

Confidential, Woodland Hills, CA

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.

Environment: Informatica 9.0.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, flat files, Windows XP, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mapping, Used Informatica Scheduler
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files (source) and loaded into Oracle (target).
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
• Monitored the workflow performance and the status with Workflow Monitor.
• Developed various command tasks to automate the Pre session jobs. Involved in writing of Triggers, Functions, and Packages.
• Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Scheduled Informatica jobs using Informatica Scheduler.
• Determined various bottle necks and successfully eliminated them to great extent.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings. Monitored the workflow performance and the status with Workflow Monitor.
• Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.

Environment: Informatica 9.0.1/ 8.6, Oracle 11g/10g, MS SQL Server 2008, flat files, Windows XP, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Worked on high level and low level design, coding and testing phase in order to implementation the Test cases and Test Scripts.
• Tested the data and data integrity among various sources and targets.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate test cases.
• Defects identified in testing environment where communicated to the developers using defect tracking tool HP Quality Center