SUMMARY

• Over 7 years of experience in design, developmentand testingof software applicationacross multiple industries like Healthcare,Banking and Education.
• Extensive experience in designing and developing ETL for various projects involving various source and target types such as flat files, relational tables (Oracle, SQL Server, DB2), MPP databases (Teradata) etc.
• Extensively experience using InformaticaPower center client Tools - Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Good understanding of Business Intelligence and complete Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Extensive experience using Informatica power centertransformations like Connected and UnconnectedLookup, Joiner, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator and Sorter, Normalizer, SQL Transformation.
• Extensive experience in writing Teradata BTEQs, loader scripts for Fast Load, MLOAD
• Worked on creating Sources, Targets, Transformations, mappings and build various flows in the workflow manager for efficient data loads between different data sources and targets between different systems and databases.
• Extensive experience in writing complex SQLs, PL/SQL and Stored Procedures.
• Experience in performance and tuning of Informatica mappings, sessions and workflows.
• Good knowledge in Informatica Power Exchange.
• Extensive involvement in logical and physical data modeling.
• Experience Slowly Changing Dimensions
• Implemented ETL job scheduling using Autosys and Control-M.
• Strong understanding of OLTP, OLAP concepts.
• Experience working with offshore teams and onsite co-ordination.
• Good experience in Unix Shell Scripting for flat file management and running the scripts in UNIX server.

TECHNICAL SKILLS

ETL: Informatica Power Center and Power Exchange 9.x, 8.x, 7.x

Databases: Oracle 8i/9i/10g/11g, Teradata V2R5.0/V2R6.0, MS SQL Server,My SQL

O/S: UNIX (IBM AIX, Sun Solaris), Linux, Windows

Programming: UNIX Shell Scripting, SQL, PL/SQL,Java,C++

Tools: TOAD, SQL*Loader, SQL-ProgrammerMicrosoft Suite Excel, Word, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Michigan

ETL Developer

Responsibilities:

• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Involved in Design and development of Data Marts for specific Business aspects which include Policy, Claim, Enterprise Billing and eQuote.
• Responsible for writing Extracting source definitions from various databases likeOracle, Teradata, sql server and Flat-files into Informatica repository
• Created UNIX shell scripts and processes to extract data from various sources such as DB2 and Oracle
• Designing Reusable Transformations and Mapplets. Used most of theTransformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank,Expressions, Aggregator, Filter, and Sequence Generator for loading the data intoOracle database
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Investigating, debugging and fixing problems with Informatica Mappings andWorkflows.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Autosys, UNIX Shell Scripting, SQL, SQL *Loader, TOAD for Oracle, Linux, Windows XP/NT/2000

Confidential - California

Informatica Developer

Responsibilities:

• Developed the Informatica mappings based on the business logic provided in the FSD (Functionalspecification document).
• Developed mappings in Informatica Power Center to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter, Router etc.
• Developed unix scripts for various purposes, for example: running workflows, running sql scripts.
• Extensively involved in extracting SAP data with the help of Power Connect for SAP, loaded into stage and warehouse database in Oracle.
• Used parameter files for defining the values and parameters used in sessions and mappings.
• Performed SQL optimization and Informatica tuning to increase the through put for both mapping and session level.
• Worked with high volume datasets from various sources like Oracle, Text Files, and xml targets.
• Experience in using Informatica integrated with shell programming.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SAP BW, UNIX Shell Scripting, SQL, unixWindows XP/NT/2000.

Confidential - Charlotte

ETL/Informatica Developer

Responsibilities:

• Made substantial contributions in simplifying the development and maintenance of ETL by creating reusable Mapplets and Transformation objects.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Written various stored procedures, triggers and functions as per the business requirements.
• Optimized/Tuned queries, stored procedures and mappings for better performance and efficiency.
• Created CognosReportNet Framework Manager Project, published and maintained packages, created Query Studio and Report Studio reports.
• Developed and designed the Informatica mappings based on the SDS (system design specification)document.
• Made substantial contributions in simplifying the development and maintenance of ETL bycreatingre-usable Mapplets and Transformation objects.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Optimized/Tuned queries for mappings for better performance and efficiency.

Environment: Informatica PowerCenter 8.1, Oracle 10g, Control M, UNIX Shell Scripting, SQLPL/SQL, SQL * Loader, TOAD for Oracle, AIX, Windows XP/NT/2000

Confidential -Dallas

Informatica Developer

Responsibilities:

• Involved in Requirement gathering, Design of ETL Architecture and Data Modeling
• Responsible for writing Extracting source definitions from various databases like Oracle, Teradata, sql server and Flat-files into Informatica repository
• Done Performance tuning to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Worked with high volume datasets from various sources like Oracle, Text Files, and xml targets.
• Experience in using Informatica integrated with shell programming.
• Involved in Power Exchange Change Data Capture for data updates.
• Involved in developing of stored procedure for CDC(Change Data Capture).
• Designing Reusable Transformations and Mapplets. Used most of the Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, Aggregator, Filter, and Sequence Generator for loading the data into Oracle database
• Investigating, debugging and fixing problems with Informatica Mappings and Workflows.

Environment: -: Informatica Power Center 8.6, Oracle 10g/9i, MS SQL Server 2005, PLSQL Developer 8.0, Control-M, MS Visio 2003, Windows XP, Business Objects XI, UNIX,AIX 4.3

Confidential

ETL/DW Developer

Responsibilities:

• Participated in business analysis, ETL requirements gathering
• Documented user requirements, translated requirements into system solutions and develop implementation plan, schedule, Technical design document and unit test plan
• Extracted source definitions from various databases like Oracle, MS Access and Flat-files into Informatica repository.
• Designed Workflows, reusable Tasks and Worklets using Informatica Workflow Manager SQL and worked on performance tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.

Environment: Informatica Power Center 8.6/7.1, Oracle 8, TOAD, UNIX, MS Access, MS Visio, Autosys.