SUMMARY:

• 5+ years of IT experience in Data Warehousing technology in Informatica PowerCenter 9.6/9.1/8.6 applications and various databases like Oracle 11g/10g, Teradata 14, SQL Server 2000/2007.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing, Deployment and Production support.
• Worked on documentation of Design, Test case, Data flow and ETL Code between applications.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Extensively used Slowly Changing Dimension (SCD) Type 1, 2 and 3 technique in data warehouse.
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Experience in writing UNIX Script for various phase of ETL process.
• Extensive understanding of Production issues and Data issues and provided Production support. communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
• Worked on documentation of Design, Test case, Data flow and ETL Code between applications.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/9.x

Databases: Oracle 11g/10g, MS SQL Server 7.0/2000, DB2, TeraData 14

DB Tools: SQL*Plus, SQL* Loader, TOAD

Environment: Sun Solaris, UNIX, WINDOWS XP/2000/NT

Languages: C, C++, Java, SQL, PL/SQL, XML, UNIX

Drafting Tools: Visio, Rational Rose, Erwin, UML.

Development Tools: Microsoft Visual Studio, Dream Weaver.

Office Suite: MS Word, MS Power Point, MS Excel, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Informatica Developer

Roles & Responsibilities:

• Converted business requirements into technical documents - Business Requirement Document, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2, XML files.
• Worked Teradata Utilities like FLOAD, MLOAD & TPump to load data in staging and OLAP.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, Index Cache, Data Cache and incremental aggregation.
• Worked on complex Informatica Mappings for Household dimension, Multi valued dimension and Point in time dimension.
• Utilized Quality Center 9 web based test management tool to keep track of all the releases, requirements, test plans, labs and defects.

Confidential, Bethesda, MD

DW Informatica Developer

Tools: and Technologies used: Informatica Power Center 9.1, OLAP, Oracle 10g, MS SQL Server 7.0, IBM DB2/400, Sybase, MS Excel 97, Flat files, PL/SQL, SQL, SQL*Loader, Erwin 3.5, Toad 7.0, Windows 2000, HP-UX, and Unix Shell Scripting.

Roles & Responsibilities:

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Developed PL/SQL procedures/packages to load the data into database.
• Tuning Informatica Mappings and Sessions for optimum performance
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Optimized/ Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for ETL process under development, test and production environments
• Developed Interfaces using UNIX Shell Script to automate the bulk load & update processes.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards