SUMMARY

• Over 6 years of experience in Analysis, Design, Development, Implementation and Troubleshooting and production support.
• Strong understanding of Data Warehouse Project Development Life Cycle and Project Methodologies. Experience in documenting all teh phases of DWH projects.
• Experience of ETL and data integration in developing ETL mappings and scripts using Informatica Power Center.
• Ability to write SQLs needed for ETL jobs and analyzing data, and is proficient and worked wif databases like Teradata, Oracle and SQL Server
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Implemented Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in basic Informatica admin activities.
• Migrating data mapping to production and monitor and troubleshoot
• Experience in programming using PL/SQL, Stored Procedures, Functions, Constraints, Triggers, Indexes, Views, partition utilization to increase performance, Ad - hoc queries using SQL.
• Basic in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load.
• Involved in planning, building and managing Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts, ER diagrams development, Fact and Dimension Tables.
• Extensively worked on teh ETL mappings, analysis and documentation of OLTP/OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially wif large data sets.
• Demonstrated ability to work and communicate TEMPeffectively wif both business and technical audiences.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

ETL Tools: Informatica9.5/9.1/8, Datastage 8/7

Database: Teradata 12/13, Oracle 10g/11g, MS SQL Server 2005/8

Languages: C, C++Scripting languages UNIX Shell script

Others: Control-M, Business Objects and Crystal Report.

Operating Systems: MS-DOS, HP UNIX, Windows 2000/XP/Vista/7/ Server 2003/2008

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

ETL/ Informatica Developer

Responsibilities:

• As a DW Developer, working wif ETL Application development teams to understand project requirements and their implication to Informatica Common Components.
• Prioritize and manage development and implementation of enhancements/changes for all teh ICDW Informatica common components.
• Maintain and manage teh enhancement and issues list for ICDW Informatica common components.
• Manage teh issue resolution process for any application production problems impacted by Informatica common components.
• Assist to teh Application Development teams in day to day issues related to Informatica development and answer teh ICDW ETL Architecture questions.
• Own and manage teh day to day changes and enhancements for ICDW Informatica common components.
• Provide 24*7 Production support related to Informatica issues and ETL process.
• Maintain & Publish Informatica ETL Development Standards.
• Provide day to day direction to Employees and Consultants in teh Common Components Team.
• Liaison between Common Components & Development Teams.
• Own Informatica ETL Architecture & Enhancements.
• Analyze various issues in ETL code migration and prepared documents for short term and long term solution e.g Mapplet issues.
• Consult development teams to enhance and fix audit entries in database and shared objects in Informatica.
• Perform knowledge transfer sessions to Application Development Teams on ICDW ETL Architecture.
• Identify new Informatica functionality in upcoming releases and provide recommendations to implement teh same.
• Analyze and provide approval for Source System, UAT/PROD changes (ITSM) to APP Dev Team.
• Consult Dev team for Query banding, trace file, TPT Connection guidelines and provide ETL code migration approval for higher environment.
• Build / improve relationships wif development teams through proactive communication and face-to-face meetings.

Environment: Informatica, Teradata (BTEQ, Fast load, MultiLoad, TPump), UNIX, Control - M, and Subversion

Confidential, St Petersburg, FL

ETL/ Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement teh business requirements.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked in processing input files and sending output files to CMS.
• Extensively worked in resolving teh incidents created.
• Worked on performance tuning of slow running jobs.
• Created ETL mappings and Mapplets to extract data from source systems into Oracle.
• Created different transformations for loading teh data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Managed multiple failovers, production issues and provided 24*7 on call supports.
• Worked on connected and unconnected lookups.
• Used teh Informatica Workflow Manager to create and run teh Workflows, Worklets and Sessions for loading teh data using teh logic from mappings.
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Involved in wif End Users during QA Testing and User Acceptance Testing
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug teh complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in teh table
• Designed and Developed teh Informatica workflows/sessions to extract from Flat Files, transform and load teh data into Oracle Database.

Environment: Informatica, Oracle 10g, Shell Scripts.

Confidential, Cedar Rapids, IA

ETL Developer

Responsibilities:

• Participated in teh entire Software Development Life Cycle (SDLC) phases including Data Analysis, Design, Coding, Testing and Deployment.
• Analyzed Business Requirements and converted them into mapping design.
• Delivered Data Model Diagram and Test Strategy
• Developed data mapping for Sources, Targets, and Business Transformation rules.
• Developed mappings for slowly changing dimensions (Type I, II) and Facts using Informatica Tool.
• Used different Data Warehouse techniques like Star-Schema, Snowflake-Schema
• Created various active & passive transformations like Expression, Lookup, Filter, Rank, Aggregator, Router, Update strategy, Stored Procedure, Joiner etc.
• Frequently worked for command task and post session tasks using UNIX script.
• Developed Mapplets and Reusable Transformations for calculated business units.
• Involved in teh performance tuning of teh programs.
• Worked extensively in tuning SQL, PL/SQL and Stored procedures, identifying and resolving tuning issues.
• Responsibility for ETL Objects and Database Objects migration for each release.
• Tested teh target data against source system tables by using SQL scripts, PL/SQL procedures.
• Monitored teh daily data loads and provided support after hours.

Environment: Informatica Power Center 8.1 Oracle 10g, SQL Server, SQL Plus, UNIX Scripting, SQL Loader, XML, TOAD.

Confidential, Fort Worth, TX

ETL Analyst

Responsibilities:

• Load teh data from flat files to staging tables using ETL and tan load teh same into data warehouse.
• Created Informatica Mappings to populate teh data into dimension and fact tables.
• Used Informatica 8.6 client tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded teh process of data flow from source system to data warehouse.
• Created Informatica mappings, reusable objects of Mapplets depending on teh client requirements Used different transformations such as Normalizer, Source Qualifier, Filter, Lookup and Aggregator
• Used Slowly Changing dimensions of Type 1 and Type 2.
• Involved in setting up scheduling of jobs in QA/UAT environment by using Control M.
• Involved in code migration from development to QA/UAT and tan to production
• Involved in UNIX shell scripts for file validation, file archival, file transfer, pmcmd script to execute teh workflows.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in teh existing sessions.
• Used UNIX Shell scripting for automation of teh process, invoking PL/SQL procedures, and Informatica sessions.
• Involved in Unit testing, QA/UAT testing.

Environment: Informatica, UNIX, FTP, SFTP, Oracle.

Confidential, Detroit, MI

ETL support Analyst

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration wif Informaticapower center
• Developed various mappings using Mapping Designer and worked wif Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing teh deleted records in teh source systems.
• Worked wif teh connected lookup Transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Prepared Technical Design documents and Test cases.
• Use crontabto schedule jobs

Environment: Informatica 8.6, Oracle, SQL Developer and UNIX.