SUMMARY:

• Over 7 years of Software Development experience in the IT industry. Extensive experience in Data warehousing environment using Informatica Apps (Designer, Workflow manager, Workflow monitor)
• Experience in data warehouse development life cycle, requirements analysis, Repository management & administration, dimensional modeling, Incremental Loads, Implementation of STAR, Snowflake Schemas.
• Experience in creating mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica.
• Experience in integration of various data sources like Teradata, Oracle, DB2, and Flat files.
• Designed and developed various mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Sorter and Sequence Generator.
• Strong skills in data mapping for the slowly changing dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
• Implemented the complex business rules by creating reusable transformations and Mappings / Mapplets.
• Reporting in quick understanding of requirement and analysis.
• Experience in SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in debugging and Performance tuning of targets, sources, mappings and Sessions.
• Experience in Data Modeling (Logical, Physical) with Erwin.
• Experience in writing UNIX shell scripting for Automation of the ETL Process.
• Working knowledge on reporting tools like Micro Strategy 9.4
• Experienced in all the products of Micro Strategy Product Suite namely Micro Strategy Desktop, Intelligence Server, Administrator, Architect, Web, Command manager, Object manager, Enterprise manager and Narrowcast Server
• Performed system and QA testing and involved in Production Support.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with Project managers, Business Analysts, Architects, DBAs and Developers

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1, 8.6.1, 8.1.1/ 7.1/6.2.2

Data Bases/RDBMS: Teradata V2R5, Oracle 10g/9i/8i/8.0, IBM DB2XML, SQL Server, 2000/2005/2008

Business Intelligence Tools: Micro Strategy 9.4.1/8.1.x/7.5.x

Data Modeling Tools: Erwin 7.3/4.5/4.0/3.5

Query Tools: Toad, SQL Navigator

Operating Systems: UNIX, Windows NT/2000/98/XP, Linux

Languages: SQL, PL/SQL, UNIX shell scripts, C, C++Scheduling tools: Autosys, Tidal Scheduler

PROFESSIONAL EXPERIENCE:

Sr. Informatica Application Developer

Confidential, Hartford, CT

Responsibilities:

• Participated requirements gathering meetings with stakeholders
• Involved in the design and development phase of the project
• Managed and coordinated with offshore resources, conducted weekly and daily status update meetings
• Extensively worked with Slowly Changing Dimensions Type2 for Data Loads
• Worked closely with users to develop the transformation logic to be used in Informatica Power Center
• Performed data manipulations using several transformations such as Source Qualifier, Sorter, Aggregator, Filter, Router, Lookup, Union, Rank, Stored Procedure and Expression
• Implemented incremental loading to capture changes to the underlying data for a specific duration
• Used MD5 function to capture changes and Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic
• Fine-tuned SQL overrides in Source Qualifier and Look-up SQL overrides for performance enhancements
• Used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations
• Created Mapplets to enhance reusability in mappings
• Migrated code from development to QA
• Created UNIX shell scripts in the pre-session and post-session for error logging and created several scripts according to the changing needs of the project and client requirement
• Responsible for error handling using Session Logs, Reject Files and Workflow Logs in the Workflow Monitor
• Involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, Created test data
• Optimized query performance and session performance

Environment: Informatica Power Center 9.1, Teradata V2R5, Oracle 10g, Flat files, Windows NT, SQL Server 2008/2005, Toad Data Point, PL/SQL, UNIX

Confidential, Atlanta, GA

Informatica ETL Developer

Responsibilities:

• Designed the Functional requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Continuously interacted with Business Analyst to understand the business users reporting specs to implement on Micro Strategy tool.
• Extensively used Informatica 8.6.1 to extract data from the databases and load it into the data warehouse
• Designed and Developed ETL (Extract, Transformation & Load) Strategy to populate the data using Informatica Power Center, PL/SQL
• Developed Complex mappings using Transformations (Filter, Router, Lookup, Update Strategy, Expression and Aggregator) on the extracted data according to the Business Rules and Technical Specifications
• Involved in fixing invalid mappings using the Informatica Debugger
• Developed Sessions using Workflow Manager for loading the data into target database
• Involved in Testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches, Workflows and the Target data
• Worked on Performance Tuning of Various mappings and sessions to identify and remove bottle necks.
• Documentation of mappings and sessions involved in the ETL Process
• Developed and Implemented Error Handling Strategies
• Created Mapplets to avoid designing mappings for the same set of business rules
• Worked with SCD tables using Lookup and Update Strategy transformations
• Worked with Target load order and Constraint based loading.

Environment: Informatica PowerCenter 8.6.1, MS-SQL Server 2008, Unix Solaris 8.1, SQL Assistant, Windows NT, Micro Strategy & Erwin 4.1

Confidential, Chantilly, Virginia

Informatica Developer

Responsibilities:

• Involved in the Data modeling design of data warehouse using star schema methodology with confirmed and granular dimensions and FACT tables.
• Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
• Used XML source qualifier transformations to extract data from XML sources
• Modified the existing mappings and created several new mappings based on the user requirement.
• Imported and Created Source Definitions using Flat files, Excel files, Oracle and load the data to DB2
• Developed parameter files to use for values of DB Connections, session and mapping variables
• Worked on the existing mappings by resolving performance issues
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Used Informatica Monitor and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used pmcmd command to schedule sessions and batches.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.6.1, AutoSys, Oracle 9i/10g, Erwin, 4.5, DB2, SQL, PL/SQL, TOAD, Unix Scripts, Flat Files.

Confidential

ETL Developer

Responsibilities:

• Extensively used almost all Transformations constructs such as Aggregator, Router, Joiner, Expression, Lookup, Update Strategy and Sequence Generator for developing various mappings
• Developed simple & complex mappings using Informatica to load dimension & fact tables as per STAR Schema techniques
• Designed and Developed Informatica mappings between source data to target repository utilizing Informatica designer tool
• Setting up the application in the Staging server on a daily basis.
• Extensively worked in the performance tuning of ETL mapping and session
• Scheduling and creation of sessions and executing them to load data from the source system
• Expertise in different type of data loading including Bulk load
• Utilized Informatica debugger for trouble-shooting

Environment: Informatica 8(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Oracle8i, SQL Loader, MS SQL Server 2000.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with the Data warehouse architect to understand the source data and come up with the design for the Data Warehouse and Data Mart.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier Transformation, and Update Strategy Transformation.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Developed Procedures and Functions and UNIX shell scripts
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created reusable transformations and used in various mappings.
• Developed Informatica parameter files to filter the daily source data
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Extensively used Informatica Scheduler to Schedule Informatica Workflows.

Environment: Informatica PowerCenter 7.1, Informatica PowerConnect, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), ETL, Flat files, Erwin 4.0, Oracle 9i, Windows NT,MS SQL Server 2000, PL/SQL,UNIX.