SUMMARY

• Seven+(7+) years of Software Development Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Expertise in working wif Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gantt Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities.
• Has RDBMS concepts experience in Oracle 10g/9i/8i/7.x, SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2005/2008/2010.
• 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.5.1/9.1/8.6.1/8.1/7.1/6.2/6.1, OLTP, OLAP.
• Expertise in working wif relational Databases me.e. Oracle 10g/9i/8i, 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 and tuning SQL queries.
• 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 wif customers.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 10g/9i/8i wif 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, IDQ, SCD me, II,Data Flux, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008/2010, MS Access 2007/2010,DB2, SQL Server,Postgress, Teradata v6/r12

Data Modeling: Star Schema and Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio

Tools: MS Office 97/2000/professional, SQL*Plus 3.3/8.0, TOAD,Microsoft Visio, Putty, Text Pad, .csv files, Erwin 4.5/4.2/3.5/3.x, Salesforce Integration.

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Norwood, MA

Sr.ETL Informatica Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, flat files, XML files and loading into Staging and Enterprise Data Vault.
• Created technical specification for the development of Informatica extraction, transformation and loading (ETL) mappings in order to load data into classified tables.
• Worked in highly structured division across Informatica developers/Data Architects (data modeling team)/DBAs/Change Management etc.
• Assigning tasks to the development team and gave updates on a daily basis as in Agile/scrum methodology.
• Worked extensively on the ETL designs and development for HUB’s, SATELLITE’s, LINK’s ETL mappings using power center 9.5.1.
• Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy transformations.
• Designed and developed slowly changed dimensions (SCD) Type 2 and Type 1 for loading data into analytic layer.
• Worked wif business SMEs on developing the business rules for cleansing, Applied business rules using Informatica Data Quality (IDQ) to cleanse data.
• Presented Data Cleansing Results and IDQ plans results to the SMEs.
• Worked wif other consultants to develop IDQ plans to identify the possible data issues.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Created IDQ data profile and score cards for the research users to analyze the benefit trends.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
• Performed Code review to ensure dat ETL development was done according to the company’s ETL standard and dat ETL best practices were followed.
• Created Workflows wif worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Created and executed complex SQL queries and PL/SQL stored procedures for the initial bulk loads.
• Designed Automation process for daily/weekly ETL routine.
• Worked on ETL strategy to store data validation rules, error handling methods to handle both expected and non expected errors and documented it carefully.
• Responsible for migrating Informatica code across different environments (Dev, QA, Performace. PROD).
• Written scripts in Unix to read, update data in the target DB and also run batch jobs.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Conformed to project standards for Unit test/UAT testing. Carried out end to end testing and supported UAT effort wif immediate requirement document change/fixes/resolution for all changes/defects.
• Involved in database size estimation and in allocating the required SAN space across different layers.
• Created ETL design documents and flow diagrams.
• Used HP ALM Quality center to document ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, preparing test data and loading for testing, error handling and analysis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.

Environment: Informatica Power Center 9.5.1, IDQ 9.5.1, Erwin 9.5,Toad 3.6, SQL SERVER 2010, Oracle 10g/11g, XML, T-SQL, Unix, Batch Scripts.

Confidential, CA

Sr.ETL Informatica Developer

Responsibilities:

