SUMMARY

• Over 8 years of IT experience which includes 6+ years of experience in Design, Development, Implementation and testing of ETL, Data Warehousing applications using the Informatica Power Center 7.x/8.x. /Power Mart 5.x/6.x.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Proficient in transforming data from various sources (flat files, DB2, XML, Oracle) to Data warehouse using ETL tools.
• Vast experience in Designing and developing complex mappings from varied transformation logics like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Slowly changing dimensions (SCD).
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server /2008, Netezza 5.1, Teradata, MS Access
• Experience in developing mappings using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Experience in developing Slowly Changing Dimension Mappings of type I, II and type III
• Experience in database development using PL/SQL, SQL PLUS, TOAD, SQL - LOADER.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Knowledge on Cognos reporting tool.
• Hands on experience in using Dimensional Data Modeling tool ERWIN for designing FACT and Dimension Tables,
• Hands on Experience in Physical and Logical Data Modeling, Normalization and Denormalization techniques
• Experience in UNIX Shell scripting.
• Good knowledge in ADMIN tasks creating database links, users, folders and maintaining the repository
• Actively involved in Performance Tuning, Backup and Recovery process, production support on various platforms.
• Experienced in Financial Services, Commercial, Retail and Insurance domains.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 7.1/8.1/8.6/9, PowerMart 5.0/5.1.1/ 6.2

Databases: Oracle (8i, 9i, 10g), DB2, SQL Server, Sybase, MSSQL Server2000/2005, Netezza 5.1, MS- Access

Operating Systems: Microsoft Windows (NT 4.0/XP/2000/VISTA), UNIX.

Tools: & Utilities: TOAD 8.5, Erwin 4.0/2.6

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Informatica Developer

Responsibilities:

• Designed Source to target mappings in detail for the design approach for Extract Transform and Load (ETL) development.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Delta load logic is used to process new record to Data mart and process modified record if the modified date is greater than previously modified data already loaded in Staging / Data mart tables.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created E-mail notifications tasks using post-session scripts.
• Wrote SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency
• Involved in Unit, Integration, system, and performance testing levels.
• Maintaining the ETL for the whole team by Designing, developing, testing and deploying.
• Worked on SSAS 2000.
• Extensively working on SSAS 2005 and scheduling using SSIS and SQL Server Agent.
• Monitoring directories, resolving space issues.
• Scheduled Stored Procedures for the Process improvement.
• Maintaining the FTP scripts involved in huge file movement.
• Provided Knowledge Transfer and regularly communicated with Daily meetings in helping the offshore team to build and maintain the BO reports.

Environment: Informatica Power Center 9/8.1, Oracle 10.g, SQL Server 2005, Windows 2003, AIX 3.5, Analysis Services 2005, Microsoft Front Page, SharePoint Designer, Lite Speed, FTP Utilities

Confidential, Pleasanton, CA

ETL Developer

Responsibilities:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files and load into Warehouse through STAGE and ODS.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Implemented Change data Capture (CDC) in Oracle
• Worked on UNIX machine to connect to the Oracle database and run PL/SQL scripts.
• Tuned SQL queries for better performance.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations for Date Conversion.

Environment: Informatica Power Center 8.1, Oracle 9i, Toad, ERWIN 4.0, Unix-AIX4.3, Test Director 8.0, VSAM, Business Objects 6.5.

Confidential, NJ

ETL Developer

Responsibilities:

• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica Power Center.
• Involved in developing source to target mappings and scheduling Informatica sessions for FACETS.
• Expertise in writingBTEQscripts in Teradata and running them by writing korn shell scripts in Linux and UNIX environments.
• Expertise in creatingMLOAD, Fast loadandT Pumpcontrol scripts to load data to the IDW.
• Build tables, views,UPI, NUPI, USIandNUSI.
• Written severalTeradata BTEQ scriptsto implement the business logic.
• Worked exclusively with theTeradata SQL Assistantto interface with the Teradata
• Populated data into Teradata tables by usingFast Loadutility.
• Created Teradata complexmacros and Views, functions, and stored proceduresto be used in the reports.
• Worked in writing UNIX scripts, SQL statements and interacted with development and production teams to expedite the process.

Environment: Informatica Power Center 8.6.1, DB2, Teradata, Windows server 2003, SQL, PL/SQL, XML, Business Objects 6.5.

Confidential, NJ

Informatica ETL Developer

Responsibilities:

• Involved in designing, development and implementation of the SSRDM.
• Developed Mapplets using corresponding Source, Targets and Transformations that sourced data from ODBC and flat file reports as well as relational databases.
• Used debugger to test the mapping and to fix bugs.
• TunedInformaticaMappings and Sessions for optimum performance. tested with high volume of data and increased the performance significantly.
• Good Working Experience in slowly changing dimensions type 1, 2, 3.
• Worked on different tables using the constraint based loading applying foreign key.
• Worked with Autosys scheduler and created database triggers for Data Security.
• Worked with UNIX shell scripting.
• Monitored daily loads and providing on call production support during data loads.
• Optimized the load schedules and load timings.

Environment: InformaticaPower Center 8.6, Oracle 11g/10g, Mainframes, Autosys, SQL * Loader, Toad, UNIX, Business Objects, Sun Solaris, Windows.

Confidential, VA

ETL Developer

Responsibilities:

• Analysis of business requirements for end-to-end ETL process
• Worked closely with business analysts to understand the business needs for decision support data
• Analyzed and Created Facts and Dimension Tables for star schema
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data Mart.
• Developed various Sessions, Batches for all Mappings to load from Source flat files tables to Target tables
• Creation of Transformations like Sequence generator, Lookup, joiner and Update Strategy transformations in Informatica Designer
• Wrote shell scripts for data validation and reconciliation
• Extensively worked on the tuning of mappings and sessions
• Wrote stored procedures for dropping and re creating indexes for efficient Data Load
• Responsible for information gathering and data analysis
• Used pmcmd command for running of the sessions.
• Used UNIX Cron tab scheduler to schedule the sessions.

Environment: Informatica Power Center 7.1, Netezza 5.1, PL/SQL, Oracle9i, Windows NT, HP-Unix.

Confidential

ETL Programmer/Database Analyst

Responsibilities:

• Actively participated in the requirement analysis, database design and modeling.
• Developed ETL mappings on Informatica and scheduled the jobs as regular process. performed ETL tasks such as trigger based loading of data.
• Involved in database administration. Design, development and implementation.
• Assisted in the Development of several reports including tabular, master detail reports.

Environment: Informatica Power Center 7.1, Oracle 8i, SQL, PL/SQL, TOAD, Oracle Developer 6i, WinNT4.0.

Confidential

Jr. Database Developer

Responsibilities:

• Responsible for SQL coding using SQL/PLUS
• Responsible for PL/SQL Programming
• Created database objects like tables, views, synonyms, indexes.
• Worked with DBA in Installing Oracle 8i on UNIX
• Developed Database Triggers, procedures, functions and packages
• Extensively worked with SQL Loader for loading the data from Flat files in to oracle

Environment: Oracle 8i, PL/SQL, SQL*Loader, SQL, UNIX.