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:

Client: Confidential, FL

Role: 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

Client: Confidential , MO

Role: 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

Client: Confidential, NY

Role: 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

Client: Confidential, DE

Role: 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

Client: Confidential

Role: 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