SUMMARY

• 7 years of experience in Data Warehousing and developing strategies for the Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 9.0.1/8.x/ 7.x/6.x and Power Mart 6.2/6.1/5.1.
• Good understanding on Data warehousing concepts, dimensional modeling Star Schema and Snowflakes Schema methodologies.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, Data profiling and ETL Processes for Data Warehouse.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation developer, Workflow Manager, Workflow Monitor and Informatica Repository Manager.
• Worked with different data sources non-relational Databases such as Flat files, XML files and other relational sources such as Oracle, SQL Server.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model) and Data Warehousing (ETL).
• Created complex mappings, reusable mapplets and Transformations applying the business logic.
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from heterogeneous source systems.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks at various levels like source, target, mappings and sessions.
• Extensive experience with Teradata, Oracle, DB2, SQL Server and MS Access databases.
• Sound working knowledge of SQL, PL/SQL including stored packages, procedures, database triggers, SQL programming and SQL*Loader.
• Sound knowledge in UNIX Shell Scripting and Automation of ETL process.
• Created and worked with parameter filesfor sessions and mappings.
• Excellent Analytic and Problem Solving Skills. Highly skilled, motivated team player, outstanding organizational skills, excellent communication and Inter-personal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.x/7.x/6.2,PowerMart 6.2 / 6.1/5.1, OWB, SSIS

Data Modeling Tools: Visio Pro 2003

Development Tools: Rational Rose, MS Visio, TOAD 9.7.2

Methodologies: Ralph Kimball’s Star Schema and Snow flake Schema

Business Intelligence Tools: Cognos Impromptu 7.x/ 6.x, Oracle Reports

RDBMS: Oracle10g/9i/8i, Microsoft SQL server 2005 / 2k /7.0/6.5.

Languages & Scripting: SQL, PL/SQL, UNIX Shell Scripting

Platforms: UNIX, Linux, Windows 2007/2003/2k, Windows XP

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Complex mappings using Unconnected and connected Lookups, and Aggregate and Router transformations for populating target table in efficient manner.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in the work flows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL procedures/Functions to build business rules to load data.
• Working experience in Agile Methodology.
• Created Schema objects like Indexes, Views, and Sequences.
• Performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 9.5, Oracle, Windows server, Batch scripts, PL/SQL, Unix, SQL, DBA

Confidential, Addison-TX

Informatica Developer

Responsibilities:

• Involved in planning and design phase of the Project.
• Worked with business users to gather requirements and worked with team to design the solution.
• Used MS Access and Excel tool to create lookups for planning transformations.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Reusable UDFs to standardize validation and transformation of data.
• Created reusable Mapplets for repetitive transformations.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system Oracle by applying business logic on transformation mapping for inserting and updating records when loaded.
• Created mappings, sessions and workflows to implement the planned logic.
• Participated in Peer review, testing of developed Informatica Objects and created test cases.
• Created table structure in oracle db similar to IEDSS columns.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Performed Unit testing and System testing of Informatica mappings
• Created tables related to mapping used as a source and target in mapping.
• Worked with Oracle DBAs to configure the Database connections.
• Created repository scripts automating export and import of Informatica Objects.
• Created various repository SQLs to pull required information about Informatica Objects.
• Performed performance tuning of created workflows.
• Performed documentation for data validations and user guide for Informatica Jobs.
• Scheduled Informatica Jobs for regular data loading.

Environment: Informatica Power Center 9.5, Oracle, Windows server, Batch scripts, PL/SQL

Confidential - Raleigh, NC

Informatica Developer

Responsibilities:

• Involved in developing Logical and Physical Data Models and creating Star Schema models.
• Analyzed the business and functional requirements and translated them into technical specifications and data rules required for the ETL process.
• Extraction, Transformation and Loading was performed using Informatica Power Center to build data warehouse.
• Interpret the information from various operational sources and external system to create a road map for the design of data acquisition and data propagation.
• Involved extensively in creating different types of transformations like source qualifier, expression, filter, aggregator, joiner, update strategy, lookup, and stored procedure.
• Extensively used Informatica Power Center 9.1(Workflow Manager and Workflow Monitor) for creating and monitoring workflows and sessions.
• Experience in working with SQL Server Integration Services (SSIS).Worked along with the DBA to resolve performance and tuning issues.
• Involved in performance tuning of the mappings and sessions. Determining performance bottlenecks due to source files and transformations.
• Involved in unit integration and user acceptance testing of mappings, mapplets and sessions. Tuning the Informatica Server and Mappings for optimum performance. Testing for the Data integrity and Consistency.
• Documenting the issues related to cleaning of the Data.
• Used PMCMD command to schedule sessions and batches.In charge of converting data using SQL Server using SSIS.
• Tuning of SQL queries for better performance.
• Provided input and recommendations on design/technical issues to project manager/senior managers.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.

