SUMMARY:

• 8+ years of professional IT experience in database development and data warehousing.
• Expertise in ETL Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica 9.x/8.x/7.x (Designer, Repository Manager, Workflow Manager and Work Flow Monitor).
• Experienced in integration of various data sources like Oracle 11g,10g/9i/8i,Teradata, MS SQL Server 2005/2000, XML files, DB2, Flat files, XML, SQL, PL/SQL, Erwin 4.0/3.5, SQL Developer, TOAD, Stored procedures, heterogeneous sources into staging area and different target databases.
• Knowledge about Informatica Data Quality, Informatica MDM and Informatica Power exchange
• Extensive experience in Data Warehousing with OLTP and OLAP.
• Experienced in developing logical and physical models and implementing them in Oracle.
• Experienced in creating entity relational and dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables).
• Experienced in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica PowerCenter.
• Strong data modeling experience using Star/Snowflake schemas, Re - engineering, Dimensional Data modeling, Fact and Dimension tables, Physical and logical data modeling.
• Experienced in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as AutoSys and Control-M.
• Experienced in the development, modification and testing of Unix Shell scripts.
• Experienced in Performance Tuning, identifying and resolving performance bottlenecks at various levels Performance tuning at Mapping, Session and database level.
• Advanced knowledge of Oracle PL/SQL programming, stored procedures and functions, cursors and tuning the SQL query.
• Experienced in the Development, Implementation of Database/Data Warehousing /Client/Server /Legacy applications and implementation of various Mainframe and Informatica applications for using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Performed Testing at various levels including Unit Testing, UAT.
• Experienced in Automotive, healthcare, petroleum, networking and entertainment industry.
• Outstanding communication and interpersonal skills, ability to learn quickly grasp new concepts, both technical and business related and utilize as needed. Active participation in Knowledge Transfer and Documentation.

TECHNICAL SKILLS:

ETL Informatica: Informatica PowerCenter 9.6.1/8.x/7.x, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor

Data Modeling Tools: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 10g/11g/9i, MS SQL 200x, MS SQL Server 2012/2008/2005/7.0 , DB2, Teradata V13

Languages: SQL, PL/SQL, Unix, XML Files, Flat files, Stored Procedure, C, C++

Operating Systems: Windows 7/95/98/XP, Unix, Linux

Application Tools: MS Office (Word, Excel, PowerPoint), HTML,PUTTY,JIRA, WINSCP

Scheduling Tools: AutoSys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI                

Sr. Informatica Developer

 Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Created Design documents for better understanding of the process.
• Extracted the data from the flat files and RDBMS database into staging area and PSA then populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Test Cases to perform Unit testing.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Created UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

ENVIRONMENT: Informatica PowerCenter 9.6.1, Oracle 11g,TWS,SQL Server 2012, PL/SQL, Teradata V13, Toad, ERwin 3.5, Unix, Perl Scripting

Confidential, Detroit, MI

Senior Informatica Developer

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional and Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERwin to identify Fact and Dimension Tables.
• Work extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Use ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Database. Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Develop complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator, Filter, Connected lookup, unconnected lookup and Router transformations.
• Implement slowly changing dimensions type 2 to keep track of historical data.
• Use dynamic lookup cache for slowly changing dimensions.
• Use workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Implement performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Use Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them. Perform unit testing and system testing.
• Perform Database end tuning using Explain Plan and analyze table queries.

ENVIRONMENT: Informatica PowerCenter 9.6.1/8.6, Oracle 11g, DB2, AutoSys, SQL Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix

Confidential, Houston, TX

ETL Informatica Developer

Responsibilities:

• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extracted data from Oracle, SQL Server database tables and flat files.
• Created Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Implementing performance tuning the objects to increase the Performance of the loads.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.
• Developed shell scripts in Unix to automate jobs in DEV and QA.
• Worked with various active and passive transformations in Informatica PowerCenter.
• Understood of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Worked with Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique.
• Worked with re-usable objects like Re-Usable Transformation and Mapplets.
• Worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Involved in unit testing and writing simple test scripts and eliminating the bottlenecks for optimum performance.
• Involved in error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed Unix shell scripts to run the workflows and automated the scripts to run daily loads using Control-M scheduler.
• Worked with the Debugger for handling the data errors in the mapping designer.
• Involved in bug fixes for production issues.

ENVIRONMENT: Informatica PowerCenter 9.1, Oracle 11g, SQL Server 2005, Flat Files, Control-M, PL/SQL, Rapid SQL, Quality Center, Unix, Linux

Confidential, Orlando, FL

Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager. Responsible for extracting data from Oracle and Flat files. Responsible for Performance Tuning in Informatica PowerCenter.
• Worked with both Connected and Un-Connected Lookups.
• Made use of sorted input option for the performance tuning of aggregator transformation.
• Used SQL Override function in Source Qualifier Transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Imported various heterogeneous files using Informatica PowerCenter Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases. Implemented various Performance Tuning techniques.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team Peer reviews.

ENVIRONMENT: Informatica PowerCenter 9.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL, PL/SQL, Flat Files, Star Team

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Created events and various tasks in the work flows using workflow manager.
• Tuned ETL procedures to optimize load and query Performance.
• Set up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler. Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Took part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix.
• Migrated Informatica Objects using Deployment groups.
• Troubleshot issues in Test and Prod. Did impact analysis and fixed the issues.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

ENVIRONMENT: Informatica PowerCenter 8.6.0/8.6.1 , Informatica Power Exchange 8.1, Stored procedures, Pl/SQL, Informatica Data Quality, Unix (Solaris), HP Quality Center

Confidential

Programmer Analyst

Responsibilities:

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Used Informatica Designer tools to design the source definition, target definition and transformations to build mappings.
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identified various Data Sources and Development Environment.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Designed and developed data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Created different transformations for loading the data into target database using Aggregator, Upgrade strategy, Router, Rank, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Normalizer, Joiner, etc.
• Developed joiner transformation for extracting data from multiple sources.
• Designed and developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

ENVIRONMENT: Informatica PowerCenter 8.6.1/7.x, Informatica Power Exchange 8.x, MSSQL Server 2005/2008, PL/SQL, Stored Procedures, Informatica Data Quality, Unix (Solaris), HP Quality Center