SUMMARY

• About 8 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Worked on various domains; Insurance, Financial services and Retail
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• ExpertiseintheDataAnalysis, Design, Development, Implementation, Testing, Production Support of Database/Datawarehousing applications for various industries using Data Modeling, Data Extraction,Data Transformation andDataLoading.
• Worked in various Heterogeneous Source Systems like Oracle, MS SQL Server, Teradata and Flat files.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Expertise in creating high level and detailed level design documents.
• Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Extensively worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• Proficiency in design and developing the ETL objects using Informatica Power center with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Extensively created mapplets, common functions, reusable transformations and look-ups for better usability.
• Implemented Slowly changing dimension types (I, II &III) methodologies for accessing the full history of accounts and transaction information designed and developed change data capture solutions (CDC) for the project, which captures and analyses changes from daily feeds to maintain history tables.
• Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
• Effectively communicate with business, project manager and team members.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
• Experienced in using database interface tools like Toad and PL/SQL Developer.
• Automated Informatica flow of loading data by using Control-M and Autosys.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.1/8.6/7.1.2, MSBI Suite(SSIS/SSAS/SSRS)

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, Teradata v2r12/v2r6/v2r5

Programming Languages: C, SQL, PL/SQL, UNIX, Java

BI Tools: SSRS

Operating Systems: Windows 7/Vista/Xp

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL/Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Involved in Initial loads, Incremental loads; Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL server 2008, Toad, Winscp, UNIX.

Confidential, Pennington, NJ

ETL/Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6/9.1
• Experience in integration of heterogeneous data sources like Oracle, Teradata, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/ exported/ imported the mappings/ sessions/ worklets/ workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5/9.1, Oracle 10g, SQL Server 2008, SQL Developer, Flat files, UNIX, Windows Xp

Confidential

ETL/Informatica Developer

Responsibilities:

• Developing Informatica mappings for loading trading and clearing data from various clients.
• Actively participated in a team in the logical and physical design of the data warehouse.
• Closely associated with data architect in resolving the data issues.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, Excel files, CSV files etc.
• Responsible for working closely with the Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the production environment.
• Extensively used the Lookup and Update Strategy Transformations for implementing the Slowly Changing Dimensions.
• Used different tasks like Email, Command task.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
• Involved in the mirroring of the staging environment to production.
• Created and reviewed the Design and Code review Templates.
• As a part of the testing team, Involved in conducting the Unit tests and System tests.
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Developing control files, Stored Procedures to manipulate and load the data into Oracle database.

Environment: Informatica Power Center 7.1.2, Oracle 8i, PL/SQL MS SQL Server, Autosys

Confidential

ETL/Data warehouse Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center, Repository Manager and Designer.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Flat files and tables from Oracle database as sources.
• Designed and coded mappings, which extracted data from existing, source systems into the data warehouse.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make event based scheduling
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, SQL/PLSQL, UNIX, Oracle 8i, Control-M