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.5, 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.5 / 8.x.
• 8 Years of Experience Oracle database 11g/ 10g.
• 4 Years of experience in Teradata/MS SQL database.
• 6 Years’ Experience in writing UNIX Scripting.
• Having very good knowledge and experience in working with Consumer banking, loans and Credit systems.
• 3 Years of Experience in production support team and handling production issues on timely manner.
• Extensively worked in Code deployment from UAT to Production environments also supported Pre and Post production activities.
• Have experience on working with data validations and Unit testing the components. Worked closely with the QA team on testing the data in UAT, Production environment and data migration project.
• Analyzed, Designed and Implemented the ETL architecture using ETL Informatica, SQL * Loader, PL/SQL.
• Worked onInformatica Power Center 9.1.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.
• Having good Knowledge on the concepts and architecture of Netezza RDBMS.
• Participated in the Big Data and Hadoop corporate training.
• Having Good knowledge on Big data - Hadoop 2.5 HDFS Architecture, Map Reduce, Hive, Sqoop, Hbase.
• Excellent knowledge in OLAP reporting tools such as BUSINESS OBJECTS/OBI.
• 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 on fixing 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, Bloomfield, CT

Sr. ETL Developer & Tester

Responsibilities:

• Involved in Analysis, Design and Development of ETL Mappings for raw data loading and for building star schema using Informatica Power Center 9.5, Oracle 11g, Teradata V2R14.
• Created different interfaces to load the data to Health e-view Data Mart, Clinical Service Mart from different sources (flat files, Oracle, SQL Server).
• Developed the Informatica Mappings by using of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created mappings and mapplet using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update strategy.
• Troubleshoots batches and sessions for daily, weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in data validation testing in UAT, Production environment also extensively worked on Pre & Post production activities.
• Worked on creating PL/SQL Packages, Procedures for loading the data in to Health-E View data mart which gives reports to the Customer reporting systems.
• Worked on creating UNIX scripts for sending the status reports.
• 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 Center 9.5, Oracle 11g, Teradata V2R14, SQL Server 2008, Windows XP, HP-UNIX, LINUX.

Confidential

Sr. ETL Developer & Tester

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 Center 8.6, Oracle 10g.
• Worked on Informatica Power Center 8.6 client tools - Mapping designer, Workflow, Monitor.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
• Deploy the mappings and scripts between various environments like the Development, QA and production.
• Used Informatica Debugger to test the mappings and fixed the bugs.
• Facilitated the Production move ups of ETL components from Acceptance to Production environment.
• Involved in Pre and Post implementation activities also on worked on impact analysis and fixing the production issues.
• Worked on creating UNIX scripts.
• Involved in Issue tracking and code debugging of ETL Mappings.

Environment: Informatica Power Center 8.6, Oracle 10g, Windows XP, TOAD, HP-UNIX, LINUX.

Confidential

Sr. ETL Developer

Responsibilities:

• Extensively involved in design and development of ETL Mappings for building the DIH (Data Integration Hub) using Informatica Power Center 8.5, Oracle 10g.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.

Environment: Informatica Power Center 8.5, Oracle 10g, Windows XP, UNIX.

Confidential - Houston, TX

Sr. ETL Developer / PL SQL Developer

Responsibilities:

• Running the daily ETL Mappings to pull the data from different source system and load in to the staging tables using Informatica Power Center 8.5 Workflow manager.
• Developed Informatica ETL mapping, session and workflows.
• Created PL/SQL objects for generating weekly, monthly reports.

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

Confidential

ETL Developer

Responsibilities:

• Extensively involved in designed, developed ETL Mappings for various F@ST CPM & CVF subject areas using Informatica Power Center 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.

Environment: Informatica Power Center 8.5, Oracle 10g, Teradata V2R5.1/V2R6.1,Autosys, Unix-AIX 5.2Toad, PL/SQL, SQL*LOADER, Query Man SQL Assistant & PVCS.