SUMMARY

• Over 7 years of experience in the IT industry with extensive skill set dedicated to business and System Analysis, Data Modelling, Data warehousing on Client Server and Web - Enabled Systems, which includes Development and Implementation of Data Warehouse applications using ETL tool INFORMATICA.
• Experience in the Implementation of full lifecycle inData warehouse, Operational Data Store(ODS) and BusinessData martswithDimensional modelingtechniquesStar SchemaandSnow flake SchemausingKimballandInmonmethodologies.
• Extensively worked on Repository Manager, Workflow Manager, Workflow Monitor and Designer to develop Mappings, Mapplets, Reusable Transformations, Tasks and Workflows, Worklets to extract, transform and load data.
• Strong Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, VSAM, IBM DB2 UDB, Excel, Oracle, Sybase, MS SQL Server and Teradata.
• Strong Working Experience with various clients ranging from Telecom, Health Care Financial, Life-Sciences (Pharma) related industries.
• Strong knowledge of OBIEE as a Business Intelligence tool and Data Extraction using Informatica as ETL tool.
• Experience in writing PL/SQL Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
• Sound Knowledge and experience in Metadata, Relational Data Modelling and Slowly Changing Dimensions.
• Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using ERwin and ER-Studio.
• Worked in Implementing the Parallel Processing for increasing the performance.
• Experience in scheduling of ETL jobs using Crontab, Control-M.
• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.
• Hands on experience in using complex mappings using Expressions, Joiners, Routers, Lookups, and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
• Good exposure inInformatica MDMwhere data Cleansing, De-duping and Address correction.
• Expertise on tools likeToad, Autosys, and SQL Server Management Studio. Involved in Unit testing, Functional testing and User Acceptance testing on UNIXandWindowsEnvironment.
• Good knowledge in interacting withInformatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, MS Access and Teradata.
• Experienced in root-cause analysis by de-bugging given mappings, mapplets and work flows of given ETL transformations
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.

TECHNICAL SKILLS

ETL tools: Informatica Power center 9.5.1/9.1/8.6/8.1 (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager), Informatica data quality 8.6.1.

Scheduling Tool: Control M, Crontab, Autosys.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, Teradata

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0 , Business Objects XI r2/6.x/5.x.

BI TOOL: Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 , OBIA Apps 7.9.6.3.

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

Operating systems: Windows 2000/07/NT/XP, UNIX (Sun-Solaris, HP/UX), LINUX.

Scripting languages: UNIX Scripting.

Packages: SQL* PLUS, Toad 7.x, SQL Developer

Web technologies: HTML, DHTML

Applications: MS Word, Excel, Outlook, and PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. Informatica Developer

Responsibilities:

• Study business application to understand the clients existing systems and gather requirements accordingly.
• Analyzing business requirement and translating them into Technical details required for development of the project
• Involved in analysis, design and development of ELDM and ABC model.
• Develop informatica mappings, sessions, workflows on Informatica power center 9.5.1
• Developed mappings using transformations like XML parser, normalizer, source qualifier, union, router, aggregator, connected/unconnected lookup, filter, update strategy.
• Used pushdown optimization techniques for better performance.
• Develop and maintain BTEQ scripts.
• Develop and maintain Shell scripts in unix to setup environmental variables and run the informatica jobs with restartability features
• Used the pre and post session commands to call BTEQs
• Worked on type 1 and type 2 SCDs
• Used Teradata loaders (fast load, mload, tpump) to load Teradata tables
• Used Teradata sql assistant to run sql
• Monitoring of applications and scheduled jobs on Maestro scheduling tool
• Resolution of service requests reported by application users
• Provided enhancements to existing functionalities
• Used the debugger to analyse dataflow and fix complex mappings.
• Involved in the release management process to push the code from development to production environment.
• Used Serena dimensions as the tool for release management and version control.
• Interaction with business users for requirement clarification and resolution of problems reported.

Environment: Informatica Power Center 9.5.1, Teradata, Flat files, XML, UNIX, SQL Assistant, Serena Dimensions, HP Service manager, Quality Center.

Confidential, Greensboro, NC

ETL/Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Worked with lead Business analyst to identify the source systems.
• Used Talend Data profiler to do the data profiling.
• Worked with the Data Modeler during the designing of Logical and physical models.
• Worked with client team while designing requirements document.
• Performed Data cleansing and data scrubbing on the source systems.
• Informatica Data Explorer (IDE) was used for data profiling and Informatica Data Quality(IDQ) was used for data quality measurement.
• Implemented transformations on the source systems as per requirements and loaded them into a Landing zone.
• Extensively used ETL Tool Informatica to load data from Flat Files to landing tables in SQL server.
• Worked with the client to perform extensive validation of landing tables.
• Implemented Star schema for this Data Warehouse.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from landing tables to Dimension tables.
• Implemented Slowly Changing Dimensions (SCD-2) for loading the dimension tables.
• Developed mappings to load the data into Fact Tables.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and arranged them in various workflows in the workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment: Informatica - Power Center 9.5.1/9.1, SQL Server 2008 R2, Talend Data Profiler, IDQ, IDE and Windows XP.

