SUMMARY

• More than 7 years of experience in the field of Information Technology with expert knowledge in Database and Data warehousing
• Over 6 years of experience working with ETL Architecture using Informatica Power Center 9.0.1x/8.6.1x/8.5/8.1/7.x
• Proficient in Extraction, Transformation and Loading of data from various sources like Flat files, Cobol, Excel, IMS, XML, DB2, Oracle, SQL Server, Teradata
• Well versed in developing and testing complex mappings, using transformation like Filter, Router, Expression, Aggregator, Connected and Unconnected Lookup, Source Qualifier, Update strategy, Sequence Generator, Normalizer, Rank, Stored Procedure, XML Source Qualifier, Joiner and more
• Expert knowledge in Relational and Dimentional Modelling techniques such as Snowflake Schema, Star Schema, ODS, Fact and Dimensional table and OLAP
• Vast Knowledge in Data Warehouse Development Life Cycle where all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center
• Streamlined in testing data flow by using Debugger and tuning the Data Warehouse which includes Oracle SQL query tuning and Informatica Power center for finding out bottlenecks
• Good knowledge in working with Slowly Changing Dimension (SCD) Management type 1 and 2
• Worked on high volume datasets from various sources like Oracle, SQL Server, Flat Files and XML
• Served as developer on Informatica components that included Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer
• Extensive knowledge in writing, testing and implementation of RDMBS such as SQL, PL/SQL, MYSQL and Sybase Database
• Analyzing business user’s needs, developing expanded data warehouse reporting and ETL routines to support reporting needs
• Involved in the Migration process from Development, Test and Production Environments
• Good knowledge in UNIX Shell Scripting and Autosys for scheduling the Workflows
• Experienced in working with large teams in a Data Warehousing Environment
• Self - motivated, a very quick learner and a good team player
• Good communication skills, learning skills with strong presentation and ability to interact with people at any levels

TECHNICAL SKILLS

ETL Tools/Data Warehousing: Informatica Power Center 9.0.1/8.6.1 /8.5/8.1/7.1 , Data Mart, OLAP, OLTP, Informatica Power exchange 8.x

Languages: SQL, PL/SQL, MY SQL, UNIX Shell Script, XML

Data Modeling: Star Schema, Snowflake Schema, Fact and Dimension Tables, Physical and Logical data Modeling, Erwin 4.0

Environment: Windows NT/2000/Windows XP/Windows Vista/ Windows 7,UNIX, Sun Solaris, MS Visio, MS-DOS

Data Bases: Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, Flat File

Other Tools and Utilities: SQL * Plus, Teradata, SQL Navigator, Autosys, TOAD, MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Mansfield, MA

Senior Informatica Developer

Responsibilities:

• Designed ETL processes by leveraging SQL scripting and Enterprise Data Integration tools
• Extracted structured and unstructured data from source systems, transforming them to fit dimensional models. Data source formats include relational databases, flat files and non-relational structures such as XML
• Assisted with the mapping of processes, monitoring the data and analyzing data sources
• Worked with Client with extensive data integration and transformation
• Used the Power Center tool set to update customer databases, working both independently and within a team environment
• Used various active and passive transformations such as Aggregator, Expression, Router, Filter, Sorter, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement
• Comprehensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Creating/Building and Running Sessions/workflows and worklets using the Workflow Manager/ Workflow Monitor
• Prepared and maintained technical documentation for all new or modified Repository objects and ETL Mapping
• Involved in designing of Star Schema based data model with dimensions and facts
• Participated in designing of new data warehouse tables as per need
• Designed and conducted unit tests for new or changed repository objects and ETL mappings
• Extensive experience in Performance Tuning where I need to Identify and fix bottlenecks and tune the complex Informatica mappings for better Performance
• Responsible for creating staging area through informatica tool
• Briefly worked with CDC (Change Data Capture) using Informatica Power Center
• Executed Slowly Changing Dimension(SCD) Type 1 and Type 2 for inserting and updating Target tables
• Converted Business processes into Informatica mappings for building Data marts
• Monitored and optimized the performance of the ETL routines and environment
• Scheduled the Informatica Jobs through Autosys Scheduling tool
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load
• Performed migration strategies between development, test and production repositories

Environment: Informatica 9.0.1/8.6.1 , SQL server 2008, Oracle 10g, SQL, PL/SQL, SQL Navigator, DB2, Teradata, Erwin, UNIX, Windows XP

Confidential

Senior Informatica Developer

Responsibilities:

• Created mappings using Flat Files and Relational Targets
• Perfomed data analysis, assist data analysts with mapping data from existing systems and helped generate required SDLC documentation
• Assist the Development Lead in developing project plans to ensure Informatica solutions are executed flawlessly
• Worked with logical and physical database designs using model viewers
• Involved in writing the SQL and PL/SQL procedures and program blocks for data extraction, transformation and loading
• Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and Update Strategy Transformations
• Key tasks included source-target analysis, design of source-target mapping specifications, development of Informatica mappings and workflows and end to end testing of interfaces
• Used Lookup Transformation to access datas from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance
• Created and implemented Informatica workflows
• Automation of ETL processes with scheduling tools and exception-handling procedures
• Optimized code performance by analyzing indexes, joins and views
• Involved in Inserting the new records and Expire the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT
• Developed complex mappings also involving Slowly Changing Dimensions (SCD) Type-I and Type II mappings in Informatica to load the data from various sources
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile
• Used tools like TOAD to run SQL queries and validate the data
• Evaluated the performance issues in the datamarts which included analyzing query plans by involving the DBA’s for the SQL override lookups
• Extracted data from various sources like Teradata and relational databases (Oracle)
• Used Debugger to test and track the path of the source data and also to check the errors in mapping
• Worked with fellow employees and client team members in planning, design development of ETL solutions

