SUMMARY

• 8+ years of Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 9.x/8.x/7.x, SSIS
• Worked intensively with Informatica Powercenter Designer. Highly skilled in Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Experience in data analysis, data migration, database system implementation, DWBI Development and testing methods.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts. strong in database concepts with Oracle
• Experience in UNIX Shell Scripting.
• Identify performance bottlenecks and optimize respective databases and processes for performance improvement. Experienced in analyzing query logs and explain paths.
• Preparing technical business solution strategy/approach using ETL technologies and present it to Design Review Board for their approvals.
• Designed database schemas using ERwin.
• Modeling and Implementing FACT tables and Slowly Changing Dimension scheme (Type II) for most of the dimensions.
• Created perfect star schema to accommodate OBIEE requirements. Designed Type II slowly changing dimensions as a base for accurate historical reporting.
• Hands on experience in performance tuning in Informatica and oracle.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.Exposure to full project life cycle development for implementation and integration.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Extensive Experience on Production Support.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.x/8.x/7.x, SSiS 2005/2008, Power Connect for Mainframe/MQSeries, PowerExchange, SQL*Loader, Flat Files (Fixed, CSV, Tilde Delimited, XML, AS/400)

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Database and Related tools: Oracle 11g/10g/9i/8i/8/7.x, MS SQL Server 2000/05/08, TOAD 8.5.1/7.5/6.2. DB2

Languages: PL/SQL, C, Unix Shell Scripting and Perl

Operating Systems: Microsoft Windows 7/XP/2000/9X, UNIX and Linux

PROFESSIONAL EXPERIENCE

ETL Developer

Responsibilities:

• Design and develop ETL process using Informatica tool to load data from wide range of sources such as Flat Files and Oracle Database.
• Responsible for migrating the folders or mappings and sessions from development to production environment and Created Migration Documents to move the code from Development Environment to Production Environment.
• Based on the Business logic, modified and tuned mappings to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Aggregator, Joiner, SQL transformations in the mapping.
• Performed unit testing
• Extract files and manually transferred to Informatica server using FTP scripts.
• Performed Integration testing

Environment: Informatica Power Center 9.5.1, Oracle 11g, Shell scripting, Windows and Linux.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Design and develop ETL process using Informatica tool to load data from wide range of sources such as Flat Files and Oracle Database.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Based on the Business logic, Develop various mappings & mapplets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
• Use connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Implementation experience of CDC (Change Data Capture) using stored procedures, triggers and using Informatica power exchange.
• Extract files and manually transferred to Informatica server using FTP scripts developed using Python.
• Worked on different OLTP data sources such as SQL Server and Flat files for data extraction.
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Extensively developed Oracle SQL stored procedures using TOAD to implement different business logics and perform backend testing to verify the transactions and business logic.
• Created and tested UNIX shell scripts to automate SQL scripts and stored procedures.
• Extract data from DB2 database for ETL processing.

Environment: Informatica Power Center 9.5, DB2, Oracle 11g, Shell scripting, Power Exchange 9.5, Windows and Linux.

Confidential - West Chester, PA

ETL/ Data Warehouse Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
• Worked on Informatica Utilities Source Analyser, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more transformations to implement complex business logic.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using SSIS.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks
• Performed the performance evaluation of the ETL for full load cycle.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Wrote complex T-SQL Queries involving multiple tables with joins.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Generated PL/SQL scripts.

Environment: SQL Server 2008/2005, SSIS, Oracle 10g, UNIX Scripting, T-SQL.

Confidential -Denver, CO

Informatica Developer

Responsibilities:

• Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
• Documented required technical metadata such as source and target definitions.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Remote Procedure, Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters and Sequence Generator etc.
• Performed extensive data analysis to understand the existing data behavior using current and historical data. Analyzed data for policy, party, household, products data for several projects requirement.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Worked on OBIEE reports to do Enhancements
• Tuning of Informatica jobs with oracle as backend database

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 10g, SQL*Plus and Linux.

Confidential, Washington, DC

ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.
• Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplets, and Transformations.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL*Loader.
• Tuning of Informatica jobs with oracle as backend database

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 9i, SQL*Plus, TOAD, Windows and Linux

Confidential

ETL/DWH Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from Oracle, Excel/Flat files to Oracle using Informatica Power Center.
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs and in the designer to implement Type 2 SCD.
• Developed and Implemented Informatica parameter files to filter the daily data from the source system.
• Fine-tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and Aggregator transformations.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Performs insert, update, delete, and upset operations for large volume incremental loads using Teradata MultiLoad, FastLoad.
• Worked with Stored Procedure Transformation for time zone conversions.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Administrated Workflow Manager to run Workflows and Worklets.
• Involved in performance tuning on Informatica mappings.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Implemented Error Handling Logic, which involves testing of incorrect input, values for the mappings and the means of handling those errors.
• Used Shell Scripts which compares the incoming file with the existing file and creates a log file with differences and the changed values are loaded into the target.

Environment: Informatica Power Center 7.1.3, Oracle9i, Toad and Linux, Informatica Power Center 8.6.1/8.1.1

Confidential

Informatica Developer

Responsibilities:

• Involved in translating business requirements to integrate into existing DataMart design.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensively used ETL to load data from different relational databases, XML and flat files.
• Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handled the Migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.
• Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
• Working knowledge with Data Modeling: Both Reverse and Forward Modeling using Erwin
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads.
• Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
• Extensively involved in the analysis and tuning of the application code (SQL).

Environment: Informatica Power Center 7.1.2, DB2, Oracle9i, Erwin, XML, Windows NT and Unix.