SUMMARY

• Around 8 years of IT experience with more than 6 years of experience in Design, Development and Implementation of Data warehouses as an ETL Developer. Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica PowerCenter 9.1/8.6.
• Experienced in the Analysis, Design, Development, Testing of Data warehouses and Data marts. Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Experienced in using various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator etc. to load consistent data in to Oracle, SQL Serve databases.
• Worked on multiple Data warehousing projects with complete Software Development Life Cycle process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Analyzed, Designed and Implemented different stages of Data Warehouse.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, My SQL, MS Access, MS Excel and Flat Files into staging area. Also experience in Optimizing Database querying, data manipulation using SQL and PL/SQL in Oracle, flat files and SQL Server databases
• Experience in Audit, Balance checks and Error handling techniques.
• Experience in data profiling and data cleansing.
• Implemented complex business rules in Informatica by creating re - usable transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging mappings, tuning mappings, etc.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Good working experience on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Experience in providing post deployment warranty support and Production Support.
• Experience in writing UNIX shell scripts.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines. Self-starter with good interpersonal and communication skills

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Tampa, FL

RESPONSIBILITIES:

• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica.
• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer.
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Created reusable transformations.
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to Oracle data warehouse. Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Played major role in the Offshore / Onsite Model implementation.
• Code walkthrough with Developers & Client teams.
• Setting up of Unit / Integrated testing of interfaces (ETL) & documentation.
• Partly responsible for Informatica Administration, creating and administration Users and groups.
• Involving with developers and application team for Plan and coordinate database changes, installation of upgrades, patches and new versions, interacting with Design DBA and other infrastructure teams.
• Performed backup and recovery using Oracle 10g's user managed backup
• Implement the Database components (Stored procedures) . Alter the existing stored procedures as per design.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Responsible for Trouble shooting, Production support, Performance tuning and Batch monitoring activity.
• Provide Production Support, create Production Run book and Operations Manuals, address and resolve critical production issues.

Informatica Developer

Confidential, Hartford, CT

RESPONSIBILITIES:

• Involved in analysis of business requirements from the Data Management group for the newly identified external and internal source data for various business units.
• Worked extensively on Designing and Developing complex Informatica mappings and workflows which applied complex transformation rules, to populate "fact and dimension" tables of the Oracle analytics database/data warehouse.
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Involved in analyzing the source data coming from different Data sources such as Oracle, SQL Server, and identifying data anomalies in the source data.
• Coordinated with Business Users and the Offshore Development Team for solving design issues and requirements understanding for the coding phase.
• Extensively created complex mappings using transformations like Filter, aggregator, update strategy, lookup, router, stored procedure, sequence generator, and joiner using Informatica Power Center 8 x.
• Implemented slowly changing dimensions Type 2 using date method.
• Scheduled the Jobs to run at particular time/interval thru the Scheduler using Workflow Manager.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Wrote some complex Oracle Stored Procedures and functions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Use of Control-M tool to schedule various Informatica jobs and workflows.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Involved in Performance tuning at various levels including Target, Source, Mapping, Session for large data files.
• Designed and Developed UNIX Shell scripts to enhance the functionality of ETL application.
• Redesigned some of the mappings and mapplets in the system to meet new functionality.
• Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.

Datawarehouse and ETL Developer

Confidential, Thousand Oaks, CA

RESPONSIBILITIES:

• Gathered and documented the user requirements and report specifications on regular basis to maintain the integrity of the development.
• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Worked closely with data modelers on Erwin tool for dimensional modeling (Star schema).
• Created Mappings, Mapplet and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Worked with different types of partition techniques like key range, pass through

Systems Analyst/ETL Developer

Confidential

RESPONSIBILITIES:

• Developed the transformation logic, identifying and tracking the slowly changing dimensions from heterogeneous sources and determining the hierarchies in dimensions.
• Used transformations like Aggregator, Filter, Router, Sequence Generator, Update Strategy, Rank, Expression and lookup (connected and unconnected) while transforming Data according to the business logic.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked extensively on fixing invalid Mappings, and performing Unit and Integration Testing.
• Defined, captured metadata and rules associated with ETL process.
• Designed the layout of the pages.

Tools: Used: Informatica PowerCenter, SQL, PL/SQL, UNIX Shell Script, Oracle & SQL Server