SUMMARY:

• Around 7 years of IT experience in Informatica Data Analysis, Design and Development for various software applications in client - server, N-tier environment
• Strong Knowledge and experience in SDLC methodologies like waterfall and iterative methodologies
• Experience in various phases of data warehouse development lifecycle, including gathering requirements to design, development, testing
• Extensively worked with Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager
• Good understanding in Informatica Administration like Repository set-up, Domain configuration, User management, etc.
• Experience in Creating the Data Mart using the Flat file sources
• Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets
• Experience working with various relational datasources like Oracle, DB2,Green Plum and SQL Server
• Experience in implementing the complex business rules by re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings
• Experience in documenting High level design and Low level design documents for the ETL solution
• Involved in indentifying the bottle necks and performance tuning of Informatica Mappings, Sessions
• Created and updated the job schedules as and when new jobs were added and dependencies were updated in the scheduling tool
• Excellent problem solving skills with strong technical background, quick learner and excellent team player with great interpersonal skills and ability to meet tight deadlines under high pressure

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center(Power Center Designer, Workflow Manager, Work flow Monitor, Repository Manager),Data Stage,SQL Server Integration Services(SSIS)

Data Base: Oracle, Teradata, Greenplum, DB2, MS SQL Server

Scheduling Tools: Autosys,Maestro,CA workload Automation

Operating Systems: Windows,Unix,Linux

Data Base Tools: Toad, SQL Developer, Teradata SQL Assistant, DB Visualizer

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, CA

Responsibilities:

• Participated in business requirement review meetings with BA’s, Solution Architect and users
• Involved in developing complex Informatica mappings using transformations like, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter,Router, Joiner, SQL Transformation etc
• Developed Informatica mappings for TYPE 1, 2 Slowly Changing Dimensions
• Used Star Schema approach for designing of database for the data warehouse
• Involved in developing mappings to load data from Flat files which includes fixed width files, Delimited files and also the relational database
• Involved in Configuring sessions for incremental aggregation, pipe-line partitioning etc.
• Created Sessions, Reusable Worklets, Reusable mapplets and workflows in Workflow Manager and Scheduled workflows and sessions
• Involved in troubleshooting the load failures and Performance tuning by determining bottlenecks in sources, mappings and sessions
• Involved in identify the relationship between tables according to the requirements
• Analyzed the  transformation logic as per the Source to Target mapping document and source file workbook document to develop Informatica workflow mappings
• Prepared Technical Design, Production Support Doc, Deployment Documents
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations
• Used TOAD to run SQL queries and validate the data in warehouse
• Involved in Unit testing and providing support to the QA for testing the target data against the source data
• Worked in Agile environment for rapidly changing or highly emergent requirements and following parallel development and testing

Environment: Informatica PowerCenter,Oracle 11g,Greenplum, Toad,Windows,Jira, Maestro.

Confidential, Hartford, CT

ETL/ Informatica Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets
• Created Design Specification Documents including source to target mappings
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
• Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files
• Designed and developed complex mappings using various transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more
• Created and scheduled Sessions, Jobs based on on-demand using Workflow Manager
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
• Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues
• Used SQL tools like Teradata SQL Assistant to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse
• Provided 24x7 production support for business users and documented problems and solutions for running the workflows

Environment: Informatica PowerCenter 9.0.1, Teradata, MS SQL Server, Flat Files,UNIX, Windows, CA workload Automation.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in requirements gathering and analysis for the entire application
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Used Star Schema approach for designing of database for the data warehouse
• Involved in complete SDLC of the application
• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets, dynamic lookups and reusable transformations in ETL maps
• ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
• Performed Database/ETL migrations from Dev environment to Test/Training/UAT/Staging and PROD environments

Environment: Informatica, Power Center, Oracle 9i, PL/SQL Developer,TWS Toad, ER-Studio, UNIX,Autosys.