• Around 8 years of experience in Information Technology with a strong background in Database development, Data warehousing, Data extraction using Informatica PowerCenter 9.x/8.x and Data analysis using IDQ Tool.
• Solid experience in Data warehousing concepts like Ralph Kimball methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Physical Modeling, Logical Data Modeling, Dimension Data Modeling using Erwin, Data Normalization and Informatica Client tools and Server tools.
• Extensive Data Warehouse experience using Informatica Power Center ETL tool on Oracle, Sybase, DB2 and SQL Server Databases.
• Well acquainted working with Informatica Power Center 9x/8x, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities, Informatica pmcmd, pmrep, infacmd command utilities.
• Experienced in implementing the business rules by creating transformations Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union, SCD's Type1,Type2,Type3 , and developing complex Mappings.
• Extensive experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load and pmcmd Informatica command line utility to create, schedule and control workflows, tasks, and sessions.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like flat files, XML files, Oracle, DB2, SQL Server into a common target area such as Data Marts and Data Warehouse.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2 and Flat Files fixed width , delimited
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in working with Informatica Data Quality IDQ for data and quality analysis.
• Excellent knowledge in identifying performance bottlenecks and tuning of the Informatica Load for better performance and efficiency.
• Experience in generating Score Cards for each stage of data analyzed.
• Extensive knowledge of PL/SQL, SQL programming.
• Involved in tuning the Oracle SQL queries by using Indexing techniques, Hints and Parallel execution process.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Experience in Scheduling Informatica sessions for automation of loads in Autosys.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Good understanding with all phases of SDLC System Development Life Cycle including Planning, Analysis, Design, Implementation and Maintenance.
• Strong Experience on RDBMS Concepts.
• Excellent understanding and best practice of Data Warehousing Concepts, involved in Full Development life cycle of Data Warehousing. Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis and research skills.
• Experience in Domains like Pharmaceuticals, Hospitality and Insurance.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

Database : Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005 and DB2.

Programming Languages: C, C , PL/SQL, SQL, Perl, UNIX shell scripting.

ETL Tools: Informatica Power Center 9.x and 8.x .

Data modeling tools: Erwin 4.x

Other Tools: TOAD, Oracle SQL Developer and IBM Sterling B2B Integrator.

WORK EXPERIENCE:

Confidential

Sr. Informatica Developer

Confidential, is a world's largest research based pharmaceutical company which discovers, develops and manufactures markets the medicines for humans and animals, as well as consumer products. The purpose of this project was to build sales data mart mainly to assist Sales and Marketing Department to calculate their market share in different segments based on geographical area and there by defining the strategy for each product segment.

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Extensively worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Implemented code using various Informatica transformations like Source qualifier, Joiner, Union, Expression, Lookup, Aggregate, Filter, Router, Normalizer, XML and Update Strategy.
• Developed SQL overrides in Source Qualifier and Lookup transformations according to business requirements.
• Used Connected /Unconnected Lookup Transformation to lookup the values in Flat Files and relational sources and targets.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in sales data mart as per the business requirements.
• Implemented different Tasks in workflows which include Session, Command, E-mail, Event-Wait, Event - Raise, Timer etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets, Transformation and Sessions by identifying and rectifying performance bottlenecks.
• Used stored procedures for creating dropping the indexes before the session run to improve the session performance and rebuild them after completion of session.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager
• Tested all the mappings and sessions in Development environment and migrated into Production environment after everything went successful.

Environment: Informatica Power Center 9.0.1/9.5.1, Oracle 11g, SQL Server, Delimited Flat Files, SQL Plus, PL/SQL , Autosys, Windows 7.

Confidential

Informatica Developer

Confidential, is one of the leading health insurance organization. The information systems for business was customized and utilizing the healthcare enterprise data warehouse to collect, organize and store data from all the sources to integrate the historic data for end user reporting.

Responsibilities:

• Implemented business plan based on required technical and business needs.
• Extensively used Informatica PowerCenter to create mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Developed and designed jobs using Informatica Designer based on mapping specifications using appropriate stages.
• Star schemas and Snow flake schemas were used in developing Informatica jobs.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Experience in migrating data from Oracle database using Informatica as ETL.
• Experience in using sql loader to load data from the given data-file into table or tables created in the database.
• By using Autosys, created the job which runs a UNIX script. The script in turn runs the pmcmd command to run a workflow.
• Experience in designing XML Schema as XML document allowing to validate the content and the structure of XML data.
• Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions.
• Used workflow tasks like reusable Email, Event wait, Timer, Command, Decision for defining the behavior of whole ETL process.
• Used pmcmd command to start, stop and ping server from UNIX and created UNIX SHELL Scripts to automate the process.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.
• Provided production support and performed enhancements on existing projects.

