SUMMARY

• 8 years of experience in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center in various domains like Health Care, Investment Banking and Financial sectors.
• As an analyst, getting up the requirements from business users and transforming them to technical requirements.
• As an ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA Power Center 10.x/9.x / 8.x / 7.x (Designer, Workflow manager, Workflow monitor and Repository Manager ).
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Involved in complete SDLC (Software Development Life Cycle).
• Extensively worked with Autosys, CA Unicenter WLM & Control-M Job scheduling tool.
• Expertise in working with Control M utilities like ctmfw, ctmcontb, ctmpsm, ctm order etc. for scheduling the jobs as per requirement.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in integration of various data sources like Teradata, Oracle, SQL server, flat files, and XML files (Advanced).
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Good knowledge on Business Intelligence tools.
• ETL experience in development of mappings and tuned existing mappings for better performance using Informatica Power Center as per the business rules.
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Developed unit test plans and involved in system testing.
• Expertise in writing VB Scripts for automating several processes.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica 10.x/9.x/8.x/7.x (Power Center)

Databases: Teradata 13/12, Oracle 8i/9i/10g/11g, Greenplum, Netezza

Query Tools: SQL, PL/SQL, SQL*Plus, and TOAD

Scheduling Tools: Control M 7/8, Unicenter WLM(Work Load Manager), Informatica Scheduler, Autosys

OLAP/Reporting Tools: Cognos

Languages: UNIX/LINUX/DOS Scripting

Operating Systems: Windows Server 2003, Server 2008, 2008 R2, Windows 7/Vista/XP/Millenium/98, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Missouri

Informatica Analyst

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica Power Center 9.5.1
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Created events and tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Business Intelligence team. With Cognos, generated several reports from semantic layer and provided to end users.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• 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.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.
• Scheduled the jobs in Control M tool for automation.

Environment: Informatica Power Center 9.1.5, Teradata 12/13, Oracle 10g, Netezza, SQL Assistant, XML, UNIX Shell Scripting, Control M 8.

Confidential, New Jersey

Sr. ETL Developer

Responsibilities:

• Responsible for gathering the user requirements and discuss with Business Analysts to acquire the functional and Technical specifications
• Wrote several fast load scripts to load the data from Source to Landing Zone.
• Interacted with the Data Architect in Creating and modifying Logical and Physical data model.
• Worked with DBA’s in optimizing the Major SQL Query’s in the process of performance tuning.
• Created tables, views in Teradata, according to the requirements.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Designed and tested the workflows in SIT, UAT and RT environments.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Scheduled Teradata scripts using Control M through UNIX.
• Taken part of Business Intelligence team. With Cognos, generated several reports from semantic layer and provided to end users.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Created Unit Test plans and involved in primary unit testing of mappings.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the work involved in the application during its production support phase.

Environment: Informatica Power Center 9.0.1, Teradata 12/13, Oracle 10g, Netezza, SQL Assistant, XML, UNIX Shell Scripting, Control M 7

Confidential

Senior Informatica Developer/Lead

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from XML files, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Involved in working with advanced XML sources for data acquisition.
• Worked on understanding XLM sources for processing them in tool.
• Extensively worked on XML parser and XML generator for reading and loading into targets using Informatica respectively.
• Handle the queries regarding XML and troubleshoot problems.
• Involved in XML and XSLT coding in order to create the Front End screen insert activities.
• Good knowledge in understanding the XSD schemas
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Designed and Developed ETL logic for implementing SCD.
• Created several rules and alerts in PAM for different notifications.
• Modified different templates as per requirement in PAM for sending email alerts.
• Created several advanced rules to send alerts for “Session failure”, “Work flow start”, “Non responsive sessions”, “Un-scheduled workflows” etc.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.

Environment: Informatica Power Center 8.6.1/8.1.3 , Pro-active Monitoring (PAM), Oracle 10g, SQL Assistant and Administrator, XML, UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Mainly involved in ETL developing.
• Development of Mappings according to the Mapping specifications.
• Creating the ETL design document.
• Creating Informatica mappings using different transformations to implement business logic and creating sessions and workflows.
• Extracting data from Flat files and oracle sources and transform the data and load the data in to warehouse.
• Using various transformations like Source Qualifier, Expression, Aggregate, Lookup, Router, update strategy transformations.
• Unit testing for validating the data to meet Business requirements.
• Preparation of Unit test cases also one of my responsibilities as per the business requirement.
• Scheduled all the jobs in Unicenter WLM.

Environment: Informatica Power Center 8.6.1/8.1.3 , Oracle 10g, SQL, UNIX Shell Scripting,