SUMMARY:

• Around 4 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, Tradata 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.

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.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Informatica Developer

Tools: and Technologies used: Informatica PowerCenter Designer 9.6, Autosys, Oracle 11g, Teradata 14, Toad, SQL *Loader, SQL, PL/SQL, UNIX, Visio, Quality Center 9

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.
• Extensively worked on Integration testing and User Acceptance Testing (UAT). Reviewed UAT with business users.

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.

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
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management