• Interacted wif business users for requirement analysis and to define business and functional specifications.
• Prepared and documented user requirements in low level and high level design format, translated requirements into system solutions and developed implementation plan and schedule.
• Involved in warehouse architecture design to populate data from various sources to teradata health care logical model.
• Extracted data from DB2 VSAM files, XML Files, Flat Files and populated into EDW
• Experience in writing and optimizing SQL code in TERADATA v6r12, Sybase 8.5 and stored procedures.
• Developed Complex transformations, Mapplets using Informatica Power Center 8.6.1/9.1.0 to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Excellent command of software development life cycle activities including analysis, design, development, unit and system testing and production deployment.
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings
• Managed the Metadata associated wif the ETL processes used to populate the data warehouse.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Implemented change data capture (CDC) using informatica power exchange to load data from clarity DB to Teradata warehouse.
• Developed multiples data marts using teradata for meeting the reporting requirements.
• Developed process for Teradata using shell scripting and RDBMS utilities such as MLoad, Fast Load(Teradata).
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Migrated development mappings as well as hot fixes them in production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Worked wifInformaticaData Quality 9.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.
• Created IDQ data profile and score cards for the research users to analyze the patient trends.
• Performed Code review to ensure dat ETL development was donse according to the company’s ETL standard and dat ETL best practices were followed.
• Created Workflows wif worklets, event wait, decision box, and email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Created and executed complex SQL queries and PL/SQL stored procedures for the initial bulk loads.
• Designed Automation process for daily/weekly ETL routine.
• Worked on ETL strategy to store data validation rules, error handling methods to handle both expected and non expected errors and documented it carefully.
• Responsible for migrating Informatica code across different environments (Dev, Test, QA, PROD).
• Written scripts in Unix to read, update data in the target DB.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Conformed to project standards for Unit test/UAT testing. Carried out end - to end testing and supported UAT effort wif immediate requirement document change/fixes/resolution for all changes/defects.
• Involved in database size estimation and in allocating the required SAN space across different layers.
• Created ETL design documents and flow diagrams.
• Used HP Quality center to document ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, preparing test data and loading for testing, error handling and analysis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.

Environment: Informatica Power Center 8.6.1/9.1.0, Sybase, SQL, DB2, PL/SQL, TOAD, SAP, Teradata v6r12,Erwin, SQL SERVER 2008, XML, T-SQL, UNIX, Shell Scripts, Rational Suite, Business Objects XI R2

Confidential, Pleasanton, CA

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked wif Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked wif relational databases like DB2.
• Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Worked wif 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.
• Excellent command of software development life cycle activities including analysis, design, development, unit and system testing and production deployment.
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings
• Managed the Metadata associated wif the ETL processes used to populate the data warehouse.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Migrated development mappings as well as hot fixes them in production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Involved in analyzing the year end process and managed the loads dat has yearend aggregations.
• Used the command line program pmcmd to run Informatica jobs from command line. And used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.
• Responsible for daily verification dat all scripts, downloads, and file copies were executed as planned, troubleshooting any steps dat failed, and providing both immediate and long-term problem resolution.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects wif the workflows and their dependencies.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: menformatica Power Center 8.6.1/9.1.0, SQL, PL/SQL, TOAD, Erwin, SQL SERVER 2008, XML, T-SQL, UNIX, Shell Scripts, Rational Suite, Business Objects XI R2

Confidential, Dallas,TX

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Interact wif the requirements team and designers to get a brief noledge of business logics.
• Review the Master Data Workbooks for better understanding of business logic.
• Conducted Review sessions wif SME’s and Business users for better understanding of the requirements.
• Extract data from flat files, Oracle 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 dat 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 8.6.1, Oracle 8i/9i, SQL, Windows, UNIX, Control-M, Data Flux, Salesforce Database, Unix

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked wif Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked wif relational databases like DB2.
• Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Worked wif 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 wif Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
• Responsible for Unit Testing of Mappings and Workflows.
• Worked closely wif 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 wif QA team during the testing phase and fixed bugs dat were reported.
• Responsible for Production support, maintained the standard SLA in resolving the production failures.

Environment: Informatica Power Center 8.1(Designer, Workflow Manager, Workflow Monitor), db2, Flat files, Windows XP Professional

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Responsible for gathering the business requirements and converting the same into technical specifications.
• Worked wif Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Worked wif 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 wif 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 wif 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 wif 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 wif QA team during the testing phase and fixed bugs dat were reported.
• Responsible for Production support, maintained the standard SLA in resolving the production failures.

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

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 wif the logic embedded in the mappings using Power center Designer.
• Worked on issues wif 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) wif 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