PROFESSIONAL SUMMARY:

• Around 8 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the corporate ETL business technology solutions using Informatica Power Center 9.5/9.1/8.6/8.1/7.x/6.x
• Extensive experience in Information Technology with background of Data warehousing project life cycle such as Client-Server environment, Dimensional Modeling, ETL Development and Business Intelligence.
• Expertise in developing scalable enterprise applications to the user needs which serves for Insurance, Manufacturing, Financial, Telecommunications and Market Supply Research Industries.
• Experience in creating entity relational dimensional relational data models with Kimball and Innmon Data warehousing methodologies Star and Snow flake schema architectures, Fact/dimension tables
• Good Experience in Data Mining, Data Profiling and analyzing the data to identify the Business Logic and also to determine facts and Dimensions
• Expertise in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets
• Extensive Experience in implementing Update strategies, Incremental loads and Slowly changing dimensions
• Good Experience in gathering business requirements and preparing ETL Technical specs
• Implemented performance tuning techniques on Targets, Sources, Mappings Sessions
• Experience in integrating data from various sources ranging from Flat files, VSAM, Oracle,DB2 UDB, SQL Server, COBOL and XML
• Involved in creating web service mappings/Real time Mappings using Informatica Power Center to provide real time data services to .NET applications.
• Excellent in Query optimization Techniques, Creating, Replacing modifying database entity models and maintenance
• Expertise in building Data Marts using Informatica Power Center and generating OLAP reports using Business Objects XI/6.5, Cognos application tools Cognos8.0, ReportNet1.1 with Framework Manager, Report Studio, Query Studio and Cognos Connection Portal and Cognos EP series 7.x/6.x
• Hold good working knowledge on Erwin r8.x/r7.x/4.1/3.5.2 Data Modeling tool
• Extensive Database experience using Oracle 11i/10G/9i/8i MS SQL Server 2008/2005/2000 MS Access, DB2, SQL, PL/SQL, Stored Procedures, Packages, Database Triggers, SQL Plus, SQL Loader
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre post session operations
• Excellent communication skills, strong decision making skills, organizational skills, ability to work in a team or individually and ability to pickup new skills quickly

TECHNICAL SKILLS:

Experience:

Sr. ETL/Informatica Developer

Confidential

Roles and Responsibilities:

• Interacted with business representatives, source system developers in correlating business specifications, identifying data sources, Development strategies and for defining Data Extraction Methodologies.
• Analyzed the functional specifications/mapping exercise document provided by the Data Architect, Data Modelers and created technical specification documents, Detail design documents, source to target mapping specifications and Lineage doc for all the mappings.
• Implement and Manage ETL Operations team, initiated best practices to create a knowledge base and all the Operations related reports
• Worked as on call Production support for ETL Operations
• Designed and developed Complex Mapplets/Mappings Workflows for implementing Avaya Finance and HR.
• Implemented Type1 and Type 2 Incremental aggregation complex scenarios using Informatica 9.5.1
• Created mappings by using various transformations like Filter, Expression, SQL transformation, Dynamic Lookup Cache, Sequence Generator, Update Strategy, Joiner, and Router to transform the source data from multiple source systems.
• Performed tuning of mappings, sessions, workflows including partitioning, memory tuning, and cache management.
• Written complex SQL's and edited Informatica SQL override look up override to improve the performance
• Involved in unit testing, system testing integration testing to check the consistency and accuracy of the data in target with respect to different source systems using Quality Center.
• Monitored and troubleshoot workflows, sessions for daily and Monthly extracts from multiple disparate sources across all platforms to the target data warehouse.
• Created UNIX scripts for file validations and back ups
• Played crucial role in adding value to the project by completing the project within budget and time so that maintained the trust of the business users.
• Scheduled the Workflow jobs and performed On call support responsibilities during go live and warranty period

Environment: Informatica 9.5.1, Oracle 11i, Control-M, UNIX, Toad, Erwin, Flat files, Excel files, Quality Center.

ETL/Informatica Developer

Confidential