Confidential, Irvine, CA

ETL Consultant

Responsibilities:

• Created complex Informatica mappings using various transformations like Aggregator, Stored Procedure, SQL Transformation, Lookups, Normalizer transformation, mapplet, using Informatica designer.
• Customization of OOTB SDE, OOTB SIL mappings as per the requirement
• Worked with different source systems like Oracle, SQL Server, Flat Fles (Delimited, Fixed width)
• Worked on identifying performance bottlenecks and applied Performance tuning at mapping, session, database level to improve ETL load run times.
• Developed UNIX Shell scripts to automate ETL load processes
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Performed Informatica Administrative activities like creating Integration Services,
• Repositories, user accounts, groups, Folder and maintaining them.
• Involved in upgradation of Informatica 8.6 to Informatica 9.1.
• Creating Subject areas, Execution plans and scheduling them in DAC.
• Maintaining and monitoring Full and Incremental loads through DAC on different environments and handling the failures
• Involved in creating ETL test plans, test cases and reviewing with QA team.
• Providing QA support for ETL testing, defect tracking, fixing and played an active role in product rollouts.
• Resolved many production issues relating to code, mapping errors and data issues
• Involved in developing the OBIEE Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects with integrity constraints into Physical Layer using connection pool, developing Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Involved in Reports / Dashboards creation with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Presentation Services.
• Prepared Detail Design Documents, mapping specifications and Run books..
• Meetings with business representatives/users for gathering the reports/dash board requirements.

Environment: Informatica Power Center 9.1/8.6/8.1, Oracle 11g/10g, DAC 10.1.3, OBIEE, UNIX, Windows, XML, SQL, PL/SQL, TOAD, SQL Server 2008

Confidential, St. Louis, MO

Senior Informatica Developer

Responsibilities:

• Configure database and ODBC connectivity to various source/target databases.
• Extracted and Processed data from various sources like Flat Files and Relational Databases.
• Responsible to interact with Informatica Administrators to create and maintain each PowerCenter instance.
• Worked with end users to understand the Business Requirements and Business Rules and Design the specifications accordingly.
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, modifying session properties and partitioning the mapping.
• Improved the Informatica Session performance by introducing the concept of Initial and Incremental sessions, with Incremental workflows not caching the lookup tables.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Worked with Oracle DBA for loading data into reference tables, using Oracle GoldenGate for near-real time Change Data Capture.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables
• Involved in Data model reviews and validated the tables, columns and data types to meet the requirements.
• Creating source and target table definitions using Informatica Designer.
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Documented the workflow dependencies and ordering for Autosys job scheduling process.
• Used Autosys Job Scheduling software for batch Scheduling.
• Interacted with the FA/SME to gather requirements, plan, build, test, deploy, document and apply business rules.
• Assisted data modeler in creating physical and logical models.
• Extensively used Source qualifier, Aggregator, Filter, Joiner, Expression, lookup, Router, Sequence Generator, Update Strategy, Union and SQL transformations to create mappings
• Finalized the loading procedures, defined dependencies among workflows and sessions
• Worked with FAs/SMEs on analyzing various legacy data issues, capturing the error data and the impact of error data on business.
• Worked with the Oracle database Administrator for creating Reference/Mapping tables and loading reference/dummy data, adding/dropping constraints, indexes and columns.
• Involved in Preparation of Unit Test Plans and testing with the same.
• Worked with the Testers in writing Test cases and Validated Test Cases prepared by them.
• Migrated Informatica code from Dev to QA and worked with QA team in fixing the data/code related bugs.
• Documented the complete ETL Process along with the Source-Target Matrix documentation and Performance Issues

Environment: Informatica 8.6.1(Power Center), Repository Manager, Oracle 11g, MS-WORD, Excel, Visio, Toad 10.5, SQL Developer 2.1.1, WinSCP 4.2.8, Oracle GoldenGate 11g, SQL*Plus, Autosys.

Confidential

ETL Developer

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets
• Analyzed application requirements and provided recommended design and Studied the current system to understand the existing data structures
• Participated actively in user meetings and collected requirements from users
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse and used velocity methodology
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-conneted), Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter
• Involved in design and development of ad-hoc data load or business critical code enhancement
• Worked on stored procedures, functions, views. Developed data Mappings between source systems and warehouse components
• Created workflows and tested mappings and workflows in development, test and in Production environment.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules
• Used Debugger to test the mappings and fix the bugs.
• Actively involved in Performance improvements of Mapping and Sessions and fine-tuned all transformations
• Performed Informatica code Migration from Development/ QA/ Production and fixed and solved mapping and workflow problems
• Developed and maintained optimized SQL queries in the Data Warehouse

Environment: Informatica 8.1.1, Unix Scripting, Toad, Oracle 11g, Sql, Pl/sql, Business Objects XI, Data Analyzer