SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Insurance and Financial.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica Power Center.
• Strong knowledge in OLAP systems, Kimball, and Inman methodology and models, Dimensional modeling using Star and Snowflake schema.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console).
• Experience in designing/developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup and Update Strategy, XML Source Qualifier.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Proficient in the integration of CRM data source such as Sales force and good knowledge on insert update.
• Extensive practicality of loading XML files using Power Center Client to fortunate knowledge on validating XSD on XML and experience in editing XML views to assign data types, precisions etc.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Worked extensively in various stages of SDLC like design, development, testing (QA, UAT, and Regression) and production support.
• Strong understanding in UNIX Shell scripts and writing SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Worked with cross - functional teams such as QA, DBA and Environment teams to deploy code from development to QA and from QA to Production server.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, Oracle, flat files.
• Good Experience in creation of Quality related documents (Function specification, ETL architecture design, High Level and Low Level design, and Unit Test Case documents).
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
• Excellent client relation skills with the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and the client community.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Work flow Manager, Task Manager).

Reporting Tools: Business Objects.

Databases: Oracle, DB2, MySQL, MS SQL Server, Salesforce.

Languages/Web: SQL, PL/SQL, SQL*Plus, HTML, ASP, Java, Shell Scripting and MS-Excel, XML, XSD, XSLT, HTML, Unix Korn Shell Scripting.

GUI Tools: SQL*Loader, TOAD, DataLoader Tool.

Modeling Tool: Erwin, Visio

Environment: HPUX, AIX 4.5, Solaris 2.x, MS Windows, Windows NT.

PROFESSIONAL EXPERIENCE

Confidential, Stevens Point, WI

Sr. Informatica Consultant

Responsibilities:

• Worked with architect and business managers to understand the requirement. Communicated with the DBA group to understand the source systems as well.
• Worked with Data modeler to understand the source to target mapping documents, the structure of the tables, how the final target looks like.
• Worked on E/R studio 7.6 for creating LDM and PDM and interacted with data architect to design source to target mapping document.
• Created technical design specifications based on functional and business requirements.
• Created complex mappings in Power Center Designer the transformations Sorter, Connected Lookup, Unconnected Lookup, Router, Union, Expression, Normalizer and Source Qualifier.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for each data set.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Created reusable sessions for different workflows.
• Wrote SQL scripts to verify counts, to validate the data and for Schema change.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Modified mappings as per the changed business requirements.
• Involved in analyzing the source data coming from different Data and for different line of business.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Based on technical designs, develop and test the required components in T-SQL.
• Involved in fixing invalid Mappings, creating History fix Script, Testing of Informatica Sessions and Workflows.
• Created parameters and variables for the reusable sessions. Created Email task, Decision task
• Responsible for creating the parameter files in order to connect to the right environment and data base.

Environment: Informatica Power Center 9.5.1, SQL Server 2012, T- SQL, SQL server Management studio, E/R Studio 9.5, T-SQL,TFS (Sharepoint), Microsoft Visual Studio(TFS), Quality center (ALM), ASG Zena Scheduler.

Confidential, Bloomington, IL

Sr. Informatica Consultant

Responsibilities:

• Understanding the Business and Technical migration rules for data mapping from Source to Target.
• Interacting with Requirements team to discuss the updates and discrepancies.
• Preparing SQL scripts for Extraction of data depending upon the required mapping documents.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union, XML Source Qualifier.
• Created mapping for loading of XML files using Power Center Client edited XML views to assign data types, precisions.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Created various tasks to give various conditions in the workflows.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for each objects.
• Created reusable sessions for different workflows. Wrote SQL scripts to verify counts and validate the data.
• Used UNIX shell scripting for the flat file to move onto the server and importing to the source and merging the data as well.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, flat files.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Produced a Unit test documents, which captures the test conditions and scripts, expected/actual results and volume for various processes.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys.
• Provided production support by monitoring the jobs and fixing the issues in a timely manner.

Environment: Informatica Power Center 9.5.1,SalesForce, DB2, SQL, UNIX, Shell script, Win SQL 7.0, Microsoft Visio, Win SCP, Micro Focus Rumba, Data Loader, Meta Data API, XML,XSD, Control-M scheduler.

Confidential, New York, NY

Sr. Informatica Consultant

Responsibilities:

