SUMMARY

• 8 years of experience in Data Warehouse Business Intelligence domain with projects involving Informatica and ETL tools.
• Extensive experience working with Data Warehouses and Data Marts using Informatica Power Center 6.x, 7.x, 8.x, 9.x Designer, Repository Manager, Workflow Manager and Workflow Monitor .
• Responsible for interacting with different Business Partners, Vendors Customers to identify information needs and business requirements for reports.
• Responsible as a Mentor in training newly hired contractors with the knowledge of Business and the Data flow concepts.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Extensive knowledge in designing functional and detailed design documents for data warehouse development.
• Experience in writing UNIX Shell scripts.
• Experience in writing Stored Procedures and Functions PL/SQL and T-SQL .
• Performance tuning of Oracle using SQLtrace, SQLplan, SQL hints, Oracle partitioning, various indexes and join types and PL/SQL tuning.
• Working knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Oracle, SQL Server, DB2.
• Knowledge on Informatica Data Explorer IDE for Data Profiling.
• XML source and target schema and object definitions.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure in Informatica Power Center.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensive knowledge in handling Slowly Changing Dimensions SCD Type I/II/III.
• Experience working with different OLAP BI Reporting Tools like Business Objects, Cognos.
• Skilled in developing Test Plans, Creating and Executing Test Cases.
• Followed effectively industry standards of HIPAA, ANSI837, ANSI834, ANSI-4010 and ANSI-5010 layouts.
• Experience working with SDLC, SCRUM, RUP, Waterfall and Agile methodologies.
• Reliable, responsible, hard working and good team player.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Designation: Sr. Informatica Developer

Responsibilities:

• Responsible for requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Involved in complete SDLC with data modeling form logical, physical and conceptual data model.
• Extracted data from various heterogeneous sources like Oracle, SQL Server and Flat files.
• Design Development and code in Informatica
• Manage Informatica team and assign the work to all developers.
• Worked with Power Center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor and Repository Manager.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
• Expensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Scheduling of the jobs as per the requirements using Workflow Manager along with Tidal Job scheduler.
• Worked with Index cache and Data cache in transformations like Rank, Lookup, Joiner and Aggregator Transformations.
• Extensively used Change Data Capture
• Completed documentation of database structures and processer used to move data in and out of the database for future development and explanation of database.
• Worked with offshore team migrating data from Development to Testing phase and coordinating with daily routine.
• Worked on Slow changing Dimension type II, III, and I
• Responsible for Unit Testing of mappings and workflows.

Environment: Informatica Power Center 9.1.0/8.6, TOAD, Oracle 11g/10g, MS SQL Server 2008, Tidal, SQL, PL/SQL, SQL Loader, SQL Assistant, UNIX shell Script, Putty, Windows 7/2000/NT.

Confidential

Designation: Sr. ETL Informatica Developer

Responsibilities:

• Designed Informatica mappings/sessions for external vendors to load customer and claim data from COBOL file into Enterprise Data Warehouse.
• Worked on Claims dimension and fact tables to determine if the Claim was paid In-network or Out of network. If it was paid In-network, then which network was utilized
• Created Operation Data Store on oracle database
• Worked on Stepwise integration project to integrate data from different source systems and reports from data warehouse to eliminate manual steps, reduce errors and increase efficiency.
• Worked on various post production defects and coordinated with QA/UAT team and business users to validate data, create test cases, business release and production support.
• Responsible for requirement gathering, Business Analysis, user meetings, discussing issues to be resolved and translated the user inputs into ETL design documents.
• Extracted data from various sources like Oracle, SQL Server, Flat files, and COBOL files.
• Worked on Power Center tools like Designer, Workflow Manager, Workflow Monitor, Task Developer, and Repository Manager.
• Assign work to developer in Informatica
• Followed HIPPA condition for ICD 10 in project
• Created Informatica mappings using various transformations like Filter, Normalizer, Router, Expression, Aggregator, Lookup, Source Qualifier, Joiner, Update Strategy, Rank, and Sorter.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Worked on Slowly Changing Dimensions Mappings of Type I, II and III.
• Involved in performance tuning for source, target, mappings, sessions and server.
• Tuned the mappings at session level by setting buffer size, cache size, increasing commit intervals etc.
• Wrote UNIX shell scripts to run stored procedures and packages to populate data in staging area.
• Involved in integration and sandbox testing for Informatica upgrade from version 8.6 to 9.1.

