SUMMARY

• 8+ years of IT Experience in analysis, design, development, implementation, troubleshooting and Maintenance of Data Mart / Data Warehouse applications using ETL tool Informatica power center 8.6/9.1/9.5.
• Expertise in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling.
• 4+ years of experience with Teradata and PL/SQL
• Very Strong experience in loading data from various data sources and legacy systems into TeradataV2R6 data warehouse using Teradata Utilities FAST EXPORT, MULTI LOAD and FAST LOAD.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Have clear understanding of Data warehousing concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Experience working with databases like Oracle 11G/ Teradata V2R6/ SQL Server 2008.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, and coming up with data load strategies.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Informatica Repository and preparing batches for the existing sessions to facilitate scheduling of multiple sessions.
• Designed and developed ETL Architecture to load data from various sources like Oracle,Flat files into Oracle, SQL server targets.
• Experienced in various data sources like Fixed Width and Delimited Flat Files.
• Excellent Analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Have strong inclination to get my career on the fast track by learning and implement new technologies.
• Ability to function both in a team environment as well as individual capacity.

TECHNICAL SKILLS

Languages: C,C++, PL/SQL,SQL,Java,.Net

Operating System: Windows 2008,XP,Red Hat Linux 9,AIX

RDBMS and Tools: Oracle8i/9i/10g/11g,SQL Server 2005/2008,MS SQL server 2008,Teradata, and DB2GreenPlum database,ODS

ETL: InformaticaPowerCenter 8.6/9.1/9.5. 1,InformaticaDesigner,WorkFlow manager,Workflow monitor, Informatica DQ.

Data Analysis: Requirement Analysis, Business Analysis, data definition table, Business Rules, data modeling, Data Warehousing, DataMart,system integration.

GUI: SQL Developer,Toad

Dimensional Data Modelling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension Tables.

Scheduling tools: Auto Sys, IBM Tivoli, Corn Tab, Control-M, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Data Warehouse Analyst/ETL Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Involved in Data Profiling and Data cleansing process.
• Responsible for determining the Mapping bottlenecks with Informatica and fixing the issues by tuning the Mappings for better performance.
• Worked on Teradata database to load the data in to from Source system.
• Work with different source systems like Oracle, DB2
• Coordinate production change requests and production releases.
• Troubleshooting load failure issues and data quality issues on a day to day basis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Using SQL Maintained and enhance the existing data warehouse, exports, and reports.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Created Adhoc reports using business objects.
• Maintain documents for all the Development work done and error fixings performed.
• Involved in deploying and redesigning of several ETL processes for the existing research line of business
• Worked on writing codes for languages such as C
• Responsible for Best Practices like naming conventions, and Performance Tuning.
• Developed Reusable Transformations and Reusable Mapplets.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Experience in increasing data accuracy using IDQ
• Responsible for providing consistent and reusable data with IDQ
• Worked with ODS to integrate data from different data sources
• Worked with Greenplum database parallel query optimizer to convert query into physical execution plan
• Involved in taking Knowledge Transfer from a different vendor before two weeks of Go Live and handled different performance issues affectively.
• Coordinate with Offshore team on daily basis to handle production support issues and get daily updates from the team on the development work.
• Worked with datamart access layer of the dataware house that is used to get data out to the users
• Experience in integration of heterogeneous data sources like DB2, SQL Server and into Staging Area.

Environment: Informatica Power Center9.5.1/9.1,(Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer,, Power Exchange 9.5.1,Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer),Business objects, Greenplum,Oracle 11g,SQLServer 2008,Teradata 14.1,PL/SQL, AutoSys, Toad, Unix(AIX)

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Migrated Data from Sales force to Oracle using Informatica.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Worked with PL/SQL for procedures and functions.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support. loading data from various data sources and legacy systems into TeradataV2R6 data warehouse using Teradata Utilities FAST EXPORT, MULTI LOAD and FAST LOAD
• Responsible for providing clean, high quality data regardless of size using IDQ
• Worked with ODS for resolving redundancy and checking against redundancy
• Worked with greenplum for global query planning approach
• Worked with datamart for security to separate an authorized data subset
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.1, Oracle 10g/11g, Sales Force,Flat Files, XML Files, PL/SQL, TOAD for Oracle,DB2 1.6, Business Objects XIR3.1,Greenplum db,Tidal, MS Visio, and Windows 2000.

Confidential, New York, NY

Informatica Consultant

Responsibilities:

• Responsible for developing several complex mappings for processing the feeds, re-defined existing process to accommodate batch schedule-using Worklets and developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Implementation of best practice integration methods based on Informatica framework.
• Responsible for the Design, Analysis & implementation of the Interface Gateway for a global gateway process to handle multiple feeds from several different regions of Confidential Europe, Asia-Pac rim, Australia & North America.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to in corporate them as shortcuts, which would be used in several mappings.
• Tested the feeds regarding the functionality and Performance manually.
• Validated the feed processing in different stages like File Watcher conditions, PRE ETL, ETL, POST ETL and Oracle Apps Import/Post processes.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Created parameter files in Informatica and passed them to Informatica Tasks.
• Executed Informatica Workflows individually and validated the data.
• Execution of Test plan, Implementation Plans & identified areas for process improvement of workflows, mappings in Informatica.

Environment: Informatica Power Center 9.1,, Oracle10g/9i, Flat files, PL/SQL, Toad v9.1, SQL Developer, ERWIN 7.2, Mercury Quality Center, MS Visio, Windows Server 2003, Windows XP.

Confidential, NJ

ETL Developer

Responsibilities:

• Develop Mappings (End to End), Re-usable Transformations/Mapplets/Worklets using Informatica 8 Transformations’ and Work Extensively with Informatica 8 session & workflows.
• Perform custom analysis of existing software systems, and design of software to automate the various Business functions
• Support Software engineering efforts through development of Business, User and Dataflow process Diagrams and documents utilizing Software Tools.
• Perform Requirements Elicitation, Analysis and Documentation for detailed Functional and Technical specifications
• Support defect resolution and perform change management by updating Technical system specification documentation, this will require analysis of existing software systems, and designing and implement testing for existing and new software systems.
• Gather Requirements, Perform Impact Analysis and Create the functional and Technical documentation for ETL process for Real time data process.
• Used Greenplum database for broadcast motion and automatic parallelization of dataloading and queries
• Work closely with business users and involve in designing, developing high complexity mappings.
• Enhance the ETL Process data-warehouse performance by using session partitions, Tuning Source/Target/Transformations/Mappings/Sessions
• Worked with ODS for checking against integrity
• Work with different source systems like Oracle, DB2 and Falt files.

Environment: Informatica Power Center 8.6.1, Power Exchange,Greenplum, Oracle 10g, SQL, PL/SQL, AIX/DB2, Toad, UNIX HP/ Linux and Win XP.

Confidential

Developer

Responsibilities:

• Work as a developer for Data Migration.
• Understand the mapping rules defined by the design team
• Performing calculations and validations on the source data.
• Developing PL/SQL Procedures for Testing the Migrated data.
• Key Developer in the project
• Have been a part of all the phases of the project from Requirements Analysis to Production Support
• Working on Analysis, ETL development on Informatica
• Handled Unit & Integration Testing
• Fixing bugs and implementation of enhancement as part of production support

Environment: Informatica Power Center 8.1, Oracle 9i, Flat Files, PL/SQL, DB2, Quest Central for DB2, Business Objects 6.5, Talend, MS Visio, ERWIN tool, AQT, Windows 2000, UNIX