Professional Summary:

• Informatica: 6 years of Data Warehousing experience using Informatica Power Center 9.0.1/8.6.1/8.1./5.1, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Developer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Developer, and Workflow Designer, OLAP, OLTP, Control M, Strong experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy system files.
• Around 7 years of IT experience in System Analysis, Business Analysis, Database Design, DW Development, Testing, Implementation and Integration of various Data Warehouse Systems and Business Intelligence Applications on Client-Server, SOA and Mainframe environments.
• Established best practice methodologies and documentation standards for ETL work.
• Strong experience on different phases of software development life cycle SDLC including analysis, design, development, testing and maintenance.
• Extensively worked on Informatica Advance Techniques - Dynamic Caching, Memory Management, Parallel Threading to increase Performance throughput.
• Developed, maintained, retrofitted and optimized mappings, batches and sessions for several subject areas.
• Databases:
• Extensively worked on Oracle 10g/9i/8i/7.0DB2 8.0/7.0/6.0, MS SQL Server 2005.
• Experienced in integrating data from various Heterogeneous sources Relational database, SIEBEL, Flat Files, XML Files, COBOL Files, Excel into Data Warehouse and Data Mart.
• Worked on operating systems UNIX, Linux and Windows. And have experience in Informatica and Business Objects Administration and strong experience in installing in windows, Unix environment.
• Unix: Have very good experience in Writing Shell Scripts. Strong testing experience on UNIX based applications.
• Production Support Done extensive 24x7 production support and issue resolutions.
• Offshore Team Co-ordination Onsite-offshore co-ordination experience and well versed with off-shore teams ensuring timely and quality results.
• Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
• Excellent in Documentation, End-User Training, Knowledge Transfer and Production Support.

Technical Skills:

Project Profiles:

Confidential

Sr.ETL Developer

• Involved in gathering requirements and source system analysis and involved in data modeling.
• Designing documenting the functional specs and preparing the technical design.
• Prepared low level design documents establishing mappings between sources and targets.
• Involved in Design Specifications and technical Sessions.
• Extracted data from DB2, flat file, VSAM files and load into the Oracle data base and used Java transformation to load into SOLR web services.
• Developed ETL Mappings, Sessions, and Workflows using various transformations like Update strategy, Lookup, Filter, Router, Joiner, Java etc.,
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Developing several complex mappings in Informatica.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.
• Involved in Initial loads, Incremental loads Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Created the Data flow Diagrams for the full run and the reprocess partial run for the workflows to be created in Informatica taking into point the dependencies using Microsoft Visio.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Extensively worked on the AUTOSYS scheduling tool and created JIL files.
• Involved in production support to make sure all issues are fixed in the respective turn-around times.

Environment: Informatica Power Center 9.1, Oracle11, DB2, Erwin, UNIX, Autosys, SOLR

Confidential

Informatica/ETL Developer

• Involved with the Business analysts in requirements gathering, and business analysis.
• Assist in the design of an efficient reliable ETL mechanism for updating the data warehouse, data marts and downstream systems.
• Involved in preparing the Design Specifications for ETL Coding and mapping standards.
• Analyzed various Source Systems for Implementation.
• Worked Extensively on Informatica tools Repository Manager, Designer and Workflow Manager and Workflow Monitor.
• Designed Source to Target mappings to extract data from heterogeneous sources such as Oracle, Flat files, DB2 as source and load it to the target tables.
• Involved in creating the backup of the repository.
• Worked with various transformations such as Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator, Rank.
• Configured and used the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Performed tuning of Informatica Mappings and sessions for optimum performance.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Developed and worked with SQL and PL/SQL scripts, UNIX script in coordination with pmcmd to start/stop workflows.
• Extensively performed unit testing and coordinate for system testing and functional testing.
• Helped to generate Report using Business Object.

Environment: Informatica PowerCenter 8.6, UNIX Sun Solaris 2.6 , Windows NT, LINUX, Teradata v12, Oracle 10g, DB2 9.5, PL/SQL, Toad, Business Object 5.1, Autosys.

Confidential

Sr. Informatica Developer

• Involved in requirements gathering and analysis for the entire application.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed logical and physical data models that capture current state/future state data elements and data flows.
• Working on Informatica Power Center 8.6 for design and development.
• Used various transformations like Source Qualifier, Aggregators, lookups, Filters, Sequence Generators, Routers, Update strategy, Expression and Sorter etc.
• Extensively working on Informatica Designer, Workflow Manager and workflow Monitor.
• Working on Source Analyzer, Target designer, Mapping Designer Mapplet Designer.
• Created mappings in Mapping Designer and reusable transformations in Transformation Developer.
• Extracted Data from Different Sources by using Informatica.
• Created mappings using slowly changing dimension Types.
• Involved in performance tuning of Sources, mappings, sessions and targets.
• Developed mappings using Informatica Power Center Designer to load data from various source systems to target database.
• Prepared the Unit Test Cases and executed them.
• Designed Logical and Physical Database Star Schema using Reverse Engineering principle with Erwin 4.0 Tool.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.

Environment: Informatica Power Center 8.6, Workflow Manager, Windows XP, Erwin4.0, Oracle 10g, SQL server 2008, XML, Flat Files, Quality Center

Confidential

Data Warehousing Business Intelligence Consultant

Roles:

• Interacted with Users to identify key Dimensions and Measures for Business performance.
• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Created Common objects for the ETL team to maintain the Common Code.
• Identified business rules for data migration and Perform data administration through data models and metadata.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Design mapping document, which is a guideline to ETL Coding.
• Documentation for ETL development process, Installation and troubleshooting guide.
• Documented standards for Ascetical Data stage development and prepared a handbook of standards.
• Developed and documented a handbook of standards for Informatica developers.
• Install Informatica and Oracle on Client windows and Server UNIX for Development, Test and Production Environments and Configuring the Informatica Server.
• Using Data stage designed Mappings that populated the Data into the Target Star Schema, which is on Oracle 9i Instance.
• Used Workflow Manager Server Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time.
• Maintain Development, Test and Production Repositories using Repository Manager.
• Expert in writing Shell Scripts which includes PMCMD to interact with Informatica Server from command mode.
• Report bursting depending upon the user class, the roles and the set privileges for the user.
• Provided training on Query Studio to create Ad-hoc Reports.

Environment: Informatica Power Center 6, MS SQL Server, Oracle9i/8i, PL/SQL, Windows NT/2000, and Unix

Confidential

ETL Developer

• Used Informatica Power Center 8.1.1 for extraction, loading and transformation ETL of data in the data warehouse.
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Extracted data from flat file, RDMS, Legacy AS400, and VSAM files.
• Implemented Informatica recommendations, methodologies and best practices
• Created sessions, workflows and worklets using workflow manager.
• Worked on Informatica Designer to modify mappings to update the existing code resulting from review comments.
• Used Expression, Normalizer, Update strategy transformations.
• Worked on Lookup, Router, Unoin, Joiner Transformations.
• Involved in Unit testing, and running workflows.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked extensively with the business intelligence team to incorporate any changes that they need in the delivered files.

Environment: Informatica 8.1.1, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Oracle 10g, Windows XP, Sun solaris UNIX, DB2.