PROFESSIONAL SUMMARY

• 8 Years of strong experience in Information Technology Industry in Analysis, Design, Development, Testing and Maintenance of various data warehouse projects in Industry verticals such as BFS (Banking & Financial Services), Healthcare and Retail Industry.
• 8 Years of strong experience in Development, Testing, Maintenance and Support of ETL (Extraction, Transform and Load) using Informatica Power Center 9.0.1/8.1.6/7.1.4/6.1 Versions.
• An Expert in Informatica Power Center tool which includes components like Power Center Designer, Workflow Manager, Workflow Monitor & Repository manager. Extensively worked on ETL Informatica Transformations effectively including - Source Qualifier, Application Source Qualifier, Connected - Unconnected Lookup, Filter, Joiner, Expression, Normalizer, Stored procedure, Rank, Sequence Generator, Union, Sorter, Router, Mapplets, Reusable Transformations and Worklets.
• Expertise in tuning and optimizing teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
• Experience in Informatica Administration: Creating deployment groups, Users, Folders and optimizing Informatica Server settings for optimal performance.
• Proficient in Unix Shell Scripting and ETL process automation using TIDAL Scheduler and Control M Scheduler.
• Implemented CDC (Change Data Capture), slowly changing Dimension methodologies for real time data warehousing environments.
• Implemented IDQ Address standardization mapplets to standardize validate and format client’s addresses for marketing purposes.
• Very strong in Relational Databases (RDBMS), Data modeling and Design and build Data Warehouse, Data Marts using Star Schema and Snow Flake Schema for Faster and effective Querying.
• Experience in writing & execution of Test Cases, developing and maintaining Test Scripts according to teh business specification and Defect management.
• Proficient in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to teh data warehouse model.
• Experience working with databases like Oracle 10G/ Netezza 6/ SQL Server 2008/ IBM DB2/ POSTGRESS.
• Experience providing On Call Production support to all teh Enterprise Data Warehouse ETL Schedules. Experience resolving in ongoing maintenance issues and Work orders.
• Ability to understand teh available technology, tools and existing designs, and work on complex problems.
• Excellent problem solving with good Interpersonal skills, Quick learner and adaptive to new, challenging technical environments and versatile team player with ability to work independently as well with team members.

TECHNICAL EXPERTISE

Data Warehousing:Informatica Power Center 9.0.1/8.1.6/7.1.4/6.1

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Schema Modeling, Relational Modeling, Physical and Logical Modeling.

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2000/2003/2005/2008, Netezza, IBM Db2, MySQL

Tools: MS Office, TOAD, Secure CRT, PL/SQL Developer, WinSQL, Putty, WinSCP

Operating Systems: Windows 9x/NT/2000/XP, UNIX (AIX)

Schedulers: Tidal, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Senior ETL Developer

Responsibilities:

• Performed Repository Administration tasks like creating Repository, User groups, Users and managing users by setting up their privileges and profiles for Development, QA, Pre-production and Production environments.
• Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts (SME).
• Wrote and reviewed documents like Functional Specifications (FS), and ETL Specifications.
• Involved in ETL Process Flow Chart.
• Established standard code migration process.
• Extracted data from a wide variety of Sources like Flat files, XML files, Relational Databases (Oracle, SQL Server) and from teh legacy Mainframes and SAP source systems by using Informatica PowerExchange.
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Used shortcuts to reuse objects without creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Created User defined functions (UDF) to reuse teh logic in different mappings.
• Extensively used mapping parameters, mapping variables to provide teh flexibility and parameterized teh workflows for different system loads.
• Implemented teh Error Records Handling mechanism.
• Created UNIX shell scripts to handle pre and post session tasks.
• Creation of sessions and workflows according to teh data load in to different systems.
• Created and tested shell scripts to automate Job scheduling by using commands like pmcmd.
• Data investigation in teh analysis of incoming data from teh various source systems, documenting teh data anomalies and generating Data Quality reports.
• Involved in different phases of testing like Unit, Functional, Integration and System testing.
• Creation of Review documents for specification document and test cases.
• Performance tuning of targets, sources, mappings and sessions.
• Troubleshoot loading failure cases, including database problems.
• Code migration from development to QA and production environments.
• Developed and tested stored procedures, functions and packages in PL/SQL.
• Involved in database testing, writing complex SQL queries to verify teh transactions and business logic like identifying teh duplicate rows by using SQL Developer and PL/SQL Developer.
• Prepared documents like Deployment Doc, Estimation Reports, Tractability Reports, Development tracking report and weekly status reports (WSR).