Environment: Informatica Power Center 9.1, Oracle 9i, MS SQL Server 2000, DTS, PL/SQL, UML, Unix Shell Scripting on Sun Solaris 2.6.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Interact with the business users and the technical design team to understand the existing design and prepare the strategies for extract, transform and load the data
• Extensively used Informatica to load data from sources, in Oracle, SQL Server, DB2 and Flat files to Oracle data warehouse
• Worked extensively on Power Center client tools like Source Analyzer, Data warehouse designer, Transformation developer, Mapplet designer and Mapping Designer.
• Responsible for developing and maintaining the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Developed complex mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Transaction control, Source qualifier, Update Strategy and XML.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance
• Used dynamic lookup cache to synchronize data between target and lookup cache for better performance.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Fine tuned the mappings for better performance by analyzing the bottlenecks at different levels and eliminating them
• Created mapping parameters to reference values that remain constant throughout a session and mapping variables to write expressions referencing values that change from session to session.
• Used Incremental aggregation to capture new source data and in scenarios where the incremental changes do not significantly change the target so that the Power Center server updates the target incrementally.
• Worked on several complex mappings involving Slowly Changing Dimensions (Type II and Type III) to maintain full and partial history.
• Maintained documentation to describe program development, logic, coding, testing, changes and corrections.
• Created tasks (session, command, assignment, decision, etc.), worklets, workflows and schedule, Run, monitor sessions by using workflow manager and workflow monitor
• Used pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Experience in working with SQL Server Integration Services (SSIS).Worked along with the DBA to resolve performance and tuning issues.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Used PMCMD command to schedule sessions and batches.In charge of converting data using SQL Server using SSIS.
• Involved in writing UNIX shell scripts and automated the workflow using Crontab.
• Performed Unit testing for developed mappings.
• Generated catalogs and reports using Cognos Impromptu and Powerplay
• Generated Pie, bar, Nested Charts and Line displays

Environment: Informatica Power Center 9.1(Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Work Flow Manager), Cognos (Impromptu, Powerplay), 4.1, Oracle 9.0, Sybase IQ, DB2, SQL, PL/SQL,SQL Server2000, Windows NT.

Confidential, GA

ETL Informatica Developer

Responsibilities:

• Interacted with business analyst to understand the business requirements.
• Involved in gathering requirements from business users.
• Created users/groups and folders using repository manager.
• Extensively worked with source analyzer, warehouse designer, transformation designer mapping designer and mapplet designer.
• Extracted source data using Informatica tools and stored procedures from source systems.
• Developed transformation logic and designed various complex mappings and mapplets using the designer.
• Designed various mappings using transformations like Look Up, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Used Mapplets, parameters and variables to implement object orientation techniques and facilitate the reusability of code.
• Used Workflow Manager to create and run batches for different applications.
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Extensively involved in Fine-tuning the Informatica code (mapping and sessions)
• Stored Procedures, SQL to obtain optimal performance and throughput.
• Involved in migration of BO reports and universes.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.

Environment: Informatica Power Center/ Power Mart 8.6, Business Objects 6.0, Oracle 11g/10g/9i, SQL Loader, PL/SQL, DB2, XML, 7.2/4.0, Unix Shell Programming, and Windows NT.

Confidential, Minneapolis

Data warehouse Developer

Responsibilities:

• Worked extensively with Power Center 6.2 to create complex mappings using transformations like aggregators, filters, procedures, Update strategy to develop and feed in Data Warehouse, for creating and monitoring workflows and sessions.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Tuning the Informatica Server and Mappings for optimum performance.
• Created sessions, database connections and batches using Informatica Server Manager.
• Involved in Development and Unit testing of mappings.
• Worked on CDC ETL update mappings of the various data marts.
• Code migration from development to production phase.
• Used Dimensional Modeling Techniques to create Dimension and Fact tables.
• Develop and test all the backend programs, Informatica mappings and update processes.
• Preparing Test cases for the Data integrity and Consistency.
• Involved in troubleshooting the loading failure cases, including database problems
• Designing user-friendly universes and BI reports using Business Objects.

Environment: Informatica Power Center 6.x, Oracle 9i, PL/SQL, TOAD 7.6.