SUMMARY

• Over 7 years of Data Warehousing experience using Informatica Power center 8.0/7.0 (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplet, Transformations), Informatica Power Center 8.0/7.0.
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Analysis, Decision Support System (DSS)
• Excellent command over UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Designing Source Definition, Target Definition and Transformation for building mappings using the Informatica designer tools.
• Involved in identifying bugs and enhancement of existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Developed sessions using Workflow Manager for loading the data into target Database/flat files.
• Worked with various transformations like Aggregator, Joiner, Sequence generator, Lookup, Expression, Router, Filter, Sorter etc to develop Mappings/Mapplets using Informatica PowerCenter Designer. Developed sessions using PowerCenter, Workflow Manager for loading the data into target database.
• Involved in implementing Slowly Changing Dimensions mainly Type1, Type2 and Type3 methodologies.
• Actively involved in the Design and development of the STAR schema data model.
• Worked on Connected and Unconnected Lookups, Router, Expressions, Aggregator, Filter, Sequence Generator, etc.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Flexible, adaptive and project oriented team player with good communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.0/8.0 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations).

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Tables

Programming: UNIX Shell Scripting (Bourne Shell, Korn), SQL.

Platforms: Microsoft Windows 98/NT/2000/XP, Sun Solaris, Linux Red Hat.

Etl tool: Informatica Power Center 9.x/8.6/8.1: OLAP, Star Schema, Snowflake Schema, OLTP.

PROFESSIONAL EXPERIENCE

Confidential, Lake forest, IL

Senior Informatica Developer

Responsibilities:

• Designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Used Informatica tools Designer, Workflow Manager and Workflow Monitor to extract, transform and load the data in to target tables.
• In the first phase getting the data from OLTP and pulling into Operational Data Source (ODS or Staging Area), in the second phase pulling the data from ODS to Dimensional Modeling according to the user requirement. From the first and second phase, reports will be building using OLAP tools.
• Developed complex mappings using slowly changing Dimensions Concept.
• Extensively used mapping parameter/variable for Incremental Loading.
• Written UNIX shell Scripts for getting the data from all systems to Data Warehousing system.
• Implemented source-target mappings, developing migration techniques & processes for multiple source platforms.
• Used various transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Router, Update Strategy etc. to develop the mappings.
• Scheduled and monitored the sessions.
• Designing Source Definition, Target Definition and Transformation for building mappings using the Informatica designer tools.
• Reviewed the business logic and documented the ETL development process.
• Development including Production support. Analyze, design, build, test and implement change requests for certain areas in the production data warehouse.
• Implemented Error handling Mechanisms in Informatica mapping.
• Extensively used Test Director to document test cases and test results.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Analyzed data flow requirements and developed a scalable architecture/plan for staging data/loading data.
• Designed and developed multiple Dimension and Fact tables.
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Wrote documentation to describe program development, logic, testing, changes and corrections.
• Involved in data analysis, design, and development and Production stages of data warehouse environment.
• Developed design documents, technical specifications for mappings and sessions based on user requirements.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly flat files, and relational tables.
• Designed and developed ETL routines, using Informatica Power Center. Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Tuned sources, targets, mappings and sessions to improve the performance.
• Created parameter files and using the mapping parameters in mappings.
• Experienced in using Mapplets, Mapping variables in Informatica mappings.
• Used Update Strategy to effectively migrate data from source system to target Database.
• Interacting with the interface systems involved in the design of the data warehouse solutions.
• Design of the ETL specifications and develop the Informatica mappings according to specification.
• Worked extensively on Informatica PowerCenter tools- Source analyzer, Warehouse Designer, mapping Designer, and Transformation Developer.
• Worked on critical Informatica Mapplets and Worklets for the new system data loadings.
• Used the Debugger to validate the transformations by creating BreakPoints and analyzing the Debug Monitor. Fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Worked on data extraction, transformation, data loading and data conversions.
• Developed number of Complex Informatica Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Data Loads.

Environment: Informatica PowerCenter 9.1/8.6, Power Exchange, Oracle 11/10g, PL/SQL, Business Objects XI R2, Teradata 13.1, Erwin 7.0, Autosys, DB2, UNIX.

Confidential, Washington DC

Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Designed Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Designed Source Definition, Target Definition and Transformation for building mappings using the Informatica designer tools.
• Created unit test plans, test cases and reports on various Bugs while testing the Informatica processes.
• Performed Performance Tuning of sources, targets, transformations, mappings, and sessions.
• Successfully supported production System as post production activity.
• Reviewed the business logic and documented the ETL development process.
• Extensively used parameters, variables and parameter files.
• Implemented Error handling Mechanisms in Informatica mapping.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Used Informatica for migrating data from various OLTP servers/databases. The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Analyzed data flow requirements and developed a saleable architecture/plan for staging data/loading data.

Environment: Informatica Power Center 8.6, Oracle 11g, Erwin - 4.0, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, PL/SQL, SSIS and Sun Solaris UNIX, Windows-XP.

Confidential, MI3

ETL Informatica Developer

Responsibilities:

• Worked with business requirements analyst to identify and understand source systems.
• Created folders and folder permissions in Repository manager.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, Worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Used Workflow monitor to see the workflows running and get the session properties and session log.
• Performed unit testing and documented the unit test plan and its results.
• Tuned sources, targets, mappings and sessions to improve the performance.
• Created parameter files and using the mapping parameters in mappings.

Environment: Informatica Power Center (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10g, Windows XP professional, Toad 8.5, UNIX AIX.

Confidential, Flint, MI

ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with the team to develop ETL procedures that are consistent across all applications and systems.
• Developed data transformation and extract design and strategy.
• Worked on Power Mart Designer client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Creation of Transformations like Sequence generator, Lookup, Joiner, Update strategy and Source qualifier transformations in Informatica Designer.
• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner
• Created Mapplets and used them in different Mappings for maintaining the standards.
• Created events and tasks in the workflows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance
• Created UNIX shell scripting to run the sessions workflow for Informatics mappings.
• Involved in Performance Tuning of Informatics mappings, SQL Query, views etc.
• Used post session commands for sending email to get the status of the session.
• Involved in Unit Testing and write unit test cases for mappings
• Scheduled and monitored the sessions.

Environment: Informatica Power center 8.6/8.1, Oracle10g, SQL Server 2008, Erwin 4.0, UNIX scripting, Business Objects, Toad 8.6.

Confidential

Informatica consultant

Responsibilities:

• Involved in data analysis, design, and development and Production stages of data warehouse environment.
• Involved in designing documents, technical specifications for mappings and sessions based on user requirements.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly flat files, and relational tables.
• Designed and developed ETL routines, using Informatica Power Center. Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Experience in using Mapplets, Mapping variables in Informatica mappings.
• Migrated mappings from Development to Production folders.
• Scheduling the session tasks comprising of different mappings for data conversion and extraction in order to load data into target database.

Environment: Informatica power center 8.6, 8.1, Windows XP and UNIX, Oracle 9i, DB2, SQL Server.