SUMMARY

• Over 10 years of IT experience in software development, client - server Technology which includes 8 plus year of extensive experience in Designing Data warehouse with strong knowledge in gathering Business Requirements, Analysis, Data Modeling, Development, Testing using ETL tools like Informatica Power center 9.1, PL/SQL and Databases such as Oracle 11g/10g, Teradata V2R14, MSSQL & DB2. Good knowledge and experience in Health Care, Banking sector and Manufacturing domains.
• Over 8 years of experience design, analysis development of ETL based solutions for EDW and OLTP applications.
• 7 Years of Experience in working with ETL Informatica 9.x / 8.x.
• 8 Years of Experience Oracle database 11g/ 10g
• 4 Years of experience in Teradata/MS SQL database.
• 6 Years’ Experience in UNIX Scripting.
• 3 Years of Experience in production support team.
• Analyzed, Designed and Implemented the ETL architecture using ETL Informatica 9.x/8.x, Oracle 11g/10g, UNIX/LINUX and PL/SQL.
• Worked onInformatica Power Centre 9.x & 8.xclient tools -Mapping designer, Workflow manager, Workflow monitor, Mapplet designer and Transformations.
• Developed complex mappings with transformationslike lookup, Union, router,aggregator, expression, update strategyandjoinerconfirming to the business rules and documented.
• Good knowledge of using mapping Parameters & Parameter files.
• Worked with logical, physical, star, snow flake schema data models.
• Excellent knowledge in OLAP reporting tools such as BUSINESS OBJECTS/OBI.
• Very Good working knowledge in IBM Web Sphere DATASAGE 7.5.2client tools -Designer, Manager, Director and Administration.
• Worked on performance tuning of mappings, transformations and sessions to optimize session performance.
• Created test cases and user acceptances test scenarios. Involved in Unit, Integration, system, and performance testing levels.
• Associated with Production support team and helped with various issues and failures.
• Strong in SQL, PL/SQL scripting, created the database objects like Functions, Procedures and Packages.
• Strong in Debugging and resolving the data issues.
• Possess excellent communication skills and would be an asset to any team.

PROFESSIONAL EXPERIENCE

Confidential, CT

Sr. ETL Developer

Responsibilities:

• Involved in Analysis, Design and Development of ETL Mappings for raw data loading and for building star schema using Informatica Power Centre 9.1, Oracle 11g
• Designed and developed ETL Mappings to build Health e-view Data Mart, Clinical Service Mart which feeds data to mycigna portal where customer can view the status of their programs and incentives.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Worked on creating PL/SQL Procedures and Function in Oracle 11g.
• Extensively developed Mappings, Sessions, Workflows from Development to Test and then to Prod environment.
• Worked in design, development & Integration phase, worked with multiple teams Data Architect, DBA’s, QA Teams, Business for UAT testing and finally with Prod Ops team in deployment the code to go live in production.

Environment: Informatica Power Centre 9.1, Oracle 11g, Windows XP, UNIX and Teradata V2R14.

Confidential

Sr. ETL Developer

Responsibilities:

• Extensively involved in analysis, design and development of ETL Mappings for loading the customer base used for Credits, Cards & Retail banking for LATAM & EMEA countries using Informatica Power Centre 8.5, Oracle 10g.
• Extensively used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Extensively worked with transformationslike lookup, Union, router,aggregator, expression, update strategyandjoiner.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Involved in Production support activities.
• Involved in Issue tracking and code debugging of ETL Mappings.
• Extensively involved in design and development of ETL Mappings for building the DIH (Data Integration Hub) using Informatica Power Centre 8.5, Oracle 10g.
• Extensively worked with transformationslike lookup, Union, router,aggregator, expression, update strategyandjoiner.
• Running the daily ETL Mappings to pull the data to the WMS system and load in to the staging tables using Informatica Power Centre 8.5 Workflow manager.
• Created LB verify and Populate Summary Effectiveness PL/SQL procedure for generating weekly, monthly reports.

Environment: Informatica Power Centre 8.5, Oracle10g, B.O XIR3.0, Unix-AIX 7.1, Toad.

Confidential - Detroit, MI

ETL Developer

Responsibilities:

• Extensively involved in designed, developed ETL Mappings for various F@ST CPM & CVF subject areas using Informatica Power Centre 8.5.
• Extensively worked in enhancement of the existing TPDB, ODS and TERADATA DWH systems.
• Worked in performance tuning for various ETL Mappings and PL/SQL scripts using TKPROF, EXPLAIN PLAN utilities.
• Extensively utilized Teradata utilities for loading the data in to CPM DWH system.
• Performed unit, Integration, QA, UAT Testing. Also responsible for mapping, functional specification, Testing and Desk procedure tracker documentation.
• Designed and Developed Data stage ETL jobs using IBM Data stage 7.1.
• Developed many Packages, Procedures, Triggers and Functions using Oracle PL SQL.
• Developed Forms and Reports using Oracle 6i.

Environment: IBM Data Stage PX 7.1, Oracle 9.i, Forms 6i, Reports 6i, Toad, PL/SQL, SQL*LOADER.