SUMMARY

• 7+ years of experience in analysis, design, development and maintenance in IT industry.
• 6 years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Experienced to work in Development team, Production support and maintenance teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse(EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x .
• Experience in documenting High Level Design, Low level Design, STM’s, Unit test plan, Unit test cases and Deployment documents.
• Experience as an Admin, Extensive Knowledge of Installation, Configuration and Maintenance of Informatica Power Center.
• Responsible for Informatica Production Support 24x7 for internal on-call production support.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Expertise in scheduling Informatica jobs using Informatica, Windows scheduler and with Unix.
• Expertise in creating Unix shell scripts.
• Experienced in working for the post development cycle and applications in Production Support.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x

Data Modeling: Erwin 4.0/3.5, Toad, SQL Station, MS Visio, SQL Developer

DBMS: Oracle 10g/9i/8i, IBM DB2, MS SQL Server 2005/2000, Microsoft Access, Excel, ODBC

Programming Languages: SQL, PL/SQL,T-SQL, Unix Shell scripting

Operating Systems: Windows XP/ 2008/2003/2000/ NT/98/95, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Responsible for Production Support, Provided on-call support by monitoring the processes running daily
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Provided On-Call Production support in Case of Job Failures in Workflows, and Fixing the issues depending on the severity.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Actively involved in production support and maintenance for post-production, Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.

Confidential, West Chester, PA

Sr. Informatica Developer

Responsibilities:

• Provided 24X7 support for Informatica (Production support).
• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Supported production jobs, data enhancements and code fixes.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Provided On-Call Production support in Case of Job Failures in Workflows, and Fixing the issues depending on the severity.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.1.0, Oracle 10g, SQL server 2005, SQL, T-SQL, PL/SQL, Toad, Erwin4.x, Unix.

Confidential, Memphis, TN

Informatica Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETLs for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, Erwin 4.0/3.5.2, TOAD 8.6.1.0, PL/SQL, Flat files, XML, Oracle 10g/9i/.

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.
• Worked with creating Dimensions and Fact tables for the data mart.
• Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.
• Developed mapping using parameters and variables.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center 7.1, Flat files, Oracle 9i, Sql Server 2005, workflow scheduling.

Confidential, Kansas City, MO

ETL Developer

Responsibilities:

• Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
• Documented required technical metadata such as source and target definitions.
• Created technical design specifications for mappings, sessions, workflows, etc.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked with DBA team to fix performance issues at Database.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Worked with export and import utilities in Repository manager.
• Involved in upgrading from Informatica Power Center 6.1 to Informatica Power Center 7.1 which is used as ETL tool for loading data into EDW from transactional databases.

Environment: Informatica Power center 6.1/7.1, Oracle 9i, SQL Server 2000, SQL, PL/SQL, TOAD, Windows NT, Unix.

Confidential, Concord, NH

Informatica Developer

Responsibilities:

• Involved in Relational and Dimensional Data Modeling Techniques to design ERWIN data models.
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Extraction, Transformation and Load was performed using Informatica Power Center to build Data warehouse.
• Accomplished automated data extraction from various RDBMS via UNIX shell scripts, ETL processing using Informatica and loading into Data Mart.
• Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Designed and documented validation rules, error handling and test strategy of ETL process.
• Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks.

Environment: Informatica Power Center 6.1, Windows 98/2000, Oracle 8i, SQL, Shell scripts.

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Created various mappings using Aggregate, Filter, Join, Expression, Lookup, Update Strategy and Router.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Worked with sessions and batches using Server Manager to load data into the target database.
• Testing for Data Integrity and Consistency.

Environment: Informatica Power Center 6.1, Oracle 8i, SQL, Windows NT, Shell scripts.