SUMMARY:

• Around 8 years of Data Warehousing and ETL development experience in Insurance and Pharmaceutical domains.
• Strong understanding of Data modeling concepts.
• Experience in working with Star schemas, Dimensional models and Data Mart for large scale implementation of the data warehouse.
• Proficiency in data - warehousing techniques for Data cleansing, Data Analyzer, Slowly changing dimension phenomenon, Surrogate key assignment.
• Design Source to Target maps, Code migration, Version control, Scheduling tools, Shared folders, Data movement, Naming in accordance with ETL Best practices, Standards and Procedures.
• Extensive experience in Extraction/Transformation/Loading (ETL) data from Relational and Legacy Systems like Oracle, DB2, SQL Server, Mainframe, Flat files and XML files into Data Warehouse and Data Mart using Informatica PowerCenter.
• Well acquainted with various components of InformaticaPower Center (9x/8x) like PowerCenter Designer, Repository Manager, Work Flow Manager and Work Flow Monitor.
• Strong experience in creating Informatica mappings using various transformations like Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Experience in using the Informatica command line utility pmcmd to operate workflows and control sessions and tasks.
• Created Workflows and used various tasks likeEmail, Timer, Scheduler, Control, Decision, and Sessionin the workflow manager.
• Good experience with using repository manager and involved in Code deployment.
• Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
• Excellent knowledge in identifying performance bottlenecks and tuning of the Informatica Load for better performance and efficiency.
• Experience in conducting Test Data/unit Testing/Integrated Testing and generation of various test cases.
• Extensive knowledge of PL/SQL and SQL programming.
• Worked closely in setting up the environment for various file transfer activities between the systems using SFTP as the file transfer protocol.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Experience in Scheduling WFs through AutoSys.
• Experienced in developing Dashboards Reports inCognos8 and 10
• Good Team Management skills with experience in handling teams with 5+ members having worked in both Offshore and Onsite locations.
• Excellent analytical and problem solving skills with ability to interact with individuals at all levels.
• Good team player, strong interpersonal and communication skills combined with self-motivation and initiation.

TECHNICAL SKILLS:

Database: Oracle 11g/10g, Teradata, Netezza, DB2 and SQL Server 2005/2008

Programming Languages: SQL, PL/SQL, UNIX shell scripting, Perl and C

ETL Tools: Informatica Power Center (9.5/9.0.1/8. x), Data Stage, SSIS, SSRS, Tableau and Confidential Sterling B2B Integrator

Data modeling: Erwin 4.x

Other Tools: TOAD, Cognos, Autosys and Oracle SQL Developer

WORK EXPERIENCE:

Confidential, Malvern, PA

Sr. Informatica Developer

Responsibilities:

• Involved in gathering requirements and acquiring application knowledge from the Business.
• Created ETL detail design document and ETL standards document.
• Designing mappings as per the business requirements Using Transformations such as Aggregator, Expression, Lookup, Filter, Sequence generator, Union, Update strategy, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Createdreusable transformationsandMappletsand used them in complex mappings.
• Design and development of complex ETL mappings making use of Connected/Unconnected Lookups, Normalizer.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Extensively used Mapping Variables, Mapping Parameters to execute complex business logic.
• Extracting data from sources like Oracle, Flat Files using Power center designer and transforming them using the business logic and loading the data to the target warehouse.
• Created and Configured Sessions and Workflows using informatica scheduler.
• Used various tasks likeEmail, Timer, Scheduler, Control, Decision, and Sessionin the workflow manager.
• Hands on experience in Performance Tuning at various levels such as Source, Target, Mapping and Session.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, sequence buffer length.
• Extensively worked on correcting and reloading rejected files.
• Used the command line program Pmcmd to communicate with the Informatica Server.
• Prepared unit test cases and performed unit testing to check whether the data loads into target are accurate.
• Used debugger in debugging some critical mapping by setting breakpoints and trouble shot the issues by checking sessions and workflow logs.
• Worked closely in setting up the environment for various file transfer activities between the systems using SFTP as the file transfer protocol.

Environment: Informatica PowerCenter 9.5, Oracle 11g/10g, SQL Server, SQL*Plus PL/SQL and Autosys.

Confidential, Omaha, NE

ETL Developer

Responsibilities:

• Involved in gathering requirements from end users.
• Implemented business plan based on required technical and business needs.
• Extensively used Informatica PowerCenter to create mappings, mapplets, transformations, re-usable transformations, etc.
• Developed and designed jobs using Informatica Designer based on mapping specifications using appropriate stages.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing.
• Experience in migrating data from Oracle database using Informatica as ETL.
• Experience in using sql loader to load data from the given data-file into table or tables created in the database.
• Worked on different tasks in workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, assignment, timer and scheduling of the workflow.
• Used pmcmd command to start, stop and ping server from UNIX and created UNIX SHELL Scripts to automate the process.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.
• Provided production support and performed enhancements on existing projects.

Environment: Informatica PowerCenter 9.5/9.0.1, Cognos 10, Oracle 11g/10g, Toad, SQL Server, Erwin, UNIX, AutoSys Scheduler.

Confidential

ETL Developer

Responsibilities:

• Involved in preparation of technical specifications for the development of Informatica (ETL) mappings and development of Data Warehouse.
• Worked with InformaticaPowercenter client tools likeSource Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository ManagerandWorkflow Manager.
• Created mappings using various transformations like Aggregator, Filter, Joiner, Expression, Source qualifier, Lookup Connected/Unconnected, Sequence generator and Router.
• CreatedMapplets, reusable transformationsand used them in different mappings.
• Used Informatica ETL to load data from different databases and flat files to Oracle.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Tuned the Informatica mappings for optimal load performance.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• UsedDebugger to check the errors in mapping.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Performed unit testing to check whether the data loads into target are accurate.

Environment: InformaticaPower Center 8.6, Confidential Sterling B2B Integrator, Cognos, SQL server, Oracle 10g, Teradata, DB2, Flat Files, XML, Windows, UNIX and TOAD.

Confidential

Jr. Informatica Developer

Responsibilities:

• Analyzed thespecificationsand identified the source data that needs to be moved to data warehouse.
• Extracted data from flat files and oracle databases and loaded it into Oracle usingInformatica 7.1.
• Developed number of Complex Informatica Mappings,MappletsandReusable Transformationsto facilitate initial, weekly and monthly loading of data.
• Usedworkflow monitorto monitor the workflow and reviewed error logs that it generates for each session.
• Usedparametersandvariablesat mapping and session levels to improve the performance of Mappings.
• Worked onPerformance Tuningof various mappings and sessions to identify and remove Bottle Necks.
• Used Informatica PowerCenter workflow manager to create sessions, workflows and worklets to run with the logic embedded in the mappings.
• Useddebuggerto test the mappings and fixed the bugs.
• Documentedfunctional specifications and other aspects for the development of ETL mappings used.

Environment: Informatica Power Center 7.1, Oracle 8i, PL/SQL, Erwin and Toad

Confidential

Oracle Developer

Responsibilities:

• Created various database (Oracle 8i) objects like tables, views, functions, procedures, packages and Triggers etc.
• Performance tuning of SQL queries.
• Trained End Users for Usage of the GUI.
• Identifying run time coding errors and resolving them.
• Provided production support by running the jobs and fixing the bugs.
• Documented the process for further maintenance and production support.

Environment: Oracle 8i, Windows 2000, PL/SQL, Toad .