SUMMARY

• A dynamic professional with around 8 years of experience with wide range of exposure to various Business Solutions with expertise in analysis, design, development and implementation of Data warehouses, data marts and ETL tools with RDBMS like Oracle and UNIX platforms.
• 8 years of working experience with Informatica PowerCenter 6.2.2/7.1.4/8.6.1/9.0.1.
• Advanced knowledge and excellent concepts in development and design of ETL methodology for supporting data transformations and processing ETL solutions.
• Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server, DB2), Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart.
• Worked on ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development solutions.
• Hands on experience on Create, update and maintain project documents including business requirements, functional and non - functional requirements, functional design, data mapping.
• Comprehensive knowledge in Dimension modeling concepts like Star Schemas and Snowflake Schemas.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Expected knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Ensure smooth transition of work to offshore team. Transfer ETL requirements and ensure timely completion of deliverables with offshore.
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the new Telematics capabilities.
• Communicate with business users to collect and understand requirements, socialize ideas among peers, and document work product
• Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
• Excellent communication and interpersonal skills. Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize them as needed.

TECHNICAL SKILLS

Operating Systems: Windows xp/2000/NT/98/95, UNIX, AIX, MS DOC

ETL Tools: Informatica power center 9.0.1/8.6.1 /8.6/7.1.4/6.2

OLAP: Business Objects (BOXIR2) and Cognos

Programming Languages: C++, PL/ SQL, TOAD-SQL, SQL * Plus

RDBMS: Oracle 8,9i,10g,11g. DB2 8.1, SQL Server 2005

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Vis

Other Tools: ERWIN 4.2/4.0/3.5.2 , Toad, SQL * Plus, SQL Developer, SQLNavigator 5.5, Control - M, Autosys, Secure FTP(SSH).

PROFESSIONAL EXPERIENCE

Confidential, Carlsbad, CA

Senior ETL Developer

Responsibilities:

• Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment, and provided production support, Captured requirements from the Business Analysis Team, designed Test Plan, Test Strategy, Test scenarios and executed SIT test cases, reported defects and performed regression testing to ensure minimal UAT/post-production defects.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
• Improved performance by using Explain Plan, Creating appropriate indexes,queries optimization, utilizing table spaces and partitioning schemes.
• Responsible for identifying the missed records in different stages from source to target and resolving the issues.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Creating Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the new Telematics capabilities.
• Ensure smooth transition of work to offshore team. Transfer ETL requirements and ensure timely completion of deliverables with offshore.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Performs quality assurance testing of data integration and report development. Monitors data load operations to ensure accuracy.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.
• Developed shell scripts in UNIX to automate Informatica jobs in dev and QA.
• Coordinate with production support group for automating Informatica jobs through Autosys
• Troubles shoot Informatica performance issues and Handle DQ issues.
• Created Tech specifications based on Business requirements and documented new Implementations.
• Designed complex mappings, mapplets with all set of Transformations and also created Informatica objects(Sessions,Worklets,Workflow).
• Implemented Slowly changing dimensions of Type-One and Two.
• Scheduled Workflows with Informatica scheduler and also with automatic scheduler Control-M.
• Created UNIX shell scripts and Windows batch file to trigger workflows at back end Instead of client tools.
• Performed unit testing on Interfaces at ETL level, with Testers as per testing standards and UAT with Users.
• Working on Production support most of the time to resolve Issues quickly. Used Informatica debugger to trace out Issues in mappings.
• Created documentation to trace out new design techniques easily. Co-ordinate with offshore team with tasks assigning, requirement sharing.
• Created Parameter files for Interfaces. Used various timer tasks, file watchers, file placers, Event wait, Event rise, Control and command tasks to design Workflows and keeping dependencies on multiple workflows.

Environment: Informatica Power Center 9.0.1/8.6.1 , Oracle 10g, PL/SQL,TOAD, Flat Files, Windows XP, Unix, Sun Solaris 2.6, F-Secure, SSH Client

Confidential, MO

Informatica Developer

Responsibilities:

• Worked with Business analysts to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Involved in the Design and implementation of Physical and logical Data warehouse models and OLAP solutions.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Developer.
• Used Informatica an ETL tool to extract data from source systems to target systems. Source systems are mainly Oracle, flat files and XML.
• Developed several mappings using transformations like Expression, Joiner, Update strategy, Aggregator, Filter, Lookup.
• Mapplets and reusable transformations were used to prevent redundancy of transformation usage and maintainability.
• Performed constraint based loading and checking target table before inserting rows to avoid primary key violation.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Troubleshoot problems by checking session and error logs. Also used debugger for complex problem troubleshooting.
• Responsible for testing and validating theInformaticamappings against the pre-defined ETL design standards.
• Created various tasks like sessions, decision, timer control to design the workflows based on dependencies.

