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 indocumenting 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 dependencieswere 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,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

Confidential, CA

Informatica Developer

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 Targetmapping document and source file workbook document to develop Informatica workflow mappings
• Prepared Technical Design, Production Support Doc, DeploymentDocuments
• 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 paralleldevelopment 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 Assistantto 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, WindowsCA 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 targetdefinitions, 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,TWSToad, ER-Studio, UNIX,Autosys.