SUMMARY

• 7+Years of IT Experience with more than 6years of experience in Designing, Development and Implementation of Data Warehouses & Data marts with Informatica Power Center 9.x/8.x/7.x/6.x as an ETL tool
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server,Teradata and worked on integrating data from flat files like fixed width and delimited and XML files.
• Experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
• Hands on experience in implementing Data Warehouse Methodologies like Star schema, Snow Flake schema, Slowly Changing Dimensions, Change Data Capture and Incremental Aggregation etc.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Expensive expertise in performance tuning in RDBMS sources by implementing complex SQL query over rides in Source qualifier transformation.
• Experience with Informatica B2B Data transformation studio.
• Experience in using UNIX Shell Scripts for automating Batches and Sessions .
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Significant experience in Banking, Retail, Healthcare, Insurance and Telecom sectors.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6/7.1. x/6.2/6.1 (Power Center) B2B DT studio 9.1.0,Power mart 6.2/5.1

Databases: Oracle 11g/10g/9i/8i IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0 , SQL Developer,Toad.

Reporting Tools/Others: Business Objects6.1, Cognos. MicrosoftSQLServer, Analysis Services

Programming Language: SQL,PL/SQL,C, C++, Java, Unix, Shell Scripting.

Operating Systems: Unix,Windows XP/2000/NT 4.0/95.

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

Informatica Developer

Responsibilities:

• Involved in requirement gatherings and analyzing BRDs and worked with system analysts to create source to target documents.
• Analyzed data in source databases before loading into data warehouse and created technical documents according to BRD.
• Created complex mappings using technical documents and loaded data into various data bases.
• Used dynamic cache in lookups and created slowly changing dimensions according to the requirements.
• Developed mappings involving complex business logic using mapping parameters, mapping variables and unconnected lookups SQL overrides, Normalizer, Union etc.,
• Wrote pre and post session SQL scripts while loading data in Oracle data base.
• Identified bottlenecks Confidential mapping level using debugger and resolved them to increase performance.
• Optimized performance of mappings by using appropriate transformations like source qualifier, aggregator, connected lookups etc.,
• Worked with data architects in analyzing loaded data in data base and modified transformation logic if necessary
• Created pre - session and post-session shell scripts and e-mail notifications.
• Optimized Query performance and DTM buffer size, Buffer Block Size to tune session performance
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.
• Performed data validation, reconciliation and error handling in the load process.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Developed and executed test cases for Integration and system testing and documented them along with technical documents.
• Involved in migrating informatica code from 8.6 version to 9.0.1.
• Worked with QA team to to resolve and analyze defects in different tiers.
• Communicated with external vendors to educate them on our data warehouse and provided required documents.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary
• Worked with back end Database Administrators to provide requirements for necessary back end tables.

Environment: Informatica 8.6/8.1/9.0.1 , Teradata SQL Assistant 7.1, Oracle 11g, SQL Server 2008,Windows XP, TOAD for Data Analysis 2.6, Unix, Erwin.

Confidential, Seattle, WA

Informatica developer

Responsibilities:

• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
• Designed Source to Target mappings from primarily Flat files and Oracle using Informatica Power Center.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Used mapper in Informatica Data Transformation studio to create Xml messages using XSDs.
• Responsible for performance tuning for several ETL mappings Confidential mapping and session levels .
• Used transformations like Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, Sequence Generator, Union, XML generator etc. to create mappings.
• Created Unix shell scripts to read and archive files from source directory .
• Designed and developed error handling strategies to re-route bad data.
• Extracted data from oracle database and converted into XML using Xml generator transformation and loaded into JMS Queue.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Used Workflow Manager to schedule and run sessions, as well as to check session logs and other session related activities.
• Worked with migration team and testing team to fix defects in various environments like integration and QA.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Used mapping variables and mapping parameters and created parameter files.
• Participated in code reviews and modified mappings according to the feedback from informatica lead.
• Developed various Adhoc and created Documents using Report Services Documents.
• Worked along withInformatica Knowledge Base to troubleshoot issues.
• Deployed informatica code to Integration,QA and production environments and supported post production issues.
• Documented technical mapping specifications and reviewed them with architects.

Environment: Informatica 8.6, Oracle 11g, B2B Data transformation studio, Teradata, Windows 7

Confidential, Jersey City,NJ

Sr. Informatica Developer

Responsibilities:

