SUMMARY

• Eight years of overall experience in IT Industry with Data warehousing and ETL tools using industry accepted methodologies and procedures.
• Expert knowledge in working with Informatica PowerCenter 9.x/8.x/7.x/ (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Mapping Designer, Transformation Developer, Mapplet Designer, Schedulers and Warehouse Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Extensive experience in supporting Informatica applications, data extraction from heterogeneous sources using informatica Power Center.
• Extensive experience in error handling and problem fixing in Informatica.
• Designed complex Mappings and expertise in Performance Tuning.
• Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.
• Involved in Implementing Slowly Changing Dimensions, Star Join Schema modeling, Snowflake modeling, FACT tables, Dimension tables, denormalization.
• Proficient in using Informatica workflow manager, Workflow monitor, pmcmd (Informatica Command line utility) to create, schedule and control workflows, tasks, and sessions.
• Knowledge of Informatica 6.x / 7.x/8.x in installation and setup.
• Experience in Oracle8i/9i/10g, SQL and DB2 etc
• Extensive Experience in UNIX and Windows Operating system.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages.
• Good knowledge about Pushdown feature of Informatica 8.6.
• Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self - motivated and able to work independently and as a member of a team.
• Excellent communication, analytical and interpersonal skills.
• Quick learner and adaptive to new and challenging technological environments

TECHNICAL SKILLS

Data warehousing Tools: Informatica Power Center 7.x/8.x/9.X, Change Data Capture (CDC)

Databases: Oracle 11g/10g/9i, DB2, MS-SQL SERVER

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT &Dimensionstables

Languages: C, C++, Java, XML

Database Utilities: TOAD 8.0/7.1, SQL*Plus, SQL Developer, PL /SQL

Environment: UNIX, LINUX, Windows 9x/2000/NT/XP/VISTA

Other Tools: MS Visio, Legacy (COBOL ), Control-m, AutoSys

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• Worked in all phases of the Software Development Life Cycle from gathering requirements Phase till implementing the code into production environment.
• Documenting the business requirements by creating the Interface Design Documents and converting them into ETL Technical specifications.
• Reviewing the requirements and working with data architect/modeler for design changes.
• Attending the code reviews developed by the other team members and making the appropriate suggestions to match the business requirements.
• Generated sample data based on the data model design and loaded the data into the database using UNIX shell scripts, which was used both for data analysis and also unit testing purposes.
• Used informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and perform loading.
• Extracted Source definitions from various sources like Oracle and flat files using Informatica tool.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Developed source to target mapping document for ETL development in informatica.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed Informatica mappings and tuned mapping for improving performance.
• Created Complex mapping using various transformations like Expression transformation, Aggregator transformation, LookUp transformation, Joiner transformation, filter transformation, Router transformation, Sorter transformation, Sequence generator transformation, Update Strategy transformation, Stored Procedure transformation and Source qualifier transformation .
• Developed UNIX shell scripts as part of the ETL process to automate the process of loading, archiving data and maintaining the logs for the jobs on UNIX server .
• Worked on creating Unit test case documents for the assigned projects.
• Coordinating with the QA team to ensure that the test case scenarios are met by the design/development standards.
• Implemented efficient and effective performance tuning procedures including pushdown optimization.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 9.5, Flat files, Oracle 11g, TOAD query tool, Sql plus,SQL Server, Unix, Windows 7.

Confidential, SanFrancisco, CA

Informatica Developer

Responsibilities:

• Created and Documented the High level logical Design Documents by using the Business Requirements and also converting them to ETL Technical specifications.
• Used informatica as the ETL for extracting data from the flat files, Relational databases and transforming the data according to the target database and perform loading.
• Worked on creating the Process Flows for each and every layer from staging the data to loading it into EDW.
• Implemented the Pushdown Optimization strategy to balance the load across the Informatica Repository Server and Database Engine.
• Created mappings using various transformations like source qualifier transformation, expression transformation, aggregator transformation, filter, lookup transformation, sorter transformation, joiner transformation, and Update strategy.
• Tuned Performance in informatica mappings/sessions and the bottle necks are removed timely.
• Tuned the SQL queries by partitioning the tables for Performance.
• Worked with the Architecture teams to create the Informatica and UNIX Profiling.
• Worked on Creating the Shell Scripts for informatica jobs and respective process executions.
• Participated in the team code reviews from time to time and ensured the code meet the Business Requirements.
• Worked on creating Unit test case documents for the assigned projects.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Coordinating with the QA team to ensure that the test case scenarios are met by the design/development standards.
• Worked on Data Profiling, analyzed all the Source Tables and respective fields, documented data for validation, completeness and accuracy.
• Worked on Creating and Documented the Data Quality Assessment and Strategies for the source data.
• Worked on Creating the Source to Targets for each and every layer from staging the data to loading the data into Enterprise Data Warehouse.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple systems and loading them to DW.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems and used CDC.
• Provided 24x7 support for the production loads. Troubleshoot the production load problem and provide short term as well as the long term solutions.

Environment: Informatica Power Exchange, Power Center 9.1, Power Connect, Data Profiler and Data Quality, Metadata manager,, DB2, Oracle 10g, SQL Loader, XML, Unix, Win NT, TOAD, COGNOS, Autosys.

Confidential, Oakland, CA

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Analyzed the source data coming from different sources (Oracle, DB2, Flat files) and working with business users and developers to develop the Model.
• Involved in Dimensional modeling to design and develop STAR Schema, using Erwin.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions (SDC), heterogeneous sources and determining the hierarchies in dimensions.
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked extensively on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions.
• Implemented SOA (Service oriented Architecture) using Informatica as ETL tool.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads..
• Implemented efficient and effective performance tuning procedures including pushdown optimization.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Successfully moved Sessions and Batches from the development to production environment.
• Wrote several stored procedures for recycling and other extraction purposes.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Involved in Performance tuning at various levels including Target, Source, Mapping, Session for large data files.
• Designed and Developed UNIX Shell scripts to enhance the functionality of ETL application.
• Redesigned some of the mappings and mapplets in the system to meet new functionality.
• Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.
• Worked on 24/7 on call production support environment weekly on call rotation basis between the Production Support Developers in the team.

Environment: Informatica Power Center 8.6, Oracle 10g, UNIX, SQL Server 2008, Flat files (Sources), XML (Source), TOAD (Query Tool), Erwin 4.1 Data model and PL/SQL.

Confidential

Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensive experience in Design and Developing Informatica Packages for Equity Capital Market.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 7.1, Oracle 9i, XML,UNIX, SQL, PL/SQL, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used informatica power centre for loading the data from sources involving flat files to target as relational table.
• Extracted Source definitions from various sources like Oracle and flat files using Informatica tool.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Mainly involved in ETL developing to Extract, Transform and Load the data into stage area and data mart.
• Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer, and Sequence Generator to develop Data Mart from staging area.
• Involved in designing of star schema based data model with dimensions and facts.
• Created mappings with heterogeneous sources like flat files, MS Access, Oracle databases and created targets in data warehouse using Informatica Power Center.
• Creation of sessions for mapping and validate the session.
• Schedule and monitor the sessions work flows using informatica work flow manager and work flow monitor, daily basis.
• Using Target Load Plan to optimize the performance of the server.
• Identify the bugs in existing mapping by analyzing the data flow.

Environment: Informatica Power center 7.1,Oracle,Unix