SUMMARY

• Over 8+ years of IT experience in Data warehousing and Business Intelligence with emphasis on Business Requirements Analysis, Application Design, Development, Testing, Implementation and Maintenance of Data Warehouse and Data Mart systems.
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development, testing and deployment.
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter.
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Extensively worked on Informatica Client Tools - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer, Task Developer, Workflow Monitor.
• Vast experience in designing and developing complex mappings from varied transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Normalizer etc.
• Expertise in Query Analyzing, performance tuning of Informatica mappings using partitioning and pushdown optimization.
• Expert in troubleshooting/debugging and improving performance at different stages like database,workflows,mapping
• Experience in scheduling loads/jobs using Informatica, Autosys and APPWORX etc.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes.
• Hands on experience in Teradata RDBMS using FastLoad, MultiLoad, TPump, Fast Export, Teradata SQL Assistant and BTEQ.
• Sound knowledge of relational & dimensional modelling techniques of data warehouse concepts, the Star &Snowflake schemas, SCD, OLAP, OLTP, Normalization /Denormalization.
• Developed Slowly Changing Dimension (Type 1 SCD, Type 2 SCD, Type 3 SCD)
• Intense Knowledge in designing Fact & Dimension Tables, Physical & Logical data models
• Experience in writing SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9x/8.x/Power Connect, Informatica Power Exchange

RDBMS: Teradata V12/V13/V14, Oracle11g/10g/9i, SQL DB, DB2

BI Tools: Business Objects 6.0, Cognos, Qlik view, Tableau

Operating System: HP UNIX, IBM AIX 4.3/4.2, Windows NT/2000/XP/7

Job Scheduling Tools: Informatica Scheduler, Autosys, Appworx

Languages: SQL, PL/SQL, UNIX Shell Scripting

Modelling Tools: Erwin 4.1

Other Tools and Utilities: TD Utilities (Mload, FEXP, BTEQ, Fast Load), SQL * plus, Toad, SQL Server2005, MicrosoftVisio Oracle SQL Developer, Quest Toad for Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Sr. Informatica ETL Developer

Responsibilities:

• Active participation on requirements gathering and design discussions.
• Involved in ETL development, Sprint Review meetings and showcases.
• Involved in design Part of the Project by creating FSD & Business mapping documents.
• Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
• Implemented the process for capturing incremental data from source systems and log audit transactions
• Involved in onsite offshore coordination.
• Has used Teradata utilities BTEQ, FastLoad, MultiLoad and Tpump to load data in to the Target tables.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Performance tuning at informatica level and query tuning to make sure the loads run smooth within the permitted time windows.
• Prepare deployment checklists and KT documents for support team.
• Prepare DFD and work closely with Architects and support team on applicable dependencies.

Environment: Informatica power center 9.6, Power Exchange, SQL Server, Teradata V13, UNIX, Toad Data point.

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Created mapping documents to outline data flow from sources to targets.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources (flat files and other RDBMS databases) into staging area, transformed data and loaded into data warehouse.
• Created and Developed re-usable transformations, mappings and mapplets confirming to the business rules.
• Developed mapping parameters and variables to support SQL override.
• Has used Persistent Cache in lookup transformation for better performance of the loads.
• Involved in the Performance tuning at source, target, mappings, sessions, and system levels.
• Has created UNIX shell Scripts for FTP of files and backup which we run through command task.

Environment: Informatica power center 9.5.1, Power Exchange, SQL Server, Teradata V13, UNIX, Toad Data point.

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Has involved in Business Users requirement discussion meetings with Source system experts and formed functional and technical specs
• Major part of the project involves migration from Oracle to Teradata. This includes migration of code, migration of data, documenting the migration process, extensive testing and validation.
• Extensively used Informatica Power Center for extracting, transforming and loading into Teradata tables from Multiple Sources systems/databases.
• Used database objects like views, Partitioning for accomplishing the Complex logical situations.
• Responsible for Self and Peer Review of Informatica mappings under Development Phase
• Implemented slowly changing dimensions (TYPE 2) according to the requirements.
• Created Mloads, BTEQ’s, Fast Exports, and Fast loads scripts for loading and transforming data according to the requirements.
• Used EXPLAIN Table plans and indexes and partitions to tune and optimize SQL/Teradata Queries.
• Prepared deployment documents for the ETL migrations from Dev to Test/UAT/Staging and PROD environments and actively participated in the testing, unit test cases, UAT.
• Scheduled the Loads using APPWORX tool and also supported/monitored them.

Environment: Informatica power center 9.1, TeradataV13, Qlikview, Oracle 10g, UNIX, APPWORX

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Requirement study to understand business logic and prepared low level Source to Target mapping documents.
• Designed and developed Informatica mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Has worked in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) to load into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Prepared Unit Testing cases to test data that has been transformed and loaded as per the business logic.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Scheduled the Daily and weekly Loads using Autosys.

Environment: Informatica power center 8.6, Teradata V12, Autosys, Oracle 10g and UNIX Shell Programming.

Confidential

Informatica ETL Developer

Responsibilities:

• Worked on Informatica tool - Source Analyzer, Mapping Designer & Mapplet, and Transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
• Has developed Database Triggers, Stored Procedures, Functions and Database Constraints in SQL, PL/SOL queries and optimized for maximum performance.
• Has developed BTEQ and Mload scripts working on Teradata SQL Assistant.
• Involved in designing of testing plan (Unit Testing and system testing).
• Created user required documents for the business flow understanding and involved in the code migration from Dev to QA and Prod.
• Has given support in the Prod environment and also monitored the jobs.

Environment: Informatica Power Center 7.1, Teradata V12, Oracle, UNIX, PL/SQL, Cognos