• Wrote technical requirements and specifications for the modifications after interacting with customers/end users to obtain the requirements
• Worked with Business Analysts and Data Architects in gathering the requirements and designed the Mapping Specification Documents.
• Prepared technical requirements documents which include both macro-level and micro-level design documents
• Used Erwin data modeler to design the datamarts and also generate the necessary DDL scripts for objects creation for DBA review
• Involved in preparing & documenting Test cases and Test procedures. Involved in developing these for Unit test, Integration Test and System Tests using various Informatica Transformations like Union, Joiner, Expression,Lookup, Aggregate, Filter, Router Normalizer, Update Strategy, etc
• Involved in the performance tuning of Informatica mappings and Reusable transformations and analyze the target based commit interval for optimum session performance
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Used Sequence Generator to create Dimension Keys and Update Strategy to insert records into the target table in staging and Data Mart.
• Used unconnected lookup where different expressions used the same lookup and had multiple targets, which use same logic executed and return one value
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Implemented Slowly Changing Dimensions - Type I,II mappings as per the requirements
• Created error log table to capture the error messages, session load time
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions
• Identifying read/write errors using Workflow and Session logs
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing

Environment: Informatica PowerCenter 8.1/8.6.0, Oracle 9i/10g, Sql server 2005, Toad 9.5, Unix, Erwin 7.x.

Confidential, Madison,WI

Informatica Developer

Responsibilities:

• Interaction with the users/analysts to understand the business of the application, gather requirements and put into technical design documents.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used XML Files, Spreadsheets, Oracle tables as sources and targets.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, XML Transformation, Union Transformation, connected/unconnected Lookups, Update Strategy and Router Transformation to transform and load the data from and to flat files and relational tables.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager. Also created various tasks such as command task, email task, timer tasks, Event wait and Event Raise tasks in the workflow manager.
• Involved in coding Unix scripts to automate multiple ETL Jobs.
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Used Simple Pass Through, Key Range, Round Robin Pipeline along the data transformation pipeline to increase the performance.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Involved in Performance testing the mappings and workflows in production staging before deploying to Production environment.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql Queries.

Environment: Informatica PowerCenter 8.6.0/8.1.1 , UNIX, Oracle 10g, Flat Files, XML Files, SQL and PL/SQLERWIN 4.0, Toad for Oracle10g.

Confidential, Saltlake city,Utah

Informatica Developer & Data Analyst

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules & made recommendations for innovative IT solution
• Involved in analyzing scope of application, defining relationship within & between groups of data, star schema, etc.
• Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
• Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extensively used ETL to load data from wide range of sources such as flat files, and Oracle to XML Documents.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Java Transformation, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Used XML schema to extract data from Oracle, Teradata into XML using Export Option in Informatica.
• Created pre-session and post-session shell scripts and mail-notifications.
• Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Created Workflows containing command, email, session, decision and a wide variety of tasks to load the data into Target database.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Performed Pipeline partitioning to speed up mapping execution time.
• Creating the design and technical specifications for the ETL process of the project.

Environment: Informatica PowerCenter 8.5/7.1, workflow manager, workflow monitor, Oracle 9i/10g,Teradata, XML, PL/SQL Developer, SQL Server 2005, UNIX, Business Objects 6.5, Windows XP, TOAD.

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Analyzed data flow requirements and developed a scalable architecture for staging and loading data and Translated business rules and functionality requirements into ETL procedures.
• Involved in Dimensional modeling of the Data warehouse and used Erwin 4.0 to design the business process, grain, dimensions and measured facts.
• Responsible in designing and introducing new (FACT or Dimension Tables) to the existing Model and decide the granularity of Fact Tables.
• Created necessary Repositories using repository manager to handle the metadata in the ETL process
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Developed and documented data Mappings/Transformations, Audit procedures and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Experienced in Teradata script programming.
• Used Informatica Power Center Workflow Manager to create sessions, worklets to run with the logic embedded in the mappings.
• Involved in scheduling the Informatica jobs and Unix scripts and Oracle procedures.
• Used SQL*Loader for Bulk Loading
• Used the update strategy to effectively migrate data from source to target.
• Responsible to collaborate with DBA and Data Architects on implementation of database changes.
• Assisted in design and maintenance of Metadata environment.
• Interaction with end users, regularly in order to generate the reports required. These reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Involved in the Pipeline Partitioning for Header and Line tables.
• Created Partitions through the session wizard in the Workflow Manager to increase the performance
• Responsible for designing and developing Universes for reporting purposes. Universes were created for post and pre - analysis of the marketing data through in-house Structure Business Objects methodology.
• Involved in designing and developing complex Web Intelligence, Business Intelligence, Client, and Ad Hoc reports for corporate data, which was stored in the Oracle database.

Environment: Informatica Power Center 7.1.4, Business Objects 6.5, Oracle 10g, SQL Server 2005, SQL * Loader, PL/SQL, XML, UNIX 5.8, Shell scripting, Windows NT, SQL * Plus.