SUMMARY

• Around 8+ years of IT experience in the implementation of Data Warehousing applications and database Applications
• Well versed with Data warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center 9.5/8.6/8.1 as an ETL tool.
• Experience in business analysis, data modeling, developing OLAP and OLTP systems solutions for Web Analytics, Retirement Benefits and Financial investment services.
• Comprehensive knowledge of Software Development Life Cycle (SDLC)
• Expert in Analysis, Design and Development of Software Applications and providing Data Integration/Warehousing Solutions
• Extensively used Informatica Power Center (9.5/8.6/8.1) for ETL (Extraction, Transformation and Loading) of data from multiple source systems like Flat Files (txt, CSV), Databases into Data Warehouse.
• Extensively used Informatica Confidential tools: Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager.
• Good command in developing Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica Designer, Workflow manager.
• Good command in Designing/Developing complex mappings using transformations such as: Connected/Unconnected Lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner and Update Strategy, Transaction Control.
• Very good command on Databases such as Oracle 11g/10g/9i/8i, MSSQL Server.
• Worked on configuration management/versioning to migrate updated mappings, sessions and workflows in XML form to Visual Source safe environment. Migrate, Informatica code from one environment to other.
• Developed using optimal processes to accomplish tasks and increase productivity.
• Proficiency in the areas of Access Management, Trouble Shooting and Technical Documentation like Design documents, mapping specification document, Test plans, test cases etc.
• Adept at creating and transforming functional requirements into data Models using - Sybase power designer, Microsoft Visio.

TECHNICAL SKILLS

Data Warehousing/BI Tools: ETL Tools Informatica Power center 9.5/8.6/8.1

Operating Systems: Window 9X/NT/2K/XP, UNIX.

GUI: SQL Loader, TOAD, Winsql.

Databases: Oracle 8x/9i/10g and SQL Server

Other Applications: MS excel, MS project planner, MS Visio, Visual Source safeSharePoint and Sybase Power designer.

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer

Responsibilities:

• Was involved in designing canonical model to create the STAGE and IDS in order to integrate multiple data sources.
• Worked directly with POS application team during the design to understand the data, Confidential cycle and design the warehouse.
• Analyzed the functional specs and created technical specs documents for all the mappings.
• Developed many complex Informatica mappings and workflows.
• Developed slowly changing type 2 dimensional load mappings for historical data.
• Developed complete end to end ETL processes (mappings, sessions and workflows) to process all incoming data through Informatica as per business requirements.
• Performance Tuning of the mappings to handle increasing data volume.
• Created mapping documents based on the design, development and implementation
• Admin for QA repository and responsible for code deployment, scheduling and monitoring of daily jobs.
• Extensively using Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Reviewed complex mappings, Workflows using different transformation, sessions in Informatica and leading the ETL team
• Handled end to end migrations from various databases / versions of Informatica.

Environment: Informatica 9.5, SQL Server, Oracle 10g, Flat files, Unix Scripts.

Confidential

Sr. Informatica Developer

Responsibilities:

• Undeliverable: Record is deemed to be undeliverable due to bad address/email address etc.
• Disposition Received: (mailed, contacted, cancelled etc.)
• Released with no disposition
• Worked directly with applications development, database administration, business analysts, and Confidential areas to implement physical database structure and implement ETL processes.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Prepared Design documents as per the requirements of the Business Analysts and Data model.
• Developed and invoked Unix Embedded PL/SQL scripts for data.
• Created UNIX scripts to call Informatica workflows through Scheduling tool (Control M).
• Developed slowly changing type 2 dimensional load (IDY and UDY) mappings to track, maintain and update Historical customer information along with the current information.
• Developed complex mappings using Informatica Power Center Designer to transform Contact History and Disposition data for business reporting.
• Developed complete end to end ETL processes (mappings, sessions and workflows) to process all incoming data through Informatica as per business requirements.
• Performance Tuning of the mappings to handle increasing data volume.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and maintained traceability in SharePoint and wiki.fmr.com.

Environment: Informatica Power Center 9.1, Oracle 10g, Control M Scheduling tool, Unix Shell Scripts.

Confidential

Sr. Informatica Developer

Responsibilities:

• Gathering requirements and requirement analysis.
• Creation of high level and low level design documents
• Data captured through ETL nearly 2 million records every day from over 700 different weblogs.
• Developed complex mappings using Informatica Power Center Designer to extract Clickstream data i.e. flat files with delimited information from UNIX servers, transformed and loaded into Stage, dimensional and Fact tables using Informatica daily Retail cycle.
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Designed and Developed Informatica Mappings using Informatica 8.6 with Oracle as Target Database
• Performance Tuning of the mappings to handle increasing data volume
• Developed Shell Scripts for retrieving files from FTP server, achieving the source files, Concatenating files and finally to deliver them to extraction location.
• Creation of Unit Test Cases (UTC’s), Unit Test Scripts with captured unit test results
• Reviewed complex mappings, Workflows using different transformation, sessions in Informatica and leading the ETL team
• Execute workflows using CONTROL-M and opdocs and global posts.

Environment: Informatica Power Center 8.6, DB2 8.1/ 9.7, Oracle 10g, Control M Scheduling tool, Unix shell scripts.

Confidential

Sr. Informatica Developer

Responsibilities:

• Prepared the Design documents as per the requirements of the Business Analysts and Data model
• Designed and Developed Informatica Mappings using Informatica 8.6 with Oracle as Target Database
• Performance Tuning of the mappings to handle increasing data volume
• ETL using Snowflake schema architecture and normalized tables
• Worked with oracle table partitions, dynamic cache look-ups, parameter files and various transformations.
• Developed UNIX embedded oracle scripts to create materialized views which provided aggregated metrics for business users.
• Execute workflows using CONTROL-M and opdocs and global posts.
• Developed slowly changing type 2 dimensional load (IDY and UDY) mappings to track, maintain and update customer information on daily basis.
• Implemented workflows to route good, reject, error/bad records from source to facilitate data analysis and upstream data cleansing.
• Reviewed complex mappings, Workflows using different transformation, sessions in Informatica.
• Track and update work progress using Confidential Rational team concert.

Environment: Informatica 8.6, Oracle 10g, UNIX and Control M Scheduling tool.

Confidential

Software Developer

Responsibilities:

• Worked at Offshore & onshore in the Onsite/Offshore Model.
• Prepared the Design documents as per the requirements of the Business Analysts and Data model
• Create stored procedures to calculate Accrued benefits with latest state and federal taxes, DB plan rules Track and update work progress using Confidential Rational team concert.
• Develop Informatica mappings using incremental load and maintaining the most up to date information in all the facts.
• Designed and Developed Informatica Mappings using Informatica 7.1 with SQL server and DB2 as Target Database
• Configure defined benefits Confidential server tool to use the latest calculations.
• Handle adhoc change requests, bug fixes in legacy applications.
• Unit testing and defect prevention.
• Production install support and post install validation.

Environment: Informatica 7.1, SQL Server, DB2 Control M, UNIX