Environment: Informatica 8.6.1, SQL server 2008, DB2, SQL, PL/SQL, SQL Navigator, Oracle 10g, TOAD, Erwin, Autosys, Teradata, UNIX, Windows XP

Confidential, Wilmington, DE

Informatica ETL Developer

Responsibilities:

• Designed and developed Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker, Joiner, Stored Procedure, Update Strategy and Re-usable transformations
• Created Sessions, Workflows and Worklets for data loads using Workflow Manager
• Involved in designing the technical design of data model and reviewing the physical data model design.
• Created variousTasks, arranged relatedtask in differentworklets, arrangeddifferent worklets in workflowdepending upon their inter dependencies in workflow Manger
• Created and modified Oracle Database tables as per the design needs and applied constraints to maintain complete Referential Integrity and creating indexes for performance and loading the data into Oracle database tables
• Worked with BI team and actively participated in discussion with users for gathering requirements and to provide accrete data for report
• Involved in creating various types of UNIX scripts which helped the ETL scheduling jobs and helped in initial validations of various tasks
• Converted the SQL and PL/SQL Procedures to Informatica mappings
• Created scripts for various database objects related to the data model which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes
• Created in designing of star schema based data model with dimensions and facts
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables
• Held various interactive meetings with different users and business analysts for a clear understanding of the Business needs and to bridge the gap between user needs and tool functionalities

Environment: Informatica Power center 8.6.1, UNIX, Windows XP, Sun Solaris, Informatica Power Exchange, Oracle 9i, Flat Files, SQL/PLSQL, SQL Server 2008

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Used Informatica Powercenter for building the data warehouse and datamarts which focused on the transformations namely Expression, Sequence Generator, Stored Procedures, Filter, Unconnected and Connected Lookup, Aggregator and HTTP transformation
• Debugging of invalid mappings by using break points, testing of Informatica sessions, testing of stored procedures and functions, batches and the target Data
• Worked on various different independent schemas around the database creation
• Worked closely with data modelers on Erwin tool for dimensional modeling of Star schema
• Worked on performance tuning by creating indexing, hints, used explain plans and analyzing the database
• Created technical design specifications formappings, sessions and workflows
• Extensively worked with aggregate functions like Min, Max, First, Avg and Last in the Aggregator Transformation
• Used re-usable transformations, mappings and mapplets confirming to the Business rules
• Involved in Various Data Cleansing and Data Conversion Functions in various transformation
• Widely used SQL Override function in Source Qualifier Transformation
• Reviewed the performance issues in the datamart like analyzing and optimizing query by linking the DBA’s for the SQL override lookups
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and documenting programs
• Set up informatica Schedules to execute the designed workflows in timely fashion
• Worked closely with the reporting team to create various reports
• Worked for a combination of Relational and dimensional data modeling

Environment: Informatica Power Center 8.6.1, Oracle 9i, PL/SQL, Toad 7.2, Flat file, Autosys, Erwin, Windows XP, XML, SQL Server

Confidentia

Informatica ETL Developer

Responsibilities:

• Prepared ETL flow of data from Transient, Staging, Warehouse and Data Mart
• Responsible for analysis, design, development and maintenance of ETL solutions
• Worked on mapping to load data from different source system like Flat Files, ODBC sources into target using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations
• Defined Target Load Order Plan for loading data into different Target Tables
• Designed Mapplet transformation to load data from ODS to Data warehouse
• Designed Slice and Dice and Drill Down Operations
• Tuned the transformations and sessions for better performance
• Used Repository Manager to create folders, which is used to organize and store all Metadata in the Repository
• Responsible for data modeling using star schema and snowflake schema concept
• Responsible for unit testing and mapping workflows
• Worked with Ralph Kimball and Bill Inmon methodologies
• Involved in data conversions from source database to Data Warehouse with Power Center
• Created sessions and batches and ran with Informatica server
• Modified the stored procedures, SQL statements, Database objects according to the requirements of the Oracle Database
• Supported data warehouse programs for reporting and ETL
• Wrote several ETL functions in PL/SQL for aggregation and summation purpose

Environment: Informatica Power Center 8.1 (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Windows NT, Oracle 9i, MS SQL Server 2005, PL/SQL, SQL, ERWIN.

Confidential

IT consultant

Responsibilities:

• Experienced installing and troubleshooting problems on Win 98, Win XP and Windows Vista Servers
• Ability to diagnose and fix hardware and software issues for both desktops and servers
• Created Store Procedures for various web based projects for development team
• Experienced with SQL server RDBMS structure
• Participated in the design of local and physical database structure
• Extensive database experience using SQL and My SQL
• End-User and Help Desk experience in MS Office Suite and other common desktop applications
• Experienced in troubleshooting network related issues that can be related to network infrastructure such as switches and routers
• Worked with various databases like Oracle, DB2 and SQL Server
• Configured the TCP/IP settings on network and troubleshooting TCP/IP issues

Environment: Windows NT/XP, SQL Server 2005, PL/SQL, Oracle 9i