PROFESSIONAL SUMMARY:

• 10 years of combined IT experience in Development, Maintenance, Production Support and Testing of various projects using Data Warehousing tools Informatica, Business Objects, SSIS and Databases Oracle, Teradata, SQL Server and DB2.
• Extensive work experience in the field of Data Warehousing, OLTP (Online analytical processing) and DSS (Decision support systems), using ETL tool, Informatica.
• Highly experienced in handling Incident management and Problem management processes
• Extensive work experience in Informatica Code development, Maintenance, Administration and Support.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, XML Generator and Re-usable transformations.
• Excellent experience in working with Business people, in understanding the Business requirements and issues.
• Performing IIT, SIT & UAT in delivering the Product and also written the test cases after the testing of the code in the Mappings and reviewed them with Business Users and technical team.
• Excellent Business knowledge in Insurance, Pharmaceutical Business area, Contract Administration and Management.
• Extensive experience in managing teams/On-Shore, Off-Shore Coordination/ Requirement Analysis/ Code reviews/ Implementing Standards.
• Excellent experience in different migrations, Unix to Linux migration, DB2 to Oracle migration and Informatica migrations.
• Experience in writing and debugging PL/SQL Procedures, Functions, Packages and Triggers.
• Good work experience in creating packages using Microsoft ETL tool, SSIS.
• Good work experience in Reporting tool, Business Objects.
• Good work experience in manual testing using tools, Test Director and Quality Center, Mingle.
• Excellent knowledge in Data warehousing concepts and dimensional modeling, Star schema and Snowflake schema.
• Good knowledge in Teradata database and Hadoop Hive.
• Excellent analytical and logical programming skills with a good understanding of the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

ETL Tool: Informatica 5.1/6.2/7.1.4/8.1.1/8.6,9.1, SSIS.

Reporting Tool: Business Objects 6.5/XI

Data modeling: ERWIN, Model mart

Database: Oracle 9i/10g, Teradata, DB2, SQL Server, MS Access.

OS: Windows NT/XP/2003, UNIX (Sun Solaris), Linux and MVS.

Testing tools: Test director, Quality center 9.2, Mingle, Jira

Languages: C, C++, Java, SQL, PL/SQL and UNIX shell scripting.

Scheduler: CA7, Tidal, Autosys and WA.

DB application tool: Toad 8.5/9.0/9.7 and PLSQL Developer

Contract management tools: iMany CARS, Medicaid.

Action Request System: Remedy

Deployment: Deployment manager, Merant tracker, Informatica TBD

Version control tool: Rational Clear Case, SVN, PVCS, Accurev.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr Informatica ETL Developer/ Lead ETL Developer

ROLES AND RESPONSIBILITIES:

• Gather requirements from functional IT or Business users
• Perform data analysis for any requirement and provide source to target mapping rule document
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.0/ 9.1.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Generator, XML target and Stored procedure transformations.
• Developed UNIX Shell Scripts for triggering the Informatica workflows using PMCMD command.
• Interacting with other support teams, DBA, Informatica support and System admin teams
• Working with other Development teams on the code conflicts and merge code changes
• Involved in code check-in activities for Informatica, DB and UNIX components
• Supporting 15 non-production environments for all kinds of ETL related batch issues.
• Involvement in every SDLC phases of the project
• Involved in Design walkthrough sessions with Business users and QA people
• Worked on several high priority Health care mandatory projects and delivered the code on time with very less number issues.
• Business interaction in case of any operational issue and co-ordinate with the different stake holders in order to address the business issues
• Provide the analysis on any ad hoc data request or analysis requested from business users
• Validate data processing components as per the requirements and perform data cleansing activities.
• Proposing and developing on system and business audits for each of the application
• Finding the bottlenecks and optimizing the data flow to get the best performance and tuning the SQL queries as well.

Environment: Informatica 8.6/9.1, Business Objects, Facets application, Oracle 10g, SQL, PLSQL, Teradata, SSIS,UNIX Scripting, Merant tracker, Deployment manager, Tidal, PVCS, SVN, Windows NT, UNIX and LINUX.

Confidential, San Francisco, CA

Sr Informatica ETL Developer/ Lead ETL Developer

ROLES AND RESPONSIBILITIES:

• Extract data from flat files and oracle database, applied business logic to load them in the central oracle data warehouse.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.0/ 9.1.
• Create reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.0/ 9.1.1. for extraction, loading and transformation (ETL) of data into the data warehouse.
• Implemented slowly changing dimension to populate and maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Reviewed the code developed by Offshore team members
• Created POCs for the new data load approaches.
• Created the Unit Test cases to the codes that has been Developed
• Involved in Attribute mapping/ Data mapping, and natural key profiling (data profiling).
• Involved in Design walkthroughs with Business users and QA.
• Interacting with the Business Users and verifying User requirements.
• Worked on different data sources such as Oracle and Flat files, Teradata target, XML targets etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Generator, XML target and Stored procedure transformations.
• Developed UNIX Shell Scripts for triggering the Informatica workflows using PMCMD command.
• Involved in UAT with Business and address any code or data issues.
• Involved in developing the Functional Requirement Design Document (FRD) and Business requirement Document(BRD)
• Created the separate sandbox environment for testing purpose.
• Worked on command line program pmcmd to interact with the server to start and stop Workflows.
• Gather the Business Requirements of theapplication.
• Create deployment groups, migrated the code into different environments.
• Write documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica 8.6/9.1, Business Objects, Oracle 10g, SQL, PLSQL, Teradata, SSIS,UNIX Scripting, Merant tracker, Deployment manager, Tidal, PVCS, SVN, Windows NT, UNIX and LINUX.

Confidential, Indianapolis, IN

Sr Informatica ETL Developer/IT Analyst

ROLES AND RESPONSIBILITIES:

• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter7.1.4/8.6.0.
• Doing the Data Analysis according to the Business to identify the root cause.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Written the Test cases to the codes that has been tested and are reviewed with Business users.
• Interact with Business people to assist them in resolving CARS application issues.
• Process data changes at the database level as per the request from Business.
• Interacting with the Business Users and verifying User requirements.
• Worked on different data sources such as Oracle, SQL Server, DB2, Cobol and Flat files etc.
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
• Involved in UAT with Business Requirements.
• Getting the inputs from Offshore team and at the user end in developing the Functional Requirement Design Document (FRD) and Business requirement Document(BRD)
• Created deployment groups, migrated the code into different environments.

Environment: Informatica, Business Objects, SQL, PLSQL, UNIX Scripting, SSIS,Teradata, Oracle, DB2, SQL Server, CA7, WA, Windows NT, UNIX, LINUX and Mainframe

Confidential

Informatica ETL Developer

ROLES AND RESPONSIBILITIES:

• Involved in system study, analyses of the requirements and designing of the complete system.
• Created Change Requests for each trouble ticket from the Business.
• Created Document of Understanding for enhancements and new code developments.
• Extracted data from different sources like Oracle and Flat files, and loaded into database.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Managed the Informatica Server sessions/batch and schedule them.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Created test cases and completed unit, integration and system tests for data mart system.
• Monitor the Informatica workflows and resolved the issues of any failures.
• Involved in Informatica code development using different transformations like Source Qualifier, Expression, Aggregator, Update, Filter, Joiner and Router.
• Prepared test scripts for FIT.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Involved in Informatica code development using different transformations like Source Qualifier, Expression, Aggregator, Update, Filter, Joiner and Router.
• Prepared test scripts for FIT.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.

Environment: Informatica 6.2, Business Objects 6.1, Oracle 8i database and Windows NT