SUMMARY:

• Over 7 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities.
• Have RDBMS concepts experience in Oracle 9i/8i/7.x, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2000/2005/2008.
• Sound Knowledge in Data warehousing concepts like Bill Inman Methodology, Ralph Kimball Methodology, Star Schema, Snow Flake Schema, OLAP, ROLAP, MOLAP, HOLAP, EDW, Data marts, Normalization, Dimensions, Facts,
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2/6.1 , OLTP, OLAP.
• Expertise in working with relational Databases i.e. Oracle 8/9i, DB2 UDB, Sales force
• Experienced in Error Handling and Troubleshooting Techniques using various log files.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services etc
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 8/9i with database objects like triggers, stored procedures, functions, packages, views, indexes.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts. Collaborated onsite teams, interacted and well managed various offshore teams.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Data Warehousing/ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II,Data Flux, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Databases: Oracle 9i/8i, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000,SQL Server,Postgress

Data Modeling: Star Schema and Snow: Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x

Tools: MS Office 97/2000/professional, SQL*Plus 3.3/8.0, TOAD,Microsoft Visio, Putty, Text Pad, .csv files, Erwin, ER Model, Salesforce Integration.

Programming Languages: Unix Shell Scripting, Oracle PL/SQL (Stored Procedures, triggers, Indexes).

Environment: Windows 98/2000/2003/ XP/NT and Windows NT, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, FL

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact with the requirements team and designers to get a brief knowledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Extract data from flat files, Oracle and to load the data into the Oracle database.
• Incremental extraction using CDC MD5 function
• Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Worked with slowly changing dimension Type2
• Designed and Developed Custom Mappings, Workflows
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Prepare test data for positive and negative test scenarios as per the business requirements
• Create and execute test cases
• Report the identified defects using Trac tool
• Keep track of the reported defects and support other teams to resolve defects
• Validate the data in source and target systems using SQL queries
• Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync

Environment: Informatica Power Center 9.1, UNIX, Oracle Database, SQL*PLUS, SQL*Loader, TOAD, UNIX

Confidential, MO

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact with the requirements team and designers to get a brief knowledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Extract data from flat files, DB2 and to load the data into the SalesForce database.
• Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Prepare test data for positive and negative test scenarios as per the business requirements
• Create and execute test cases
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Validating source data and Target data usnig Data Flux
• Report the identified defects using Trac tool
• Keep track of the reported defects and support other teams to resolve defects
• Validate the data in source and target systems using SQL queries

Environment: Informatica Power Center 9.1, DB2, SQL, UNIX, Control-M, Data Flux, Salesforce Database, Unix

Confidential, NY

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked with relational databases like ORACLE 9i.
• Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Worked with Source qualifier override, lookup override for customizing the SQL queries.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Implemented Type 1 and Type 2 Slowly changing dimensions for Dimension and Fact loads.
• Responsible for performance tuning at Mapping level, Session level, Source and Target level.
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Responsible for Unit Testing of Mappings and Workflows.
• Worked closely with reporting team and helped them whenever they had any ETL issues
• Responsible for creating and running the batch jobs in UNIX.
• Tested Mappings using Debugger.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Responsible for Production support, maintained the standard SLA in resolving the production failures.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Manager, Workflow Monitor), Oracle9i, SQL, Toad 9.7.2, Mapplets, Repository, UNIX, Flat files, Windows XP Professional

Confidential, DE

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements from business users, involved in modifying various technical & functional specifications in the development.
• Extensively involved in developing ETL code using Informatica in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Used Source Analyzer and Warehouse designer to import source and target elements, then Informatica powercenter designer to create complex mappings based on Business requirements.
• Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly incremental data loads.
• Created Mappings, Mapplets, Sessions and Workflows using Informatica Power Center 8.6.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Developed Datamaps from Mainframe systems and COBOL copy books using Informatica Powerexchange.
• Worked with health payer related data such as customers, policy, policy transactions, policy coverage, claims.
• Generated weekly and monthly report status for the number of incidents handled by the support team.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL
• Extensive PLSQL Programming with design and development of physical and logical data model using ERWIN.
• Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
• Used Control-M as Third Party Scheduling tool.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Involved in unit testing of mappings, mapplets also involved in Parallel Testing.

Environment: Oracle 10g, SQL, PL/SQL, TOAD 10.5, UNIX Shell Scripting, Informatica Power Center 8.6, Informatica PowerExchange, Windows XP, Control-M, WinSCP, Mainframe

Confidential

ETL Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Created mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and DB2
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning mappings for better performance and efficiency.
• Migrated mappings from Dev to Test and Test to Production repositories.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Refreshed reports using Scheduler.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Created various tasks like sessions, decision, timer & control to design the workflows based on dependencies
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in production support.

Environment: Informatica Power Center 7.1, Oracle 8, Windows 2000, TOAD, Erwin 4.0