PROFESSIONAL SUMMARY:

• Expertise in Data warehouse using Informatica and ORACLE OLTP Database management 8i/9i databases. Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable objects for source, target, and Transformation objects.
• Extensive knowledge with Relational dimensional data modeling, star schema/snowflakes schema, Informatica Data Explorer IDE and Informatica Data Quality IDQ .
• Over 8 years of IT experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.x/ 8.x/7.x.
• Experience in data warehousing and business intelligence using various ETL tools Informatica, and Business Objects.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.
• Experience in working with building DW and OLTP systems and applying ETL
• Extensively worked with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Experience in working with business analysts to study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Support of Data Warehousing and Data Integration Solutions using Informatica Power center.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts, Java Sybase.
• Experienced in working with tools like TOAD,SQL Server Management studio and SQL plus for development and customization
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Exposure in overall SDLC including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, production support.
• Experience in creating Reusable Transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks Sessions, Command, Email and Non-Reusable Tasks Decision, Event Wait, Event Raise, Timer, Assignment, Work let, Control .
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Created Tables, Views, Macros in Teradata
• Used various Teradata Index techniques to improve the query performance.
• Extensive functional and technical exposure. Experience working on high-visibility projects
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL/Informatica Developer

We Deal with Confidential application data which supports the users to access their banking accounts to deposit, lend and cash management and investment services to more than 5 million consumers and small business customers. The data is fetched from Oracle Database, Loaded into Confidential and then loaded in Confidential for reporting purpose.

Responsibilities:

• Creating INFORMATICA mappings for the History tables with Slowly changing Dimensions Type2.
• Working on a set of table provided in BRS in a Iteration.
• Working on DMC's Data movement Control's from Oracle to ParAccel.
• Working with DB2, Oracle, Flat File Source data to ParAccel Target.
• Worked on Migration of Code from Informatica 8.6.1 to 9.1.
• Upgraded to Informatica 9.1 for the ParAccel Support of Informatica.
• Worked closely with the Testing Team in Resolving the issues in Quality Center.
• Creating Mapping for checking the DDL' mismatches in Source and target tables before start of Actual development.
• Using Putty to create Shell Scripts for running the workflows.
• Unit Testing using Test cases and creating a Unit Test document and uploading in Share point site allotted for the VERO's, CDW legacy tables and SFCDM tables.
• Working on History table's, Current Table's, Dimension table's, Code table's and Fact table's present in our DATA mart system.
• Supporting SIT and UAT Team in resolving Issues.
• Working on re-work of mapping with changing BRS, Re-Unit testing and updating Documents.
• Creating Jil Scripts for the Autosys Automated Job Running in allotted time for a Data Mart.
• Actively participated in Deployment of code into SIT environment and UAT environment after the completion of development for a Set of table's an Iteration.
• Worked on creating view in IBM Clear Case for the Backup of all the developed mappings.
• Worked with the Integrating Team and raising request for the deployment of developed code in SIT and UAT environment.
• Worked closely with Performance Team in creating Scripts for improved performance.

Environment: Informatica 8.6.1, 9.1, DB2, Oracle, Flat Files, ParAccel, Rapid SQL, PSQL, SQL plus, Putty Tool, HP ALM QC , Autosys, IBM Clear Case, Windows 7, Unix, WinSCP, BeyondCompare.

Confidential

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in all phases of software development life cycle.
• Involved in requirements gathering and analysis to define functional specifications.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing the Informatica Mappings.
• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
• Created and analyzed Process Work Flows, Scope Functional Specifications, and was responsible for preparing Software Requirement Specifications SRS and Functional Specification Documents FSD . .
• Extracted data from wide variety of data Sources like Flat files and Relational Databases Oracle SQL Server .
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter Data Modeling.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Extensively used various Data Cleansing and Data Conversion functions like Ltrim, Rtrim, Isnull, Isdate,To Date, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Extensively used Pre-Session and Post-Session Success commands to merge the different files to a single file.
• Created and tested Informatica mappings and workflows to automate Job scheduling..
• Worked on Performance tuning to increase the throughput of the data load like read the data from flat file write the data into target flat files to identify the bottlenecks .
• Worked on SQL Server Integration Services SSIS to integrate and analyse data from multiple heterogeneous information sources Oracle Sybase
• Worked with T-SQL to create tables, views and triggers and stored procedures.
• Written database triggers in T-SQL to check the referential integrity of the database.
• Created packages in SSIS with error handling.
• Written various Unit and Integration test cases and executed.
• Provided knowledge transfer to the end users and created extensive documentation on the design, implementation, daily loads and process flows of the mappings.

Environment: Informatica Power Center 8.6 Repository Manager, Designer, Workflow Manager, Workflow Monitor SQL Query Analyzer 8.0, Oracle 9i/10g, Toad, SQL Developer 1.1.2, DB2.

Confidential

Role: Informatica Developer

Confidential is one of the Leading pharmaceutical industries in the Confidential. The main objective of Contract Sales System Confidential is to support Sales Representatives with Physicians and Hospitals contract information. Sales, Marketing Contract information was collected from different tests conducted on the subjects. Data mart helps build Monthly sales report for every Professional or Organization in contract

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.
• 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 and data flow management into multiple targets using Router transformations
• 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
• 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.
• Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• 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.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performance related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Used Informatica power connect to connect external Data bases.
• Involved in Unit, Integration, system, and performance testing levels
• Extensively used SQL loader to load data from flat files to the database tables in Oracle.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Created various data marts from data warehouse and generated reports using Cognos
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Good knowledge in Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio.

Environment: Informatica Power Center 9.1/ 8.6 Designer, Workflow Manager, Workflow Monitor Cognos 10 BI, Oracle10g/11g, SQL Server 2008, SQL, Erwin 4.0, TOAD 9.5, Star Schema, UNIX Shell Scripts, AS/400,Cognos 8.x , Flat files, Windows XP, and MS-Office tools.

Confidential

ETL Informatica Developer

Confidential provides consumer, commercial, investment, brokerage and trust banking services, as well as leasing, mortgage services, to individuals and businesses. The project was to design, develop and maintain a data warehouse to understand the client needs, undertake trend analysis, provide better customer service and assess current and future profitability, Cross-sell products to increase revenue generation from the most profitable customers.

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting
• Requirements and project plan for intranet applications for Fixed Income and Equities.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.1.2, MS SQL 2000, Oracle 9i, SQL, PL/SQL, ERwin, UNIX Shell Scripting, Windows XP and 2000, Tivoli.

Confidential

Database/ETL Developer

Contributed to building a Data Warehouse to analyze the information about their sales and human resources. Designed Physical, Logical models and developed mappings, transformations, sessions, workflows, and store procedures to load in to a Data Warehouse.

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Involved in designing the procedures for getting the data from Flat files, Databases to Data Warehousing system.
• Created mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Creating and running sessions and batches to load the data into the Target Database.

Environnent : Windows, Oracle 8i, Informatica 5.1.