SUMMARY

• 7.5 Years of experience in Analysis, Design, Development, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse Consultant.
• Proficiency in utilizing ETL tool Informatica Power Center 9.x/8.x/7.x for developing the Data warehouse loads with work experience focused inData Acquisition and Data Integration.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems (COBOL files), Oracle, Flat Files ( fixed width, delimited ),DB2, SQL server, XML and Target databases Oracle, Teradata, SQL server, XML and Flat Files ( fixed width, delimited )
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization
• Extensive experience with database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Developed Teradata Loading and Unloading utilities like Fast Export, Fast Load, and Multiload (Mload).
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Having Experience with working with Insurance, Banking and Telecom domain clients.
• Excellent team player and self - starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x//7.x SQL Server Integration services.

OS: Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux, MS-DOS, Windows ME/ 2000/ 2003/ NT/ XP, Exceed (Editor)

Databases: Oracle (6.x/7.x/8.0/8i/9i/10g), SQL Server 2008/2005/2000 (T-SQL, Stored procedures, Triggers, DML, DDL, DTS), Teradata V2R5, Teradata V2R3, Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access, XML,DB2,VSAM

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML,JCL, JAVA Script, J2EE, CSS

DB Tools: SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Navigator, Oracle Enterprise Manager, Oracle WSGL/Web Tool kit

DM Tools: Toad, SQL Developer, Star-Schema, Snowflake-Schema

PROFESSIONAL EXPERIENCE

Confidential - Richmond, VA

ETL/Informatica Developer

Responsibilities:

• Worked with Informatica power center, DB2, oracle 10g, Teradata, Flat files and other sources to integrate data and also worked in Data warehouse Development life cycle.
• Worked with different mappings like getting data from Oracle tables and flat files, getting data from dimension and fact tables in 2 separate data marts and loading to oracle target tables. Also used pre-loaded stored procedures.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router etc in Mappings.
• Created Metadata manager Service, Reporting Service and Reference Table Manager Service in powercentre Admin Console to effectively use Metadata Manager.
• Configured the Reusable command task for sending the triggers, invoking different scripts and Reusable Email tasks for sending failure mail along with session details and appending logs with it and success mails. Also used Event wait, Event Raise, Scheduler options in the workflows.
• Developed SQL, PL/SQL, Stored Procedures, and triggers for Implementing Complex Business Rules, Transformations and Loading.
• Tuned various sql queries, mappings, targets and sources to improve the performance.
• Used session and workflow logs for debugging the session.
• Used debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Configured the workflows for running concurrently, used various types of migration techniques for moving code to Test environment from Development environment.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Worked with the QA team to resolve and fix the defects found.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL Server 2008, Teradata, PL/SQL, DB2, Windows XP, UNIX.

Confidential - Dublin, OH

ETL/Informatica Developer

Responsibilities:

• Involved in theData warehousedata modeling based on the client requirements
• Developed Logical and physical database designs for the transaction system.
• Responsible for migrating the folders or mappings/workflows from development to production environment, Created shortcuts to share the repository objects.
• UsedPMCMDcommand to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Responsible for configuring theWorkflow manager, Repository Server Administration Console, PowerCenter Server, Database Connection
• Performance tuningon sources, targets, mappings and SQL queries in the transformations
• Createdreusable transformationsandmappletsbased on the business rules to ease the development
• Used variousInformatica Error handling techniqueto debug failed session
• Done various optimization techniques inAggregator, Lookup, Joiner transformation
• Developed mapping to implement Type 2SCD\'s
• Used various debugging techniques to debug the mappings
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance
• Responsible for loading data into warehouse from different sources usingOracle loaderto load millions of records and used Import/Export utility to load small tables.
• Responsible for scheduling theworkflowbased on the nightly load.
• SupportedOracle 9idatabases running mission critical 24*7 systems.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL, HP/UX, Erwin Data Modeler, MS Visio, TOAD Tool, Windows XP, Teradata.

Confidential

ETL Developer

Responsibilities:

• Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 7.1. Re-engineered on existing Mappings to support new/changing business requirements.
• Used Mapping, Sessions Variables/Parameters, Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Involved in writing UNIX Shell scripts (Pre/Post Sessions commands) for the Sessions & wrote Shell scripts to kickoff workflows, unscheduled workflows, get status of workflows.
• Tuned SQL Statements, Mappings, Sources, Targets, Transformations, Sessions, Database, Network for the bottlenecks, used Informatica parallelism options to speed up data loading to target.
• Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations.
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions (SCD).
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for Designing and optimizing the Mapping.
• Created various tasks like Pre/Post Session, Command, Timer and Event wait.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Created Materialized view for summary data to improve the query performance.
• Prepared SQL Queries to validate the data in both source and target databases.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Created UNIX shell scripts to extract data from various sources like Oracle and Flat Files and loaded the transformed data into targets database and to schedule the session and workflow.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources to the target database.

Environment: Informatica Power Center 7.1.2, Oracle, Mainframe, DB2, COBOL, VSAM, SQL, PL/SQL

Confidential

Data warehouse/ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool by using Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Joiner, Update Strategy and Rank.
• Extensively involved in Performance Tuning issues.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Involved in loading data from flat files using SQL*Loader utility.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Migrated Mappings, Sessions and Workflows from Development to Test and then to Production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in developing ad-hoc and business reports according to the requirement.

Environment: Informatica Power Center 7.1.2, Oracle, SQL loader, UNIX, Windows NT

Confidential

Responsibilities:

• Supporting Client and Customer with their requirements.
• Making calls to customers and identifying customer needs.
• Presenting appropriate company product and service offerings.
• Ability to gain customer trust and provide exceptional follow-up.
• Forwarding the queries of customers to concern department.
• Explain the status offers & features of the different cards and loans.
• Raising the ticket for the issues regarding bills and payments.

Confidential

Responsibilities:

• Supporting Client and Customers with their requirements.
• Receiving calls from customers with a target of 180 calls per day.
• Handling queries and complaints of the customers and provide them solutions.
• Solving the queries of customers in supporting the client.