• Worked with architect and business managers to understand the requirement. Communicated with the Golden Gate DBA group to understand the source systems as well.
• Worked with Database people from Golden gate to understand the environment. How they are managing source systems.
• Worked with Data modeler to understand the source to target mapping documents, the structure of the tables, how the final target looks like.
• Worked with Golden Gate DBA team to formulate the incremental loads, change data capture process via Golden Gate to Informatica interface.
• Worked on E/R studio 7.6 and interacted with data architect to design source to target mapping document.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Aggregator, Joiner, Normalizer, and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union, Rank, Stored Procedures, External Procedure, Sequence Generator and Transaction Control.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for each data set.
• Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.
• Created reusable sessions for different workflows.
• Worked on Cumulative Fact (Aggregate fact tables), Atomic Fact loading from all Dimensions in the Target. (Star Schema)
• Wrote SQL scripts to verify counts and validate the data.
• Used UNIX shell scripting for the flat file to move onto the server and importing to the source and merging the data as well.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.
• Used Informatica Scheduler to schedule the work flows as this organization is having Tidal Scheduler (Optional).
• Created parameters and variables for the reusable sessions. Created Email task, Decision task
• Worked on SQA environment to test the data before we move into Production Environment. Worked with DBA group to resolve performance.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Worked with data architect to create table and column definition to prepare the data dictionary for users.

Environment: Informatica Power Center 9.1, Informatica Data Quality, Oracle 9i, Oracle 11i RAC, PL/SQL, SQL, UNIX, Shell script, Toad 8.5.1, E/R Studio 7.6, T-SQL, SQA

Confidential, NY

Informatica Developer

Responsibilities:

• Collaborated with business analysts in requirements gathering, designing, testing, and project coordination.
• Used Informatica tools, including Repository Manager, Designer and Workflow Manager and Workflow Monitor.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Designed and developed various mappings, sessions and workflows to extract data from flat files, Oracle sources and load to Oracle and flat files.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Developed several PL/SQL stored procedures for pre/post session commands.
• Handle slowly changing dimensions of Type II to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Provided production support by monitoring the jobs and fixing the issues in a timely manner.
• Worked on fine tuning the existing mappings for better performance.
• Performed unit and integration testing. Performed tuning of SQL queries.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL Server 2000, T-SQL, UNIX, windows 2000

Confidential, Whippany, NJ

ETL Developer

Responsibilities:

• Involved in the Design, Development, Testing, Analysis, Requirements gathering, functional/technical specification, deploying.
• Worked with Business Analyst to understand the business and to design the architecture of the data flow.
• Developed Logical and Physical data models that capture current and future state data elements and data flows.
• Designing and customizing data models for Data Warehouse supporting data from multiple sources (Oracle, DB2, Excel, and Flat Files).
• Created Informatica mappings for initial load and daily updates.
• Designed and developed Informatica mappings to Extract, Transform and Load data into target tables.
• Modified mappings as per the changed business requirements.
• Extensively used various types of transformations such as Expression, Connected Lookup, unconnected Lookup, Filter, Router, Normalizer, and Update Strategy to transform the data.
• Created Dynamic parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Extensively used almost all transformations of Informatica including Lookups, Update Strategy and others.
• Extensively worked on Performance Tuning of ETL Procedures and processes.
• Extensively used PL/SQL programming in backend and front-end functions, procedures and packages to implement business rules.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed mappings for Type 1, Type 2 Slowly Changing Dimension (SCD).
• Worked with Session Logs, Workflow Logs and Debugger for Error Handling and Troubleshooting in all environments.
• Reviewed QA Test Plans and provided technical support during QA and Stage testing (UAT).
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.

Environment: Informatica Power Center 8.1, TOAD, Visio, Oracle 8i, IBM Mainframes DB2 7.0, Mercury Quality Center.

Confidential

ETL Developer

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system gather and define business requirements, improve business processes.
• Designed and developed PL/SQL functions, stored procedures, cursors, triggers and packages.
• Involved in designing the ER diagrams to create a normalized database
• Organized data in reports using Filters, sorting, ranking data with alerts.
• Created tables, views and stored Procedures
• Developed client side validation programs using Java Script to check the input.
• Provided End User Training and Support

Environment: Oracle 8i, PL/SQL, SQL*Plus, Oracle Forms 6i and Reports 6i, HTML, PHP, JavaScript, Windows XP