SUMMARY

• 8+ years of total IT experience in Application Design, Data Modeling, Development, Implementation & Testing of Data warehousing and Database business systems.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation, Data Validation and Data Loading (ETL).
• Extensive Data Warehouse experience using Informatica Power Mart/ Power Center 7.x/8.x/9 (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, SQL Server and DB2 Databases.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
• Strong knowledge and experience in interacting with Oracle, SQL Server, DB2 databases with SQL/PL SQL programming.
• Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into staging area.
• Experience in writing UNIX shell scripts.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.
• Excellent communication and demonstrational skills for analyzing user requirements.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.
• Experience as a lead and managed team of 4 members.
• Experience in working Agile environment. (Scrum - Sprint tasks).
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Experience in Performance Tuning of Targets, Sources, Mappings, Sessions and Transformations.
• Worked with most type of complex transformations including slowly changing dimensions.
• Expertise on Informatica Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Good Knowledge in Informatica Power Exchange.
• Experience with Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000 , DB2, Teradata databases.
• Automation, Scheduling and monitoring of jobs with scheduler Auto Sys and Tidal.
• Excellent communication and demonstrational skills for analyzing user requirements.

TECHNICAL SKILLS

ETL TOOLS: Informatica Power Center 9.x/ 8.x/7.x/6.x (Designer, workflow Manager, Workflow Monitor, Repository Manager), Power Exchange, Data Stage, Oracle Business Intelligence(OBIEE), SQL*Plus & SQL*Loader

Data Modelling: Dimensional Data Modelling, Snow Flake Modelling, FACT and Dimensions Tables, Physical and Logical Data Modelling

Reporting Tools: Micro strategy, Oracle Business Intelligence(OBIEE), Data Stage, Business Objects

RDBMS: Netezza, Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, SQL Server 2000/ 2005, Teradata, MS Access.

Database Tools: Win SQL, Microsoft SQL Server, TOAD, SQL *PLUS, SQL Developer, SQL *Loader, Teradata SQL Assistant

Scheduling Tools: Tidal, AutoSys

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, Arizona

Sr. Informatica / ETL Developer

Responsibilities:

• Collected the requirements from Business people.
• Designed and developed the required tables in Netezza and Sql Server Databases.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Attending the daily scrums and giving the updates.
• Fine-tuned existing mappings for performance optimization.
• Unit and integration testing in both DEV and QA Environments.
• Worked on bug fixes on existing mappings to produce correct output.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Running the workflows daily, quarterly and scheduling the workflows using tidal and monitoring them.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of the Software Development Life Cycle (SDLC).
• Extracted the data from Flat files, Tables, Sap system and loaded the data into Data warehouse using Informatica Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created shortcuts for source and target.
• Created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Working with Business Analyst, translating business requirements into functional requirements.

Environment: Informatica (Power center 9.x), Workflow Manager, Informatica Designer, DB2, SQL, Netezza, Unix, Tidal for scheduling DB2 Connect, BO, Windows XP.

Confidential, Grand Rapids, MI

Sr.Informatica / ETL Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of the Software Development Life Cycle (SDLC).
• Extracted the data from Flat files and loaded the data into Data warehouse using Informatica Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created shortcuts for source and target.
• Created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Working with Business Analyst, translating business requirements into functional requirements.

Environment: Informatica (Power center 8.6.1/9.0.1 , ), Workflow Manager, Informatica Designer, DB2SQL, DB2 Connect, BO, Windows XP.

Confidential, Bloomington, Illinois

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange to develop the marketing data mart.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica.
• Extensively worked with Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed mappings in Informatica Power Center to load the data from various sources using transformations
• Extracted data from fixed width flat files to load into the DB2 staging area and then to the data mart.
• Strong understanding in analyzing insurance services and meet OLAP requirements through necessary architecture.
• Created views, triggers, stored procedures and functions for analyzing data.
• Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts and conducted data masking on testing environment to protect sensitive data.

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, Flat files, UNIX, Shell scripting, SQL Developer, BO, Teradata 13, Windows.

Confidential, FLORIDA

Informatica/ ETL Developer

Responsibilities:

• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created Entity relationship diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Created SQL tables with referential integrity and developed queries using SQL.
• Created complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Joiner and Aggregator transformations.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented various workflows using transformations such as Filters, update strategy, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Documented ETL development standards as per client requirement.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 8.3, Teradata, DB2, Oracle 10g, SQL, PL/SQL, TOADShell Scripts, UNIX (AIX), Erwin.

Confidential

Software Engineer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented Error handling logic to capture the invalid data.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning of Oracle PL/SQL Scripts.
• Designed and developed UNIX shell scripts.

Environment: Informatica Power Center 8.3, flat files, DB2, Oracle 10g, SQL, PL/SQL, TOAD.