SUMMARY

• Over 7+ years of total IT experience and technical proficiency in building Data warehouses, Data Marts, Data Integration and ETL Processes for clients in major industry sectors like Health, Insurance, and Retail.
• Over 6 years of strong Data Warehousing ETL experience of using Informatica 9.5.1/9.1.0/8.6.1 - Power Center Client tools - Designer, Repository manager, Workflow manager/monitor.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2000/2005/2008 , DB2 8.0/7.0, MS Access and Teradata.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using TSQL and Oracle PL/SQL.
• Good working knowledge of various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformations.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Strong analytical, problem-solving and organizational skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/9.1.0/8.6.1 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager)

RDBMS: Oracle 11g/10g/9i/8i, MS-SQL Server 2008/2005/2000 , MS-Access and Teradata 12.0/13.0/14.0

Tools: TOAD, MS VISUAL STUDIO, SQL *PLUS, AUTOSYS, Control-M

Operating Systems: UNIX (Solaris), Windows XP, Windows 7

Programming Languages: UNIX, Shell Scripts, SQL, PL/SQL, T-SQL, XML, VB, and ASP.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Collected the mapping documents from the data architect and studied the same extensively and fitted the same into the existing frame work.
• Created / updated ETL design documents for all the Informatica components changed.
• Made use of various Informatica source definitions viz. Flat files and Relational sources.
• Made use of various Informatica target definitions viz. relational data base targets.
• Created Informatica transformations/mapplets/mappings/tasks/worklets/workflows using Power Center to load the data from source to stage, stage to persistent, stage to reject and stage to core.
• Made use of various PowerCenter Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Rank, Router, Sequence generator, Union and Update Strategy transformations while creating mapplets/mappings.
• Made use of reusable Informatica transformations, shared sources and targets.
• Created mappings for Type2 slowly changing dimensions (SCD).
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Used Teradata SQL Assistant to work on the database.
• Worked with “pmcmd” command line program to communicate with the Informatica server, to start, stop and schedule workflows.
• During the course of the project, participated in multiple meetings with the client and data architect / ETL architect to propose better strategies for performance improvement and gather new requirements.

Environment: Informatica PowerCenter 9.5.1, Teradata 14.0, Teradata SQL, UNIX shell scripting

Confidential, NY, NY

Informatica Developer

Responsibilities:

• Involved in requirements gathering, analysis, function/technical specifications, development, deploying and testing.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Used Informatica Power Center for migrating data from various OLTP databases to the data mart
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server.
• Created Mappings using Mapping Designer to load data from various sources, Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence generator, Union and Update Strategy transformations.
• Created mapplets using Mapplet Designer and used those Mapplets for reusable business process in development.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Performance tuning of Informatica designer and workflow objects.
• Created pre/post session commands and pre/post session SQLs to perform tasks before and after the sessions.
• Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
• Created UNIX KSH shell scripts to kick off Informatica workflow in batch mode.
• Invoked Informatica using “pmcmd” utility from the UNIX script.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica Power Center 9.1, Oracle 11g, Flat Files, Win7, SQL * Plus, Toad and UNIX

Confidential, Washington, D.C

ETL/Informatica Developer

Responsibilities:

• Involved in business analysis and technical design with business and technical staff to develop requirement document and ETL specifications.
• Developed the detailed database design document which included data dictionary, data estimates, entity relationship (ER) diagrams, dimensional model (Snowflake schema) using Erwin, MS Office and MS Visio
• Extensively Used Informatica Designer as an ETL tool to extract data from legacy source (Mainframe) systems to Target system.
• Extracted data from multiple operational sources for loading into staging area, Data warehouse, Data Marts using SCD's (Type 1 and Type 2) loads. In this process, Informatica is used to implement business rule, transform and load.
• Created ETL Mappings, sessions and workflows using Informatica Power Center to move Data from multiple sources like XML, DB2, SQL Server, and Oracle into a common target such as Data Marts and Enterprise Data warehouses. And used direct and indirect flat files (delimited and fix width,) as a source of data.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure.
• Joiner (all type of joiner), Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart and Enterprise Data Warehouse.
• Extensively used parameter file to pass mapping and session variables, and parameters.
• Tuned performance of sessions and mapping. Identified source and target bottleneck, transformation error, and resolve the problem.
• Involved in Unit testing and System Testing. Created the test case documents for individual mappings and tasks.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys
• Wrote complex SQL queries, Function, Store Procedure using cursor and record data type and trigger in Oracle database.

Environment: Informatica Power Center 9.1, Solaris Server 10, Oracle 10g/11g, DB2, Autosys, Toad.

Confidential, Bloomington, IL

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 system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings/mapplets.
• Used Teradata SQL Assistant to work on the database.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence generator, Union and Update Strategy transformations.
• Created Parameter files and validation scripts.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Created UNIX KSH shell scripts to kick off Informatica workflow in batch mode.
• Invoked Informatica using “pmcmd” utility from the UNIX script.
• Done the end to end to testing with the source system.

Environment: Informatica Power Center 8.6.1, Power Exchange, Informatica, Oracle 10g, SAP BW Flat Files, Teradata, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.1.
• Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica 8.6.1, UNIX shell scripting, Oracle 10g, SQL Programming, MS Excel, SQL *Plus.