SUMMARY:

• 7 years of experience in ETL process using Informatica PowerCenter.
• 6 years of extensive experience in writing Oracle PL/SQL Procedures, function, Tunning PL/SQL code and Informatica Mapping, Shell Scripting, using SQL Loader
• 6 years of experience in Data Modelling creating optimized Data Model using ERWin Tool.
• 3 years of experience in Reporting tools OBIEE 10/ 11g , COGNOS
• Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow Worklet Designer, used Informatica Repository Manager
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Strong Knowledge in optimizing database performance.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Solid Experience generating Reports in OBIEE 11g/10g, Cognos 9.0. and tensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Strong knowledge and experience in developing OBIEE Repository at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, OBIEE Security Setup users/groups, access / query privileges , configured OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Involved in end-to-end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics.
• Quick learner who swiftly grasps highly technical material, ramps up to tasks rapidly and delivers service withcomplete professionalism.

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Description: Working as Oracle SQL and PL/SQL and ETL Developer in Data Team of Epocrates supporting all the Engineering Team for Database releated tasks.

Responsibilities:

• Involved in Dimensional modeling Star Schema of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Heavily involved with ETL operation for Large Data Warehouse.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations
• to implement the business logic and to load the data incrementally
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier, Router, Normalizer, Lookup and Expression transformation
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Update strategy.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Implemented Financial Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process using Control M auto scheduling tool.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Develop the PL/SQL Procedure and Functions for various DW operation in Oracle 11g.
• Performed the tunning of Pl/SQL and SQL Queries used in ETL.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Given Production support to resolve the issues.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports using OBIEE 11g.

Environment : Informatica Powercenter 9.1, OBIEE 11g, Oracle 11g , SQL Developer and Oracle Toad tool, SQL Data Modeler and ERWin, Oracle Linux, Shell Script, WinSCP, P4, Notepad , TeraTerm, Oracle Enterprise Manager

Confidential

Sr. Informatica Developer

Description: Global Wealth Management Platform is a platform for financial advisor to carry out the all the wealth management operation

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Implemented Informatica 8 new SQL transformation for executing SQL statements.
• Created Data Mapping and used various Informatica Tranformation and loaded the data into Target. Heavily used Transformation like Router, Lookup, Source Qualifier, Filter, Joiner, Expression, Aggregator
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Designed the SCD Data model and Facts Table using ERWin tool.
• Developed SQL scripts, PL/SQL packages and procedures for Business rules check to implement business rules.
• Used bulk collections, indexes, materialized views to improve the SQL and PL/SQL performance.
• Migrated repository and Informatica mapping 7.1 to 8.0
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Used Informatica Designer to create complex mappings, transformations, source and target tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Used Exception handling logic in all mappings to handle the null values or rejected rows
• Query Optimization for improving the performance of the data warehouse.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter
• Extensively worked on RPD and developed various Subject Areas for Contracts, Service Request Install base modules and utilizing them for different criteria including charts, prompts, and pivot tables using OBIEE Answers and OBI Dashboards.

Environment: Informatica 8x, OBIEE, Oracle 10g, ERWin, SVN, SQL Data Modeler, SQL and PL/SQL, Putty, Toad, SQL Loader Utility, Shell Programming

Confidential

ETL Developer

Description: Eli Lilly is a pharmaceutical company for healthcare products.

• Used Informatica Power Center for extraction, loading and transformation ETL of data in the data warehouse.
• Worked on Large Manufacturing Company Data Warehouse, Dealing with differenct Sources, Performing complex transformation like Normalizer, Filter, Expression, Router and lookup
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor for creating the Mapping, Mapplet and creating the Workflow
• Extracted the data from the flat files and other RDBMS databases as well as various other Data sources and Performed ETL process and loaded them into Target
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Migration of mappings, sessions, worklets and workflows from Informatica 7.1 to Informatica 8.1

Environment: Informatica 8x, COGNOS, Oracle 10g, ERWin, VSS, SQL and PL/SQL, Putty, Toad, Shell Script

Confidential

ETL Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Developed the PL/SQL Procedure for performing the ETL operation
• Interacted with business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
• Extensively involved in Informatica Power Center upgrade from version 7.1.3 to version 8.5.1.
• Designed, developed Informatica mappings, enabling the extract, transform and loading of the data into target ECF tables on version 7.1.3 and 8.5.1.
• Involved in performance tuning and fixed bottle necks for the processes which are already running in production. Also gained 3-4 hours load time for each process.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window or load intervals.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively developed shell scripts for Informatica Pre-Session, Post-Session Scripts.
• Extensively involved in migration of Informatica Objects, Database objects from one environment to another.
• Tested data integrity among various sources, targets and various performance related issues.
• Involved in monitoring and production support in a 24/7 environment.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database
• Environment: Informatica 8x, Oracle 9i, SQL, PLSQL, SQL Loader, KORN Shell script, SQL developer, Oracle Forms 10g, Reports 9i

Confidential

Systems Engineer

Description: Alert and Case Management system iACMS is a web application which takes care about the management of Alerts and Case and also generate various reports of the Alerts, tasks and Activities for brief overview of the systems.

Responsibilities:

• Developed complex mappings using multiple Sources Targets in different databases and flat files.
• Designed and created Informatica mappings to construct data mart tables in accordance with the client requirements.
• Operatedwith various mappings including different transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup Unconnected Lookup, Rank, Expression, Router, Filter, and Aggregator Sequence Generator Transformation.
• Recommended ETL changes to improve maintainability, performance, data quality best practices.
• 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.
• Worked with various kinds of partitions and sub-partitions like Hash Partitioning Key, Range Partitioning etc.
• Extensively worked with various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations
• Extensively worked with Connected and Un-Connected Look up Transformations in the Designer of Informatica PowerCenter.
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Scheduled and deployed Informatica mappings according the business logic
• Worked with the Business Intelligence tools like Business Objects Desktop Intelligence, Web Intelligence, Infoview, Designer

Environment: Informatica, SQL Loader utility, PL/SQL, SQL Queries, Oracle 7/8i, BIRT, Toad for Oracle, MS Visio, JAVA, MS VSS,