SUMMARY

• Over 8+ years of experience in IT industry including 6 years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Strong DWH & ETL experience in Informatica Power Center 9.6.1/9.1/8.6.1 development, design, process and best practices experience as ETL Analyst and Developer in US.
• Well acquainted with Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Extensive database experience and highly skilled in Oracle.
• Good Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Extensive experience in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in ETL performance tuning of sources, transformations, targets, mappings, work lets, workflows, and sessions.
• Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.
• Extensively used Debugger in Informatica Designer tool to test the data and fix errors in the mapping.
• Experience in Informatica B2B Data Exchange using Unstructured, Structured Data sets.
• Experience with Informatica Metadata Manager, loading resource and generating Lineage.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization etc.
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.
• Experienced in Implementing HP Quality Center for bug detection and fixing in testing.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work independently.

TECHNICAL SKILLS

ETL Tools: Informatica 9.6.2/ 9.6.1/9.1/8.6.1 (Power Mart/ Power Center) 6.x, Informatica Power Exchange, Informatica B2B Data Exchange, Informatica Power Connect, IDQ,IDE, Metadata Manager

Reporting Tools: BusinessObjectsXIr2/r 1/6.5/6.1/5.1 , CognosReportnet,Cognos8,SSRS(SQL Reporting Services),SAS

Databases: Oracle 12c/11gr2/10.x, IBM DB2 UDB 10.1/9.7, Teradata v2r5/v2r6,MS SQL Server 2012/2008, Sybase, MS Access.

Database utilities: SQL *plus, Stored procedures, Functions, Exception handling.

Data Modeling tool/ Methodology: MS Visio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

Languages: C, C++, JAVA, Visual Basic, T-SQL, PL/SQL, XML

Operating Systems: HP-UX, Unix, Linux 6.6, IBM AIX 6.5/5.9, SunSolaris 10, Windows 2003/2000/NT

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Informatica Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, Mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Used Unstructured Data like PDF files, spreadsheets, Word documents, legacy formats, and print streams option to get normalized data using B2B Data Exchange of Informatica.
• Used Informatica B2B Data Exchange to Structured data like XML.
• Involved in preparing ETL mapping specification documents and Transformation rules for the mapping
• In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Involved in Prod Support to research and resolve the daily load issues.
• Document the Prod job failures and provide the root cause analysis to the management.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica 9.6.1/ 9.1.0 , UNIX, Informatica B2B Data Exchange, Oracle 11g, Unix Shell Scripts, SQL, PL/SQL, Flat files, DB2, Teradata.

Confidential, FL

Sr. Informatica Developer/ Data Analyst

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used ETL (Informatica) to load data from source to Data Warehouse.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplets Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
• Worked with mapping wizards for slowly changing dimensions and slowly growing dimensions by using Informatica mapping designer.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
• Used CDC for moving data from Source to Target.
• Identified the data in the source system that has changed since the last extraction with the help of CDC.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Designed and Developed Oracle PL/SQL procedures, performed Data Import/Export, Data Conversions and Data Cleansing operations.
• Used Autosys for automating Batches and Session.
• Involved in writing shell scripts on Unix (AIX) for Informatica ETL tool to run the Sessions.
• Involved in generating reports from DM layer using Business Objects.
• Involved in tracking, reviewing and analysing defects.

Environment: Informatica 9.1/8.6.1, Business Objects XI 3.1,Crystal Reports 2008,Oracle11g, MS SQL Server 2008/2005, Erwin7.3, Windows NT, IBM-AIX.

Confidential, Washington, DC

ETL Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment: Informatica PowerCenter 8.1, Oracle 10g, Sun Solaris 9, UNIX, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Involved in designing and building data marts for provider division.
• Loaded data to the stage tables in oracle from multiple data sources using Informatica.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Implemented aggregate, filter, join, expression, lookup and update strategy transformations.
• Implemented variables and parameters in transformations for incremental data extraction and complex transformation logic.
• Created mappings between source and target using Informatica power center designer.
• Used mapping and Mapplet designer to generate different mappings for different loads.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle.
• Created, scheduled and monitored sessions and batch process based on demand and run only once using Informatica server manager.

Environment: Informatica Power Center 7.1, Oracle 9i, Windows 2003 Server.