Environment: Informatica PowerCenter9.0.1, IDQ, Oracle 11i, Db2, Toad, SQL Server, ERWIN, XML Schema, UNIX, AutoSys Scheduler.

Confidential

Informatica developer

Confidential, is one of the world's leading Pharmaceutical Company, also a provider of Investment Products. Confidential empowers local business units to identify and provide products and services that meet the evolving needs of the customers, using distribution channels best suited to their local markets. The Project is to develop a new Investment Data Warehouse for Confidential to replace the existing Data warehouse. To re-design the data warehouse, approach to developing the new IDW is to sequentially develop the business intelligence applications required to manage the business.

Responsibilities:

• Analyzed existing process flows and business functionalities and prepared ETL process flow document for Predictive analysis.
• Extracted data from various heterogeneous sources like Oracle, SQL Server and Flat files.
• Worked with power center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation, Developer, Mapplet Designer and Mapping Designer.
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL override
• Extensively used various Active and Passive transformations like Filter, Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Used Debugger wizard to troubleshoot data and error conditions.
• Used Informatica row error logging feature to capture the logs in a relational table.
• Worked with Index cache and Data cache in transformations like Rank, Lookup, Joiner and Aggregator Transformations.
• Developed Reusable Transformations and Reusable Mapplets.
• Fined tuned the mappings and sessions to make them more efficient in terms of Performance.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Responsible for Best Practices like naming conventions, Performance Tuning and Error Handling.
• Worked with Shortcuts across shared and non shared folders.
• Migrated the code using export and Import utilities across various Instances.
• Optimized SQL queries for better performance.
• Expertise in using TOAD and SQL developer for accessing the Oracle database.
• Used Oracle SQL Loader to load data into RDBMS tables from excel files.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked with various Oracle Analytical functions like rank, row etc.
• Created Oracle stored procedures and triggers to automate the time consuming which were complicated for the standard SQL statements
• Responsible for Unit Testing of Mappings and Workflows.
• Created UNIX Shell scripts to start and stop sessions.

Environment: Informatica Power Center 9.0.1, Oracle 11i, Db2, Flat files, SQL/PLSQL, TOAD, UNIX shell scripting and Windows.

Confidential

Informatica Developer

Confidential provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare. The aim of the project at Confidential is to build consumers data mart, which will have all the consumers' data, claims and policies data for data analysis purpose.

Responsibilities:

• Involved in designing Conceptual, Logical and Physical model for Staging and Target data base.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Extensively involved in process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Extensively worked on tuning of Informatica mappings and sessions for better performance.
• Performance tuned ETL processes at the database level.
• Developed PL/SQL stored procedures and functions to accomplish small unit of work or tasks.
• Involved in basic Informatica administration such as creating users and privileges, folders, optimizing server settings, deployment groups etc.
• Analyzed and fixed production and test issues on a daily basis.
• Worked on different tasks in workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, assignment, timer and scheduling of the workflow.

Environment: Informatica 9.0.1, SQL Server, Oracle 9i, SQL Developer, XML, Windows XP, UNIX.

Confidential

Informatica Developer

Confidential, is the largest distributor of healthcare products and services to office-based practitioners. Customers include dental practices and laboratories, physician practices, and animal health clinics, as well as government and other institutions Henry Schein operates its four business groups - Dental, Medical, International, and Technology - through a centralized and automated distribution network, which provides customers in more than 200 countries with a comprehensive selection of more than 90,000 national and Henry Schein private-brand products in stock, as well as over 100,000 additional products available to our customers as special order items. The main objective of the project was to implant a sales data mart for the Insurance products. Informatica PowerCenter 8.6.1 was used as ETL tool to extract data from source system to target systems. The source systems were Oracle, Flat Files, SQL Server and the target was Oracle and Flat Files. Implemented various loading techniques like Slowly Changing Dimensions and Incremental Loading

Responsibilities:

• Design of ETL mappings for the CDC change data capture Responsible to analyze functional specification and prepared technical specification accordingly.
• Regular client communication for issue resolution over conference call, email, telephone
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command.
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation..
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation
• Extensively worked with various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency
• Worked with slowly changing dimension Type1, Type2, and Type3
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Extensively used Mapplets for use in mappings thereby saving valuable design time and effort
• Responsible for Production Support.
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
• Performance tune ETL programs, Maintenance and enhancements of ETL code.
• Worked extensively with the business intelligence team to incorporate any changes that they need in the delivered files

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, SQL, Shell Scripting, Windows XP.