Environment: Informatica PowerCenter v9.0.1, Oracle 10g/9i, Tidal Schedular,Windows-XP (Client), Informatica servers on Unix (Solaris), Netezza, PL/SQL Developer.

Confidential, Colegeville, PA

Senior ETL Developer

Responsibilities:

• Code migration from development to QA and production environments.
• Analysis of requirements and finding teh gap between use cases, User interface documents and ETL specifications.
• Creation of ETL Design documents with teh halp of use cases and User Interface documents, Business rule documentation and PDM.
• Prepared process level reports such as Regression Testing Reports, Execution Reports, Effort Estimation Reports, Tractability Reports, and Change Request (CR) Estimation Reports etc.
• Creation of mappings according to teh use cases by following teh ETL specifications.
• Creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Joiner, Union, Aggregator, Sorter, Sequence generator, Router, Update Strategy, and Stored procedure.etc.
• Extracted data from of different types of Flat files, Oracle.
• Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
• Implemented teh Error handling mechanism.
• Created and tested Power Exchange Data maps for Oracle CDC capture.
• Involved in identifying teh Power Exchange Oracle CDC limitations and supplementary solutions.
• Involved in migrating teh power center maps.
• Implemented SCD Type 1 and SCD Type 2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications. .
• Involved in Unit, Functional, Integration and System testing and preparation review documents for teh same.
• Extensively used mapping parameters, mapping variables to provide teh flexibility and parameterized teh workflows for different system loads.
• Involved in Load schedule plan.
• Creation of sessions and workflows according to teh data load in to different systems.
• Maintained Coding standards and participated in Code Review.
• Involved in Performance tuning of mapping level and session level.
• Involved in scheduling teh jobs in Control M using UNIX scripts and even developed PL/SQL stored procedures.
• Involved in loading all Batch Scheduling tables with teh halp of UNIX script.
• Maintained all teh documents in teh clear case and CVS for Version control.

Environment: Informatica Power center 8.1.6, Oracle 10g, Clear case, MS Office, DB2, UNIX - AIX 5, Windows XP.

Confidential, NJ

ETL / Informatica Developer

Responsibilities:

• Understood existing business and customer requirements.
• Involved in designing teh mappings between sources and targets and also tuned them for better performance.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy.
• Code migration from development to QA and production environments.
• Extracted data from of different types of Flat files, Relational Databases Oracle.
• Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
• Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.
• Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications.
• Involved in Unit testing and System testing and prepared Test plan documents
• Extensively used mapping parameters, mapping variables to provide teh flexibility and parameterized teh workflows for different system loads.
• Creation of sessions and workflows according to teh data load in to different systems.
• Maintained Coding standards and participated in Code Review.
• Involved in Performance tuning of mapping level and session level.

Environment: Informatica Power Center 7.1.4, Windows XP, UNIX, Oracle 8i.

Confidential, OH

Data Warehouse Developer

Responsibilities:

• Analysis of requirements and finding teh gap between use cases, and ETL specifications.
• Created Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy.
• Created and executed sessions using Workflow Manager and monitoring sessions by using Workflow Monitor. Code migration from development to QA and production environments.
• Extracted data from of different types of Flat files, Relational Databases Oracle.
• Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
• Implemented SCD Type 1 and SCD Type 2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications.
• Involved in Unit testing and System testing and prepared Test plan documents.
• Extensively used mapping parameters, mapping variables to provide teh flexibility and parameterized teh workflows for different system loads.
• Creation of sessions and workflows according to teh data load in to different systems.
• Maintained Coding standards and participated in Code Review.
• Involved in Performance tuning of mapping level and session level.

Environment: Informatica Power Center v7.1.4, Windows XP, UNIX, Oracle 7i.

Confidential

Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Prepared technical documentation, design transformations that are consistent with teh goals of teh existing data warehouse, and worked with teh development team to implement teh solution
• Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.
• Used teh Workflow Manager to create Workflows, Worklets and Tasks.
• Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.
• Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Informatica Power Center v6.1, PowerMart 6.2, Oracle 9i, PL/SQL, Toad 7.6, Windows, UNIX.