Environment: Informatica Power Center 9.1, Oracle 10g, Crontab, SQL Server, MS Access, Flat files, UNIX AIX, Erwin, TOAD, MS Excel.

Confidential

Designation: Sr. Integration Developer /Informatica

Responsibilities:

• Responsible for gathering suit of business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Created Source to Target Mapping Specification Document.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Developed mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Extracted data from different sources like DB2, Oracle, Flat files and loaded into ODS.
• Designed and developed complex aggregate, join, lookup transformation rules business rules to generate consolidated fact summary data identified by dimensions using Informatica ETL tool.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Created connected and unconnected Lookup transformation to look up the data from the source and target tables.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Used PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Ensured the Data Marts loads, runs on time accurately.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.
• People soft application engine was used to load the data marts.
• Created test cases and completed unit, integration and system tests for Data Warehouse.
• Worked with T-SQL and Extracted data originating from Sybase.
• Joined Tables Originating from Oracle and DB2.
• Used performance tuning techniques and Identify bottle necks
• Wrote test cases, test conditions for various derivatives and subject areas.

Environment: Informatica Power Center 8.6/8.1 Meta Data Repository, Designer, Server Manager , Teradata SQL Assistant, Teradata BTEQ, DB2, UDB, Business Objects, Oracle 10g, MS SQL Server, SQL, PL/SQL, SQL Loader, UNIX shell Script, Windows 2000/NT.

Confidential

Designation: Sr.ETL Informatica Developer/Data warehouse Developer

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Worked with Data warehouse design Star Schema, and Snowflake Schema and Dimensions.
• Moved mappings from development environment to test environment.
• Interacted with the business community and database administrators to identify business requirements and data realities.
• Imported and created source definitions from Oracle, SQL Server, Sybase and flat files.
• Created design document Informatica mappings bases on business requirement.
• Created Informatica mappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in dimension modeling used Ralph kimbal method.
• Extensively used performance improvement project.
• Involved in designing of testing plan Unit testing and System testing .
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Performance Maintenance including managing space, remove Bad Files and monitoring services.
• Set up permissions for groups and users in all Development Environments.
• Migration of developed objects across different environments.
• Also involved in conducting and leading the team meetings and providing Status report to project manager.

Environment: Informatica Power Center 8.6/9.1 Oracle 10g, PL/SQL, Windows, Erwin, DB2, Sybase 12.x/11.x and UNIX.

Confidential

Designation: Sr.ETL Informatica Developer

Responsibilities:

• Contributed in development of system requirements and design specifications.
• Participated in the design and development of Dimensional modeling.
• Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, connected and unconnected Look up, Expression, Aggregator, Update Strategy, Joiner, Filter and Router.
• Developed Mapplets to implement business rules using complex logic.
• Converted the PL/SQL procedures and SQL Loader scripts to Informatica mappings.
• Extensively used Informatica debugger to figure out the problems in mappings. Also, involved in troubleshooting existing ETL bugs.
• Tuned the sessions for better performance by eliminating various performance bottlenecks.
• Created and scheduled Sessions and Batches through Informatica Server Manager.
• Strong experience in slowly changing Dimension Mappings of type I, II and III.
• Expertise in Informatica command line utility pmcmd to schedule and control sessions and batches.
• Wrote UNIX shell scripts to automate the data transfer FTP process to and from the Source systems to schedule weekly and monthly loads/ jobs.
• Extensively worked in the performance tuning for the mappings and ETL procedures, both at designer and session level.
• At session level, tuned the mapping by setting the buffer size, cache size, increasing commit intervals etc.
• Analyzed Data models of the source systems to develop mapping specifications.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, SQL Server, TOAD, SQL, PL/SQL, Sybase, SQL Loader, Korn Shell scripts, Erwin, UNIX Solaris .

Confidential

Designation: Database Developer

Responsibilities:

• Worked with the Business to get the required Tables / Views information for different line of businesses.
• Worked with DDL, DML, DCL and TC commands on Tables / Views.
• Applied the indexes over the Table structures.
• Worked with Stored Procedures and Functions.
• Developed mappings using Power Mart Designer.
• Used to work on Stored Procedure, triggers, and Packages
• Created workflows for the different tasks using Workflow Manager.
• Involved in scheduling the workflows.
• Created flat file targets and FTP the file target to Remote Server.

Environment: Oracle 8i, PL/SQL, UNIX and Windows NT