EXPERIENCE SUMMARY:

• Over 7+ years of experience in Information Technology with a strong background in Informatica Power Center, SQL,Data Warehousing and Data Modeling.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center 8.6./9.1/9.5/9.6
• Proficiency in using Informatica Power Center tool to design data conversions from wide Variety of source system.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.
• Strong in Data warehousing concepts, Dimensional Star Schema and Snowflakes Schema methodologies.
• Extensively used Flat files to load data from source systems to targets using direct and indirect methods.
• Proficient in understanding business processes requirements and translating them into Technical requirements.
• Extensively worked on Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, update strategy, stored procedure etc. Good experience using on maplets,sortcuts.
• Experience on Teradata 14.0, ORACLE 9i/10g/11g, SQL Server 2005.
• Experience in integration of various data sources like Teradata, Oracle, SQL Server, Flat Files into the data warehouse.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Have performed various testing activities like unit testing, Integration-system Testing and user acceptance testing and ensured that the code is ideal.
• Experience in UNIX Shell Scripting on UNIX & Linux platform.
• Well-developed interpersonal and communication skills.
• Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.6,9.5, 9.1, 8.6 (Work Flow Manager, Repository Manager, Designer)

Data Virtualization: Informatica developer 9.6,9.5

Operating Systems: Windows 7, Windows Vista/XP/2000, UNIX/Linux.

Databases: Oracle 8i/9i/10g, Microsoft SQL Server 2008

Development tools: Toad for Oracle, Teradata SQL Assistance, SQL Developer.

Programming/Languages: SQL, PL/SQL, UNIX shell scripting

PROFESSIONAL EXPERIENCE:

Confidential, Framingham,MA

Sr. Informatica Developer

Environment: Informatica PowerCenter 9.6.1 HotFix 2, Oracle 11g, Teradata, UNIX

Responsibilities:

• Design the physical model and ETL’s to source data from current systems.
• Building the necessary staging tables and worktables on oracle development environment.
• Designed a flexible ETL process to run as Incremental load or Full Load with minimal tweak.
• Developed Mappings, Sessions and Workflows to extract, validate, and transform data according to the business rules.
• Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, Normalizer, Router and Mapplets.
• Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Extensively worked in performance tuning of programs, ETL procedures and processes.
• Worked on data cleansing and standardization using the cleanse functions in Informatica.
• Coordinating with Business Analyst to get the requirement clear and re-solve queries and getting requirements freezed before the development activity starts.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica from various source systems.
• Co-ordinate with the QA team in various testing phases and fix the defects reported by the testing team and coordinate with testing team.
• Coordinate and review SDLC documentation for submission to Quality team.
• Project and Team management, work allocation and status reporting.

Confidential

Informatica Developer

Environment: Informatica PowerCenter 9.6.1 HotFix 2, Oracle 11g, Teradata, UNIX

Responsibilities:

• Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document.
• Analyses data and prepared low level design documents before the development begins
• Developed various Informatica Mappings & Mapplets to load data using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Sequence Generator to load the data into the target tables
• Designed, developed Informatica Power Center 9.5 mappings to extract, transform and load the data into Oracle 11g target tables.
• Based on requirements, developed Source-To-Target mapping document with business rules and also developed ETL Spec documentation.
• Implemented / Developed incremental ETL mappings
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Used Informatica Workflow Manager to schedule workflows and created sequential and parallel loads and used workflow monitor to monitor the load process and trouble shouted the session failure getting log files.
• Created task like session, event wait, event raise, command, decision and control task using workflow manager and monitored the jobs in workflow manager.
• Enhancements to the existing data sources to meet the customer’s requirements.
• Adhered to the ETL best practices and the quality standards described by the client.
• Performance tuning in Informatica Mappings by identifying the bottlenecks and Implemented effective transformation Logic.
• Working closely with business users and technical teams in a customer facing role to bring requirements together into a cohesive design.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.
• Provided data to the reporting team for their daily, weekly and monthly reports.

Confidential

Informatica Developer

Environment: Informatica PowerCenter 9.6.1 HotFix 2, Oracle 11g, Teradata, UNIX

Responsibilities:

• Design the physical model and ETL’s to source data from current systems.
• Building the necessary staging tables and worktables on oracle development environment.
• Designed a flexible ETL process to run as Incremental load or Full Load with minimal tweak.
• Developed Mappings, Sessions and Workflows to extract, validate, and transform data according to the business rules.
• Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalizer, Router and Mapplets.
• Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Extensively worked in performance tuning of programs, ETL procedures and processes.
• Worked on data cleansing and standardization using the cleanse functions in Informatica.
• Coordinating with Business Analyst to get the requirement clear and re-solve queries and getting requirements freezed before the development activity starts.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica from various source systems.
• Co-ordinate with the QA team in various testing phases and fix the defects reported by the testing team and coordinate with testing team.
• Coordinate and review SDLC documentation for submission to Quality team.
• Project and Team management, work allocation and status reporting.

Confidential

InformaticaDeveloper

Environment: Informatica PowerCenter 9.5.1 HotFix 2, Oracle 11g,UNIX

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process.
• 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 workflow.
• Worked with the transformations like Lookup, Joiner, Filter, Aggregator, Source Qualifier, Expression, Update Strategy and Sequence Generator Transformations.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail of the workflow.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Written SQL scripts to transfer the data from operational data sources to the target warehouse.
• Developed PL/SQL procedures, functions, and triggers for processing business logic in the database. Wrote optimized SQL queries for data retrieval from the source database.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Monitoring the session logs to check the progress of the data load.
• Involved in different Team review meetings.

Confidential

Informatica Developer

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Modeled the data warehousing data marts in Star join schema.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.

  Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions

• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.