Roles and Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center.
• Extracted sources from flat-files and load them into Oracle. Used Data Stage for repository submission, file management and access to the end users.
• Worked with Query Manager Tool in Teradata for testing purpose.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.6 tool Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, Transformations, Work Flow Manager Task Developer, Worklets, and Work Flow Designer and Work Flow Monitor.
• Extensively used Informatica to load data from Flat Files, mainframes to Oracle
• Worked on CRM systems for marketing to help the enterprise identify and target potential clients and sales team
• Created reusable transformations and Mapplets and used them in mappings.
• Created Reports using latest version of OBIEE. Worked with oracle data warehouse architecture console
• Used Informatica Power center work flow manager to create sessions, work flows and work-lets to run with the logic embedded in the mappings.
• Fine-tuned Transformations and mappings for better performance.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Created complex mappings and transformations.
• Did Unit Testing and tuned for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Created dimensions and facts in the physical data model.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.

Environment: Informatica 9.1, SQL Server 2008, XML, COBOL, Control-M, UNIX, Toad, Erwin, Flat files, Excel files, XML, Windows 7/XP.

ETL Developer

Confidential

Roles and Responsibilities:

• Extracting the data from source systems and loading into the staging tables and then into Datamart ODS based on the business rules.
• Extensively implemented Informatica CDC mappings using Oracle log miner Power exchange
• Handled huge marketing data while populating data warehouse type 2 mappings
• Applying file checks, Audit Balance Control ABC checks, pre-ABC checks, and Statistical Process Control SPC checks on the data and sending the results to concerned business people for decision making on loading the data into the data warehouse.
• Develop, Design, Lead, Install, Upgrade, Administer, Provide Best Practices and hands on training, and perform Performance Tuning
• Extensively used Informatica designer to create and manipulate source, target definitions, mappings, transformation, and mapplets.
• Used various transformations like Normalizer, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, SQL and Joiner.
• Created reusable sessions and workflows using the workflow manager.
• Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Developed UNIX scripts and SQL scripts to configure the database tables to perform different kinds of checks.
• Developed documentation for the ETL processes.
• Performed duties of a production support personnel such as identifying the cause of failure, rectify the problem or notify appropriate personnel

Environment: Informatica 9.0.1, Oracle 11g, Teradata 13, Control-M, Unix, Toad, Erwin, Flat files, Excel files, XML,Windows 7/XP.

Informatica Developer

Confidential

Roles and Responsibilities:

• Involved in design, development and maintenance of the Application Gathered business requirements and created design documents Created and maintained a several Database objects including tables, Indexes, stored procedures Created Views from extracting data from various tables for Report Generation Involved in the upgrade of Developer 4.5 to Oracle 6 using interactive mode and batch mode Modified PL/SQL code in the forms to adhere the syntax change Developed forms screens to enter customer information Created new stored procedures and modifying the existing ones Worked on improving the Query performances
• Prepared the different test scenarios and tested the SQL queries and stored procedures
• Conducted the Weekly Status meetings to Review/generate reports on the development of the software

Environment: SQL, PL/SQL, Oracle Forms, Oracle 8i, MS Access, Windows NT, UNIX

Informatica Developer Confidential

• Worked with various business users for requirement gathering and analysis
• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model
• Involved in designing of star schema based data model with dimensions and facts
• Worked extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement
• Designed and developed complex mappings using various transformations in Designer to extract the data from relational sources like Oracle, SQL Server, and non-relational source like flat files to perform mappings based on company requirements and load into Oracle tables
• Worked on Informatica repository manager for creating users, groups, assigning Read, write, execute privileges for Users by assigning users to groups, creating folders
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Used different tasks Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control in the workflow
• Worked on Power Exchange CDC option to distill updates from unchanged background data and to deliver them to multiple targets without intermediate queues or staging tables
• Created SCD type 1 type 2 mappings using lookup, Joiner, aggregator, Filter, Update Strategy and Router Transformations
• Created pre-session and post-session shell scripts and mail-notifications
• Used debugger to check the errors in the mappings
• Worked with tools like TOAD to write queries and generate the result
• Managed Change control implementation
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica Power Center 8.1.1 Designer, Workflow Manager, and Workflow Monitor , Solaris, Oracle 9i, Informatica Power Exchange, SQL Server 2005, PL/SQL, Flat files, XML Files, ERwin, TOAD