Environment: Informatica Power Center 8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 9i, Erwin, UNIX, Windows 2000, SQL Developer, Toad.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Involved in the analysis, design and development of all the interfaces using Informatica Powermart tools in interface team and interfaced with all the other tracks for business related issues.
• Performedregression testing ofInformaticamappings & workflows after and upgrade from Power Center v6.1 to v7.1.3
• Created complicated formulae and running totals for business measure calculations.
• Responsible for documenting the data extraction process into a reporting database.
• Provide support for reporting and back up support for data and developing ETL transformation usingInformatica power mart.
• Involved in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Created complexInformatica mappings to load the data mart and monitored them.
• The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan for loading data correctly into different Target Tables.

Environment: Informatica7.1.1/8.0,DB2, Sybase, XML, Flat files, Oracle 9i/8i, Unix, PL/SQL, Windows NT, Brio 6.0

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• UsingInformatica Designer designed and developed Source Entities for Oracle, SQL Server.
• Involved in Business/Data analyses and gathering the requirements from different user levels of the organization.
• Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables (SQL Server, and Oracle), MS Access.
• Field level validations like Data Cleansing and Data Scrubbing were applied on various Data Sources.
• Good knowledge in shell scripting and using various Unix commands like grep, awk and sed.
• Expertise in using SQL-Loader for loading external data into Oracle Database.
• Extensively usedInformatica Power Center designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Created Mappings using Mapping Designer to transform data extracted from various sources using Transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Worked in creating mapplet for most re-usable logic for error handling.
• Implemented Variables and Parameters in the mapping and parameterized the mappings.
• Used Debugger to validate mappings and also to obtain troubleshooting information about data by inserting Breakpoints.
• UsedInformatica Workflow Manager to test the application and transport the data from Source tables to Target tables and also to Schedule, Run Extraction, Load Process, and Monitored Sessions in Workflow Monitor.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool SQL Developer.

Environment: Informatica Power Center 7.0/7.1, Oracle 9i, SQL Loader, PL/SQL, MS SQL Server 2000, MS Access, UNIX Shell Scripts, Windows NT/98.

Confidential, MA

ETL Developer

Responsibilities:

• Data conversion, gathering business requirements from End Users and Creating Logical Data Models.
• Created repository usingInformatica Repository Manager
• Created reusable transformations usingInformatica Power Mart Transformation Developer.
• Created and edited mapplets usingInformatica Power Mart Mapplet Designer.
• Imported and Exported mappings and mapplets to and from the repository.
• Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process usingInformaticaETL Tool.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Using very often, the Source to Target Field Mapping Report, this contained transformations, expressions and descriptions in a mapping for documentation.
• Creating Transformations, Creating ports, Configuring Ports, Configuring properties and connecting to other transformations.
• Transforming data using the following Informatica Power Mart transformations: Source Qualifier, Normalizer, Expression, Aggregator, Filter, Router, Rank, Update Strategy, Lookup, Stored Procedure, Sequence Generator, and Joiner.
• Designed and coded mappings, which extracted data from existing source systems into the data warehouse.
• Making Enhancement and fixes in the Procedures, Packages, Triggers.

Environment: InformaticaPower Center 6.2, Business Objects 6.0, SQL, Oracle 9i and Win NT.

Confidential

Database Developer

Responsibilities:

• Involved in various stages of Data warehousing designing mainly on dimensional modeling, physical design, performance tuning, aggregation, indexing and partitioning.
• Understanding the Business rules completely and implemented data transformation methodologies.
• Involved in designing the ETL specification documents (Mapping documents).
• Designed mappings with SCD type2 to keep track of historical data.
• Performed ETL process on data stored in OLAP DB, XML file, HTML, Flat files to DB2 for ODS and EDW using power center 6.1.
• Identifying bottlenecks at mapping level and session level to improve the load performance.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Involved in tuning the mappings and SQL Query to perform maximum efficiency.
• Atomized Workless and Session schedule using Unix Shell scripts.
• Wrote pre-session shell scripts to check session model (enable/disable) before running/scheduling batches.
• Scheduling the session tasks comprising of different mappings for data conversion and extraction in order to load data into target database.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Tuned performance ofInformaticasession for large data files by increasing block size, data cache size and target based commit interval.
• Monitor; troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.

Environment: Power Center 6.x, DB2, Sun Solaris 8, Sun Spark, Oracle 8i, MS Access, PL/SQL, Shell Scripting.